34 views

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

Article Information

Last Updated:2018-09-05 06:08:51
Published:2018-09-05