Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Syntax Error or Access Rule Violation detected by database ((conn=645567) Unknown column 'cmdb0.a_ref_1' in 'where clause')

Harshal Sonawa1
Kilo Guru

‎01-13-2022 03:19 AM

When I go to database view impersonating specific user I get this error.

Syntax Error or Access Rule Violation detected by database ((conn=645567) Unknown column 'cmdb0.a_ref_1' in 'where clause')

0 Helpfuls
  • 1,179 Views
5 REPLIES 5

Harshal Sonawa1
Kilo Guru
In response to Bhavana Reddy

‎06-29-2022 01:26 AM

Hi @Bhavana Reddy ,

I had one query business rule which use to execute for that database view. 

In that BR, referencing was not done properly which caused this issue. You may describe your problem in depth, if possible I could suggest something than.

 

Thanks,

Harshal