Getting error "Syntax Error or Access Rule Violation detected by database (conn=177111)"

[souvikmallick]

Getting error "Syntax Error or Access Rule Violation detected by database ((conn=177111) Table 'instancename_1.778cf3bf37232110bcd6473174924b' doesn't exist)". I am getting this error after i have deleted a table from the instance. The table is being deleted successfully.

[Sandeep Rajput]

@souvikmallick Please refer to this post https://www.servicenow.com/community/developer-forum/syntax-error-or-access-rule-violation-detected-... similar issue was reported here.

In a nut shell, you need to check if there are any ACLs, reports defined on the deleted table which still exists.

Create a support case with ServiceNow if none of the suggestion work for you.

[souvikmallick]

When a table is deleted, the associated ACLs are also deleted. So i am assuming ACLs are not the issue, I  have also verified that there are no associated reports. I deleted this table previously and also restored it and did not see this issue back then. 

[Sandeep Rajput]

There must be something which was referring to this table which got unlinked when you deleted the table. Since you restored the table back everything went back to how it was earlier.

[Rajesh Chopade1]

hi @souvikmallick 

The error suggests that there may still be references to the deleted table in your instance.

Look for any active references to the deleted table in other tables, such as BR, Script include, workflows, scheduled jobs.

Sometimes, cached information can cause issues. Clear your instance cache.

If there were any records in the deleted table that were being referenced elsewhere (like in another table), those references may need to be removed or updated.

If above options not helps then check the System Logs under System Logs > System Log > All to see if there are more details about what is triggering the error.

thank you

Rajesh