The CreatorCon Call for Content is officially open! Get started here.

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

robbing
Mega Contributor

      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!
1 ACCEPTED SOLUTION

robbing
Mega Contributor

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.


View solution in original post

8 REPLIES 8

saidarao
Tera Contributor

I am seeing the same issue while generating  report from sc_task table  :Syntax Error or Access Rule Violation defected by database(Unknown column 'sc_item_option.value' in 'field list')

VEDANSH RANA
Tera Contributor

Hi Sai,

 

Were you able to resolve this issue, Can you help me with this. I am receiving same kind of error on same table you are using[sc_task]

 

Regards,

Vedansh

Hello Vedansh,

were you able to resolve this issue, I'm having same error on table "cmdb_ci_database"

Regards,
Akshay

Joy _FHLBSF_
Tera Contributor

Hi, I have the same problem  Syntax Error or Access Rule Violation detected by database ((conn=85056) Unknown column 'ritm.approval_set' in 'field list').  I have tried to follow the steps from this thread but I can't still get rid of this error. Hope to get some answers. Thanks in advance