Inventory - Devices - There was an error retrieving the data for this page. Please refresh the page. If the error persists, try resetting the default page layout.
Hi
I'm a new KACE user here, I have installed the free version to take it for a test run. was working OK with a couple of clients. This afternoon I added about more and have about 40 clients now. all Dell precision desktop/laptops if that matters..
However the Inventory-Device page is now broken and giving me the error above and not displaying any machines. I did add the "model" column to the view and it worked and then it broke at some point after that.
I did do a search for this error but people seemed to be talking about the ticket search rather than the device search.
Any help would be greatly appreciated.
Thanks
Nathan
1 Comment
[ + ] Show comment
Answers (1)
Please log in to answer
Posted by:
akmagnum
6 years ago
This can happen sometimes, don't panic.....although in your case its a bit
weird given the very few machines you have connected.
Usually a log-off and logon again can fix it.
If not ....then do an appliance reboot.
But choose the option to "Reboot and check database".
-->Settings --> Appliance Updates --> Reboot and check database
Hope it helps
Comments:
-
already tried that akmagnum and no luck.. should have mentioned that.. one of the first things I tried - nathano 6 years ago
[Tue Jun 20 08:27:49.377087 2017] [proxy_fcgi:error] [pid 76686:tid 34468879360] [client 192.168.202.124:63310] AH01071: Got error 'PHP message: Exception in KGridPage::GetPagedData: mysqli error: [1054: Unknown column 'ASSET_ARCHIVE' in 'order clause'] in EXECUTE("select * from (SELECT MACHINE.ID, SYSTEM_DESCRIPTION, SC.CLIENT_CONNECTED, (CASE WHEN REMOTE_HOST_KUID.LAST_RESULT IS NULL THEN 1 ELSE REMOTE_HOST_KUID.LAST_RESULT END) AS AGENTLESS_CONNECTION_STATUS, USER_LOGGED, MACHINE.NAME AS SYSTEM_NAME, MACHINE.IP, (UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC)) as LAST_SYNC_TIME, (UNIX_TIMESTAMP(LAST_SYNC))as LAST_SYNC_SECONDS, LAST_REBOOT, CSP_ID_NUMBER, MACHINE.CLIENT_VERSION, MANUAL_ENTRY, MACHINE.KUID, MACHINE.NOTES, LAST_SYNC, MACHINE.CREATED, MACHINE.MODIFIED, case MANUAL_ENTRY when 0 then 'Agent' when 1 then 'Manual' when 2 then 'WSAPI' when 3 then case REMOTE_HOST.PROTOCOL when 1 then 'SSH/Telnet' when 2 then 'SNMP' when 3 then 'WinRM' when 4 then 'Google Admin Console' when 5 then 'Dell Mobility Management' when 6 then 'VMware' when 7 then 'AirWatch' when 8 then 'Google Admin Console' else 'Agentless' end else 'Unknown' end as SOURCE, OS_NAME, SERVICE_PACK, RAM_TOTAL, CS_MANUFACTURER, CS_MODEL, CS_DOMAIN, TZ_AGENT, VIRTUAL, CHASSIS_TYPE, IF(KUID_ORG.ORGANIZATION_ID IS NULL OR substring(SCHEMA(),4) = KUID_ORG.ORGANIZATION_ID, 1, 0) AS SYNC_THIS_ORG, MACHINE.ID as TOPIC_ID , (select distinct true from LABEL Lx join MACHINE_LABEL_JT MLJTx on Lx.ID = MLJTx.LABEL_ID left join MACHINE M on M.ID = MLJTx.MACHINE_ID left join OPERATING_SYSTEMS OS on OS.ID = M.OS_ID left join KBSYS.OS_FAMILY OSF on OSF.INTERNAL_NAME = OS.FAMILY where OSF.METER_SUPPORTED = 1 AND Lx.METER_ENABLED = 1 AND MLJTx.MACHINE_ID = MACHINE.ID AND MACHINE.MANUAL_ENTRY != 1) as ENABLED FROM MACHINE LEFT JOIN KBSYS.KUID_ORGANIZATION KUID_ORG ON KUID_ORG.KUID = MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION SC ON MACHINE.KUID = SC.KUID AND substring(SCHEMA(),4) = KUID_ORG.ORGANIZATION_ID LEFT JOIN REMOTE_HOST_KUID ON REMOTE_HOST_KUID.KUID = MACHINE.KUID LEFT JOIN REMOTE_HOST ON REMOTE_HOST.REMOTE_HOST_ID = REMOTE_HOST_KUID.REMOTE_HOST_ID GROUP BY MACHINE.ID) as datatable_query order by ASSET_ARCHIVE asc limit 250 offset 0")\n\n', referer: https://kace.haulmark.local/adminui/computer_inventory.php - nathano 6 years ago