Notifications

72 views

Symptoms


On mobile or accessing $m.do, forms that contain a reference to cmdb_ci throws database errors when the search field is used. In addition the select box shows no found options when search is used.

Syntax Error or Access Rule Violation detected by database (Unknown column "sys_user0.name" in "where clause")

Release


Jakarta, Kingston

Cause


Large amount of records in the cmdb_ci table can overwhelm the query and cause it to fail.

Resolution


Create the Table Title. This will restrict the cmdb_ci search query to only look at the columns you designate.  You can add additional columns to the Search Fields as needed.
 
Here's some documentation:  https://docs.servicenow.com/bundle/kingston-platform-user-interface/page/administer/tablet-mobile-ui/task/configure-mobile-list-search-fields.html

 

Article Information

Last Updated:2018-08-30 09:33:37
Published:2018-08-30