Error: Syntax Error or Access Rule Violation detected by database (Unknown column 'sys_package8.sys_tags' in 'field list')

[robbing]

      Hi all, still learning Servicenow.   I am getting the following error message when trying to open the Applications table:

Syntax Error or Access Rule Violation detected by database (Unknown column 'sys_package8.sys_tags' in 'field list')

I was asked try troubleshooting the problem, so I don't have any info on what was being done in the system prior to this error message appearing. I did look at a similar thread on an almost identical issue (https://community.servicenow.com/thread/173216?q=Syntax%20Error%20or%20Access%20Rule%20Violation%20d...), I'm struggling to find a "sys_package8.sys_tags" column in the field list. (Table>Config>Dictionary entries or Table>Config>List Config are the right places to look, correct?). Anyway, please let me know if you're familiar with this error and what you recommend to fix it.

As a newbie, if you can give me clear and detailed feedback, that'd be enormously helpful.

Thanks!

[robbing]

And FWIW, I found a sys_package table in Dictionary Entries, but I don't see a sys_package8 or a sys_tags in Dictionary Entries.

[robbing · Accepted solution]

Resolved by finding a column titled Tags in the table. By removing it as a displayed column, my data returned to view and the error disappeared.

[Sharon Hobart]

I'm seeing the same issue but with CMDB_CI:   Syntax Error or Access Rule Violation detected by database (Unknown column 'cmdb_ci_network_adapter2.mac_address' in 'field list')

I'm not following what your solution was.   Can you explain further?

[robbing]

Hi Sharon,

First go to your table. Between the column headers, right click, select configure, select list layout. Then, in the list of columns in the table (right side, not left), I found one titled Tags.   In your case, you should see one that says Mac Address.   If you remove that, the error should be fixed. In my case, I didn't need the Tags title, so hopefully its the same case for you.

Let me know if that doesn't work for you.