Database View is not showing any results in the list view, But showing total count of results in the DB view. - Support and Troubleshooting

Database View is not showing any results in the list view, But showing total count of results in the DB view. Issue The customer is unable to see records in the DB view

Error message: Syntax Error or Access Rule Violation detected by database ((conn=46111703) Unknown column ' . ' in 'field list')

Symptoms Navigate to database view, click on "Try it" to open in list view No records appear in the list view. Error shows like "Syntax Error or Access Rule Violation detected by database ((conn=46111703) Unknown column ' . ' in 'field list')"

Release After Utah

Cause A database view query cannot generate the result for the functional field on the tables involved in the database view. Validate if the tables involved with the affected DB view have the "functional field = True" in the sys_dictionary table. Resolution Option 1:

Disable the functional fields on the affected table at the sys_dictionary level Validate the DB view, works as expected. Option 2:

In case the function fields are needed, Need to manually add some fields on the view fields for the affected table (like Change_request, task...) in the database view as shown in the related document below. So we are basically not retrieving all the fields of the affected table in the database view by adding "View fields". Only retrieving the fields that are needed to view from the DB view. Related Links https://www.servicenow.com/docs/csh?topicname=c_SpecifyAFieldToReturn.html&version=latest