Issue
Symptoms
While running the out of the box provided database view "matching_user_group_skills", getting below error:
Error Message Syntax Error or Access Rule Violation detected by database (Unknown column 'sys_user_group0.type' in 'where clause')
Release
Any supported release.
Cause
Reviewing the "matching_user_group_skills" database view revealed that system couldn't find the "user_task_stats" table and hence it had orange color dot on the view tables section of the database view.
Table "user_task_stats" is coming from a plugin called "Resource Matching Engine" (Id="com.snc.matching_rule"). And this plugin was not active on the affected instance and hence "user_task_stats" table was not available.
Eventually this failed the "matching_user_group_skills" database view.
Resolution
Get the "Resource Matching Engine" (Id="com.snc.matching_rule") plugin activated, it should create the missing "user_task_stats" table and hence should resolve the issue with "matching_user_group_skills" database view.
