Hi,

 

I am evaluating the AppManager for VMware monitoring. While generating Trend Analysis reports for ESX hosts I am getting below mentioned error.

 

Exception occurred while generating reports,Refer logs/stdout.txt for more Information. Exception overview java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long

 

Any idea why??? It was working till yesterday but I restarted the services once as CPU usage was very high and after that I am unable to generate the Trend Analysis reports.

 

 

stderr.log is full of these errors:

 

[10 Nov 2013 06:40:56:458] SYS_ERR: java.sql.BatchUpdateException: Batch entry 0 delete from AM_10000044_63_MinMaxAvgData where resid in ('10018503','10018504','10018500','10018502','10018499','10018501') was aborted.  Call getNextException to see the cause.
[10 Nov 2013 06:40:56:458] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1365)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1054)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.updateResponse(ConfDataCollector.java:1352)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.getData(ConfDataCollector.java:227)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at com.adventnet.appmanager.server.framework.AM_KeyValueDataCollector.run(AM_KeyValueDataCollector.java:260)
[10 Nov 2013 06:40:56:458] SYS_ERR:  at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:84)
[10 Nov 2013 06:40:58:755] SYS_ERR: java.sql.BatchUpdateException: Batch entry 0 delete from AM_10000044_63_MinMaxAvgData where resid in ('10018060','10018054','10018059','10018051','10018056','10018058','10018053','10018055','10018057','10018052') was aborted.  Call getNextException to see the cause.
[10 Nov 2013 06:40:58:755] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1365)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1054)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.updateResponse(ConfDataCollector.java:1352)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.getData(ConfDataCollector.java:227)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at com.adventnet.appmanager.server.framework.AM_KeyValueDataCollector.run(AM_KeyValueDataCollector.java:260)
[10 Nov 2013 06:40:58:755] SYS_ERR:  at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:84)
[10 Nov 2013 06:40:58:771] SYS_ERR: java.sql.BatchUpdateException: Batch entry 0 delete from AM_10000044_63_MinMaxAvgData where resid in ('10018061','10018065','10018067','10018062','10018064','10018066','10018068','10018063','10018069') was aborted.  Call getNextException to see the cause.
[10 Nov 2013 06:40:58:771] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1365)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1054)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.updateResponse(ConfDataCollector.java:1352)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.getData(ConfDataCollector.java:227)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at com.adventnet.appmanager.server.framework.AM_KeyValueDataCollector.run(AM_KeyValueDataCollector.java:260)
[10 Nov 2013 06:40:58:771] SYS_ERR:  at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:84)
[10 Nov 2013 06:40:59:974] SYS_ERR: java.sql.BatchUpdateException: Batch entry 0 delete from AM_10000044_63_MinMaxAvgData where resid in ('10018013','10018027','10018023','10018026','10018015','10018021','10018019','10018011','10018025') was aborted.  Call getNextException to see the cause.
[10 Nov 2013 06:40:59:974] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1365)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1054)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.updateResponse(ConfDataCollector.java:1352)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.getData(ConfDataCollector.java:227)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at com.adventnet.appmanager.server.framework.AM_KeyValueDataCollector.run(AM_KeyValueDataCollector.java:260)
[10 Nov 2013 06:40:59:974] SYS_ERR:  at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:84)
[10 Nov 2013 06:41:01:505] SYS_ERR: java.sql.BatchUpdateException: Batch entry 0 delete from AM_10000044_63_MinMaxAvgData where resid in ('10018033','10018039','10018035','10018037','10018032','10018030','10018028','10018038','10018034','10018036','10018031','10018029','10018041','10018040') was aborted.  Call getNextException to see the cause.
[10 Nov 2013 06:41:01:505] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1365)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1054)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.updateResponse(ConfDataCollector.java:1352)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.getData(ConfDataCollector.java:227)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at com.adventnet.appmanager.server.framework.AM_KeyValueDataCollector.run(AM_KeyValueDataCollector.java:260)
[10 Nov 2013 06:41:01:505] SYS_ERR:  at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:84)
[10 Nov 2013 06:41:02:334] SYS_ERR: java.sql.BatchUpdateException: Batch entry 0 delete from AM_10000044_63_MinMaxAvgData where resid in ('10018075','10018074','10018070','10018073','10018072','10018071') was aborted.  Call getNextException to see the cause.
[10 Nov 2013 06:41:02:334] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1365)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at com.adventnet.appmanager.server.framework.datacollection.ScheduleScriptDataCollection.deleteScriptRow(ScheduleScriptDataCollection.java:1054)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.updateResponse(ConfDataCollector.java:1352)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.getData(ConfDataCollector.java:227)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at com.adventnet.appmanager.server.framework.AM_KeyValueDataCollector.run(AM_KeyValueDataCollector.java:260)
[10 Nov 2013 06:41:02:334] SYS_ERR:  at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:84)
[10 Nov 2013 06:41:37:647] SYS_ERR: java.sql.BatchUpdateException: Batch entry 0 delete from AM_PARENTCHILDMAPPER where PARENTID='10000268' and CHILDID=(select RESOURCEID from AM_ManagedObject where DISPLAYNAME='naa.60060e80042bf10000002bf1000030ee' and TYPE='VMWare ESX/ESXi_Disk I/O Utilization_ROW') was aborted.  Call getNextException to see the cause.
[10 Nov 2013 06:41:37:647] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.handleDataStoreVsDiskRelation(ConfDataCollector.java:1569)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.outputParser(ConfDataCollector.java:699)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.parseInsertOutput(ConfDataCollector.java:237)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at com.adventnet.appmanager.server.confmonitor.ConfDataCollector.getData(ConfDataCollector.java:184)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at com.adventnet.appmanager.server.framework.AM_KeyValueDataCollector.run(AM_KeyValueDataCollector.java:260)
[10 Nov 2013 06:41:37:647] SYS_ERR:  at com.adventnet.management.scheduler.WorkerThread.run(WorkerThread.java:84)

 

 

 

Kindlly help.

 

Regards,

 

Anil Aliyan