Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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.

 

7 REPLIES 7

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