/build/static/layout/Breadcrumb_cap_w.png

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
  • just found this in the server error log if it helps..

    [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 7 years ago

Answers (1)

Posted by: akmagnum 7 years ago
Red Belt
0

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 7 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ