usage_metering probe: FATAL Error messages

Document ID : KB000117070
Last Modified Date : 08/10/2018
Show Technical Document Details
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:
usage_metering (Usage Metering) Release Notes