cmdb_ci_computer list view not showing records

[M_iA]

Strange thing has started happening in Xanadu.

If I open cmdb_ci_computer in the CMDB, no records show in the list view. Theyre there and the number at the bottom confirms this.

If I go to the base table and select where class = computer, these show as expected and I can open them and view them on the cmdb_ci_computer class table. This is not a security/permissions issue.

All other classes seem to be fine from the selection ive looked at that we use most frequently.

[OlaN]

Hi,

Is this a subprod instance ?
This can happen if the base table is cleared, but the extended table is preserved during the cloning process.

[M_iA]

Unfortunately not @OlaN 

This is in our production instance as well as our subprod's

[reg_1979]

Hi, I have experienced this as well. It affects users randomly and seems to just be limited to our "cmdb_ci" tables. No report, list components or widget records will load for the affected user and table either. 

Here's a really gross workaround that I've found.

1) Navigate to the affected user's table, you will have to impersonate each affected user (ugh).

2) Use the top list search (not global) and search for any name.

3) The list of records should load, and miraculously all of the reports, list widgets, etc.

Good luck!

[M_iA · Accepted solution]

Sorry for not responding sooner @reg_1979 

I have managed to get a response from SN about this. Its actually a known problem! Sort the list by anything other than updated. All items will then come back into view!

PRB1818225

Description: Xanadu: 

An order by on a single field with a LIMIT clause can cause a Syntax Error or Access Rule Violation 

Workaround: 

1. Sort the table with any column other than 'updated' and the records will be displayed as expected. 

2. The sorting of the table with any other column will update the preference of the user so that every time a user opens the list it will open with the previously sorted column. 

3. Hence the issue is temporarily resolved.