Kace console no longer shows installed devices
I'm using Kace Express and added more than 200 devices successfully, but I installed the kace agent on 4 more machines and they are not appearing on the console.
I checked the Log Server Errors found the entries below:
[Tue Jul 02 08:29:03.326212 2019] [proxy_fcgi:error] [pid 72342:tid 34452277760] [client 192.168.3.56:53212] AH01071: Got error 'PHP message: Exception in KGridPage::GetPagedData: mysqli error: [1054: Unknown column 'ASSET_LOCATION.NAME' in 'where clause'] in EXECUTE("select count(*) 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, MACHINE.IPV6, LAST_REBOOT, CSP_ID_NUMBER, MACHINE.CLIENT_VERSION, MANUAL_ENTRY, MACHINE.KUID, MACHINE.NOTES, LAST_SYNC, timestampdiff(SECOND, MACHINE.LAST_SYNC, now()) as LAST_SYNC_SECONDS_SINCE, LAST_INVENTORY, timestampdiff(SECOND, MACHINE.LAST_INVENTORY, now()) as LAST_INVENTORY_SECONDS_SINCE, MACHINE.CREATED, MACHINE.MODIFIED, case MANUAL_ENTRY when 0 then 'Agent' when 1 then 'Manual' when 2 then 'WSAPI' when 3 then REMOTE_HOST_PROTOCOL.SOURCE 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 LEFT JOIN REMOTE_HOST_PROTOCOL ON REMOTE_HOST.PROTOCOL = REMOTE_HOST_PROTOCOL.REMOTE_HOST_PROTOCOL_ID LEFT JOIN ASSET_BARCODE_JT ABJT ON ABJT.ASSET_ID = ASSET.ID\n LEFT JOIN BARCODE ON BARCODE.ID = ABJT.BARCODE_ID where (MACHINE.NAME like '%supp-ws207%' or \n SYSTEM_DESCRIPTION like '%supp-ws207%' or \n MACHINE.DOMAIN like '%supp-ws207%' or \n MACHINE.CS_DOMAIN like '%supp-ws207%' or\n MAC like '%supp-ws207%' or \n OS_NAME like '%supp-ws207%' or \n USER_LOGGED like '%supp-ws207%' or \n USER_FULLNAME like '%supp-ws207%' or \n BIOS_NAME like '%supp-ws207%' or \n BIOS_VERSION like '%supp-ws207%' or \n BIOS_MANUFACTURER like '%supp-ws207%' or \n BIOS_DESCRIPTION like '%supp-ws207%' or \n BIOS_IDENTIFICATION_CODE like '%supp-ws207%' or \n BIOS_SERIAL_NUMBER like '%supp-ws207%' or \n CUSTOM_FIELD_VALUE0 like '%supp-ws207%' or \n CUSTOM_FIELD_VALUE1 like '%supp-ws207%' or \n CUSTOM_FIELD_VALUE2 like '%supp-ws207%' or \n CUSTOM_FIELD_VALUE3 like '%supp-ws207%' or \n CUSTOM_FIELD_VALUE4 like '%supp-ws207%' or \n CUSTOM_FIELD_VALUE5 like '%supp-ws207%' or \n MACHINE.KUID like '%supp-ws207%' or \n IP like '%supp-ws207%' or\n ASSET_LOCATION.NAME LIKE '%supp-ws207%' or\n BARCODE_DATA like '%supp-ws207%') GROUP BY MACHINE.ID) total_records_query")\n\n', referer: http://suppsrv-kace01.suppliercard.com.br/adminui/computer_inventory.php?LABEL_ID=&SEARCH_SELECTION_TEXT=supp-ws207&SEARCH_SELECTION=supp-ws207
[Tue Jul 02 08:36:40.069837 2019] [proxy_fcgi:error] [pid 44312:tid 34452169984] [client 192.168.3.56:53258] AH01071: Got error 'PHP message: Sending to location: /adminui/summary.php\n', referer: http://suppsrv-kace01.suppliercard.com.br/adminui/welcome.php
[Tue Jul 02 08:51:22.838367 2019] [proxy_fcgi:error] [pid 44312:tid 34452281600] [client 192.168.3.149:49718] AH01071: Got error 'PHP message: [2019-07-02 08:51:22 -0300] PHP ServerErrorException: Failed to parse incoming request body: XML! in kace_unknown on line 0\n'
[Tue Jul 02 09:01:18.337256 2019] [proxy_fcgi:error] [pid 44312:tid 34452181504] [client 192.168.3.149:50344] AH01071: Got error 'PHP message: [2019-07-02 09:01:18 -0300] PHP ServerErrorException: Failed to parse incoming request body: XML! in kace_unknown on line 0\n'
[Tue Jul 02 09:02:33.351404 2019] [proxy_fcgi:error] [pid 59290:tid 34452176384] [client 192.168.2.196:64263] AH01071: Got error 'PHP message: [2019-07-02 09:02:33 -0300] PHP ServerErrorException: Failed to parse incoming request body: XML! in kace_unknown on line 0\n'
[Tue Jul 02 09:23:36.742429 2019] [proxy_fcgi:error] [pid 98341:tid 34452184064] [client 192.168.3.56:54130] AH01071: Got error 'PHP message: Sending to location: /adminui/summary.php\n', referer: http://suppsrv-kace01.suppliercard.com.br/adminui/welcome.php
[Tue Jul 02 09:23:37.971841 2019] [proxy_fcgi:error] [pid 59290:tid 34452172544] [client 192.168.3.56:54139] AH01071: Got error 'PHP message: [2019-07-02 09:23:37 -0300] PHP Warning: Use of undefined constant DellSchedule - assumed 'DellSchedule' (this will throw an Error in a future version of PHP) in /kbox/kboxwww/include/DellSchedule.class.php on line 91\n', referer: http://suppsrv-kace01.suppliercard.com.br/adminui/summary.php
[Tue Jul 02 09:27:14.789427 2019] [proxy_fcgi:error] [pid 44312:tid 34452279040] [client 192.168.3.17:53596] AH01071: Got error 'PHP message: Sending to location: /adminui/summary.php\n', referer: http://suppsrv-kace01/adminui/welcome.php
[Tue Jul 02 09:30:44.907025 2019] [proxy_fcgi:error] [pid 98341:tid 34452285440] [client 192.168.3.222:55449] AH01071: Got error 'PHP message: [2019-07-02 09:30:44 -0300] PHP ServerErrorException: Failed to parse incoming request body: XML! in kace_unknown on line 0\n'
[Tue Jul 02 09:32:50.618481 2019] [proxy_fcgi:error] [pid 44312:tid 34452184064] [client 192.168.3.17:53664] AH01071: Got error 'PHP message: [2019-07-02 09:32:50 -0300] PHP Warning: Use of undefined constant adodb_getall - assumed 'adodb_getall' (this will throw an Error in a future version of PHP) in /kbox/kboxwww/include/troubleshooting_ui.inc on line 154\n', referer: http://suppsrv-kace01/adminui/troubleshooting.php
[Tue Jul 02 09:32:51.081240 2019] [proxy_fcgi:error] [pid 59290:tid 34452175104] [client 192.168.3.149:61633] AH01071: Got error 'PHP message: [2019-07-02 09:32:51 -0300] PHP ServerErrorException: Failed to parse incoming request body: XML! in kace_unknown on line 0\n'
[Tue Jul 02 09:33:56.975879 2019] [proxy_fcgi:error] [pid 98341:tid 34452281600] [client 192.168.3.146:62708] AH01071: Got error 'PHP message: [2019-07-02 09:33:56 -0300] PHP ServerErrorException: Failed to parse incoming request body: XML! in kace_unknown on line 0\n'
[Tue Jul 02 09:36:20.068517 2019] [proxy_fcgi:error] [pid 98341:tid 34452185344] [client 192.168.3.56:54362] AH01071: Got error 'PHP message: Sending to location: /adminui/summary.php\n', referer: http://suppsrv-kace01.suppliercard.com.br/adminui/welcome.php
[Tue Jul 02 09:36:22.817718 2019] [proxy_fcgi:error] [pid 44312:tid 34452182784] [client 192.168.3.56:54369] AH01071: Got error 'PHP message: [2019-07-02 09:36:22 -0300] PHP Warning: count(): Parameter must be an array or an object that implements Countable in /kbox/kboxwww/adminui/search.php on line 589\nPHP message: PHP Notice: session_start(): A session had already been started - ignoring in /kbox/kboxwww/include/DBUtils.inc on line 110\n', referer: http://suppsrv-kace01.suppliercard.com.br/adminui/search.php
[Tue Jul 02 09:45:24.891858 2019] [proxy_fcgi:error] [pid 98341:tid 34452172544] [client 192.168.3.133:53454] AH01071: Got error 'PHP message: [2019-07-02 09:45:24 -0300] PHP ServerErrorException: Failed to parse incoming request body: XML! in kace_unknown on line 0\n'
Can you help me?
Answers (0)
Be the first to answer this question
