DX Infrastructure Management

 View Only

Tech Tip: usage_metering probe: FATAL Error messages 

Oct 18, 2018 11:36 AM

Document ID : KB000117070
Last Modified Date : 08/10/2018
Issue:
Usage_metering version 9.20 does not generate reports and it's sending FATAL error messages in the log as the below:
 
okt 04 09:30:01:647 FATAL [pool-7-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Query execution failed for selectDeviceData okt 04 09:30:01:647 FATAL [pool-7-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Table "UM_DEVICE_DATA" not found; SQL statement: Select id,cs_id,name,probe_name,origin,ip,robot,create_date,fqdn from um_device_data where create_date between '2018-10-01' and '2018-10-31'  and cs_id='387' and probe_name='sql_response' and robot='m3adm' [42102-171] okt 04 09:30:01:647 ERROR [pool-7-thread-1, com.nimsoft.query.jdbc.QueryExecutor] org.h2.jdbc.JdbcSQLException: Table "UM_DEVICE_DATA" not found; SQL statement: Select id,cs_id,name,probe_name,origin,ip,robot,create_date,fqdn from um_device_data where create_date between '2018-10-01' and '2018-10-31'  and cs_id='387' and probe_name='sql_response' and robot='m3adm' [42102-171]      at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)      at org.h2.message.DbException.get(DbException.java:169)      at org.h2.message.DbException.get(DbException.java:146)      at org.h2.command.Parser.readTableOrView(Parser.java:4782)      at org.h2.command.Parser.readTableFilter(Parser.java:1091)      at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1697)      at org.h2.command.Parser.parseSelectSimple(Parser.java:1804)      at org.h2.command.Parser.parseSelectSub(Parser.java:1691)      at org.h2.command.Parser.parseSelectUnion(Parser.java:1534)      at org.h2.command.Parser.parseSelect(Parser.java:1522)      at org.h2.command.Parser.parsePrepared(Parser.java:404)      at org.h2.command.Parser.parse(Parser.java:278)      at org.h2.command.Parser.parse(Parser.java:250)      at org.h2.command.Parser.prepareCommand(Parser.java:217)      at org.h2.engine.Session.prepareLocal(Session.java:417)      at org.h2.engine.Session.prepareCommand(Session.java:366)      at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)      at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:70)      at com.nimsoft.query.jdbc.QueryExecutor.executeRdbmsQuery(QueryExecutor.java:467)      at com.nimsoft.nimbus.service.probe.usage_metering.device_metering.DeviceUsageScanMainThread.discoverStorageAndCloudDevices(DeviceUsageScanMainThread.java:532)      at com.nimsoft.nimbus.service.probe.usage_metering.device_metering.DeviceUsageScanMainThread.run(DeviceUsageScanMainThread.java:397)      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)      at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)


 
Environment:
UIM 8.5.1
Microsoft SQL Server 2012
usage_metering 9.20
Cause:
Possible cause: JVM crashing due to incompatible/outdated library file used by sql jdbc driver. 
Resolution:
1. Deactivate the probe
2. Delete the probe (in IM or AC: Right click > Delete)
3. Delete the probe folder from the system: <CA UIM Installation Directory>/probes/service/
4. Re-deploy java_jre on the robot
5. Restart the robot
6. Redeploy usage_metering 9.20
Additional Information:

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads