-
Título
There was an error retrieving the data for this page message while sorting columns -
Descrição
The appliance might get an error "There was an error retrieving the data for this page. Please refresh the page. If the error persists, try resetting the default page layout." This error often occurs when attempting to retrieve or display ticketing data, inventory information, patching information, and other modules.
Below, an example:
-
Causa
This is caused by the column pointing to a table with a different name; it can confirmed by clicking on each column to find out which one is causing the error.
The Server Errors Log might say something like
AH01071: Got error 'PHP message: Exception in KGridPage::GetPagedData: mysqli error: [1054: Unknown column 'TIME_CREATED' in 'order clause'] in EXECUTE("select *from (select HD_ARCHIVE_TICKET* -
Resolução
A- Attempt the Reset to Default Layout
The first step in troubleshooting the error is to click the button provided to Reset to Default Layout. Although this may not always work, it is a recommended initial step to rule out any minor glitches or temporary issues.
B- Sorting Columns- Click each column to sort until one shows the "^" or "⌄" symbol and data is loaded without errors.
- After this happens, go to another page of the SMA on the SMA, without logging out, so the configuration is retained and come back to the same page.
- Click the reset layout button, even if the data is rendering correctly. This will ensure that the error doesn't come back.
If you still have issues with loading a certain page, please open a ticket with Support.