Company table data not showing

[SK Chand Basha]

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?

We don't have any security rules in place.

[SK Chand Basha]

Hi @Ankur Bawiskar 

Yes, I saw that we don't have any query business rules 

I have attached the screenshot in above replay.

Thank you.

[Ankur Bawiskar]

@SK Chand Basha 

is your instance domain separated? -> if yes then see any domain is restricting

are you checking with admin user or non-admin?

was this working fine earlier?

[lauri457]

It definitely looks like a situation where you:

1. Pass the row level acl
2. Pass field level acl(s) on at least one row in the query but fail the on the rows showing on the list

Is the row count correct? Are admin users impacted or just some users? What does access analyzer/debug security tell you? Flush cache (cache.do) and review ACLs. Do you have a field on core_company with the "Field Query Restrict Record Access" attribute? Do the preview icons have valid href urls? Add "&sysparm_force_row_count=1359" to the url to force load all the records and see if any are loaded fully. 

[SK Chand Basha · Accepted solution]

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