All Record Producers and Catalog Items showing the same Error..

RajatG
Tera Expert
Error Message : Syntax Error or Access Rule Violation detected by database ((conn=70367) Unknown column 'sc_cat_item1.roles' in 'field list')
 
1 ACCEPTED SOLUTION

RajatG
Tera Expert

Field Named  'roles' was marked as display 'true' in the sc_cat_item table , reverting it back to false fixed the error.

View solution in original post

5 REPLIES 5

palanikumar
Mega Sage

Hi,

Check whether any deleted column is still used in the form and record producer

Thank you,
Palani

J Siva
Tera Sage

Ankur Bawiskar
Tera Patron
Tera Patron

@RajatG 

are those OOTB record producers or custom one?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

None is opening be it OOTB or a custom one.