14
« on: January 10, 2019, 06:21:22 pm »
Hi Victor,
i installed NetXMS via the provided installer. (Installed via command: netxms-2.2.11-7-x64.exe /silent )
After that, log file shows the following:
2019.01.10 17:16:45.714 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_4437 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008D3DD40 local=0000000008D3DD40
2019.01.10 17:16:45.714 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_4437 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:45.751 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008AFDE60 local=0000000008AFDE60
2019.01.10 17:16:45.751 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:45.831 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_4902 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=00000000090ADD50 local=00000000090ADD50
2019.01.10 17:16:45.831 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_4902 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:45.928 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_4426 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000885DD50 local=000000000885DD50
2019.01.10 17:16:45.928 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_4426 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:45.948 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6328 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000842DD80 local=000000000842DD80
2019.01.10 17:16:45.948 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6328 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:46.035 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000871DE50 local=000000000871DE50
2019.01.10 17:16:46.035 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:51.510 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008D3DD40 local=0000000008D3DD40
2019.01.10 17:16:51.510 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:16:51.510 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_1524 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008AFDE60 local=0000000008AFDE60
2019.01.10 17:16:51.511 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1524 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:17:06.381 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=0000000008D3DD40 local=0000000008D3DD40
2019.01.10 17:17:06.382 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:17:06.384 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_4902 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000885DD50 local=000000000885DD50
2019.01.10 17:17:06.384 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_4902 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:17:06.429 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=000000000842DD80 local=000000000842DD80
2019.01.10 17:17:06.429 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_6326 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.10 17:17:06.484 *E* ** PREPARE ERROR ** query='SELECT idata_timestamp,idata_value FROM idata_6328 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000' converted='' ptr=00000000094CDFD0 local=00000000094CDFD0
...and so on...
Hope that helps...
Greets
Marco