Why out of the box provided database view "matching_user_group_skills" not working and displaying message "Error MessageSyntax Error or Access Rule Violation detected by database"? - Support and Troubleshooting

Why out of the box provided database view "matching_user_group_skills" not working and displaying message "Error MessageSyntax Error or Access Rule Violation detected by database"? 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.

Additional Information Database views

Resource Matching Engine plugin