Company table data not showing

SK Chand Basha
Tera Sage
Tera Sage

Hello everyone,


In a few ServiceNow instances, when we open the Company field data, no records are visible—even though data actually exists.

 

When I check the core_company table, the record count is displayed, but the records themselves do not appear. If I try to open a record directly, it shows "Record not found."

 

How can we fix this issue in ServiceNow?

SKChandBasha_0-1765420691467.png

We don't have any security rules in place.

 

1 ACCEPTED SOLUTION

SK Chand Basha
Tera Sage
Tera Sage

Hello Everyone

I have raised a case with servicenow now it is working fine

The issue is hitting PRB1952766 in Zurich Relase and the below the workaround

1) Navigate to System Properties
2) Open the property named "glide.cmdb.query.execution_mode". Out of box, this will have a value of "v2".
3) Update the value to "v1", which will change execution behavior to pre-Zurich.
4) Save the property

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


And have cleared the brave search engine cache 

View solution in original post

8 REPLIES 8

lpruit2
Kilo Sage

Greetings @SK Chand Basha. Have you checked the Access Control (ACL) table [sys_security_acl] to see which Role(s) is mapped to the "read" ACL? Below is a screenshot of one of the "read" ACLs from my Personal Developer Instance (PDI). Can you check either the ACL table or if the account you are testing with has one of these Roles: model_manager, itil or user_admin role?

 

lpruit2_0-1765423720702.png

 

Ankur Bawiskar
Tera Patron
Tera Patron

@SK Chand Basha 

there must be some query business rule on core_company table which is restricting the data

AnkurBawiskar_0-1765425550441.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

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

SK Chand Basha
Tera Sage
Tera Sage

Hi @Ankur Bawiskar @lpruit2 

If i we open with safari browser it is showing data sometimes , we don't have any security rules 

SKChandBasha_0-1765430216418.png

 

@SK Chand Basha 

I am referring to query business rule and not ACL

Did you check that?

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

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