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

[Harshal Sonawa1]

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')

[Ankur Bawiskar]

Hi,

check these links which talk about the same

Syntax Error or Access Rule Violation detected by database ((conn=874917) Unknown column 'bs.a_ref_6...

Syntax Error or Access Rule Violation detected by database (Unknown column 'task6.u_incident_alert' ...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0714647

Regards
Ankur

[Ankur Bawiskar]

@Harshal Sonawane

Hope you are doing good.

Did my reply answer your question?

If so, please mark appropriate response as correct & helpful so that the question will appear as resolved for others who may have a similar question in the future.

If not, please let us know if you need some more assistance.

Thanks!
Ankur

[Harshal Sonawa1]

I have gone through above links before also still I am not able to get why I am getting this error.

When I impersonate another user and go to Database view I am able to view it.

I also check ACL's still not found any thing what's the cause.

[Bhavana Reddy]

Hi Harshal,

Can you please help me if u found the solution, i have also same issue and unable to resolve this issue

Please guide me !!