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

[Mason Angus]

I am getting this error "Syntax Error or Access Rule Violation detected by database ((conn=874917) Unknown column 'bs.a_ref_6' in 'on clause'" every time I try and run a database view on a table. The column is visible and the syntax is correct. If I don't left join the tables this problem doesn't happen and I read about storage aliases being a cause of the problem but I am not sure how to proceed with trouble shooting. Let me know what I should do. 

[Onkar Pandav · Accepted solution]

Hi,

Please check with below points.

1. The field name might have been deleted but still being used in the view/report.

2. Cross verify if the field name used in the report is correct.

3. Cross check if there is any ACL on that column.

Also check below links that may help you.

https://community.servicenow.com/community?id=community_question&sys_id=eeeb8fe1db9cdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=ae6c2c3cdb49fb40feb1a851ca96...

If still it doesn't solve your error then create a HI ticket.

Mark helpful/correct if you found so.

[Bhavana Reddy]

Hi Onkar,

I am getting below error message "Syntax Error or Access Rule Violation detected by database ((conn=2914849) Unknown column 'sn_prd_pm_specification.name' in 'where clause')"

Can you please help why we are getting such kind of errors?