Symptom
After registering production IQ server in SAP Control Center, following symptoms and error messages are observed.
- Even though IQ server is running, the status is shown as 'Unknown'
- agent.log shows following
2016-02-03 13:49:11,120 [WARN ] [scc.collect ] [scc-scheduler_Worker-2] - Collection[D835A4C6CA3911E58000E1434AF837C1|Availability Statistics Collection]: batch id=1 failed with exception: Collection batch 1 failed. Resource[ManagedObject:pm=com.sybase.ua.plugins.iqmap,type=com.sybase.ua.plugins.iqmap.mo.IQMO,guid=D835A4C6CA3911E58000E1434AF837C1,login=sccadmin]; Collection Definition [Availability Statistics Collection]. Message: java.lang.NumberFormatException: For input string: "4011732802"
-
If user proceeds futher to monitor this IQ instance since it is known to be running & clicks on "All Statistics", Another error is observed in log window
- gateway.log shows error message with complete trace.
2016-02-03 13:50:57,634 [ERROR] [scc.jmx ] [scc-ui-6] - managedObjectGateway.invoke( [LoginVO [localeName=en_US, sessionToken=97ac2c51-c3bc-49c7-962e-e509c3e3031a, userName=sccadmin], ManagedObjectVO [_childAlertXML=null, _supportedFeatures=[alerts, scheduled_jobs], authProfileVO=null, canAuthenticate=false, canConnect=false, connProfileVOs=null, connectionProperties=null, guid=D8C73666CA3911E58000E1434AF837C1, isLightweight=false, jmxObjectName=ManagedObject:guid=D8C73666CA3911E58000E1434AF837C1,login=sccadmin,pm=com.sybase.ua.plugins.iqmap,type=com.sybase.ua.plugins.iqmap.mo.AllStatsMO, managedObjectDescription=IQ All Statistics Managed Object Type, managedObjectName=IQ All Statistics MO, managedObjectTypeVO=[IQ Management Agent Plugin:3.3.0:IQ All Statistics MO:15.1.0.0], managedObjectVersion=null, managedObjectVersionString=null], retrieveKPAAsXml, null] ) com.sybase.scc.jmx.SccGatewayException: Failed to invoke managed object "D8C73666CA3911E58000E1434AF837C1" mbean operations "retrieveKPAAsXml([])":java.lang.NullPointerException: while trying to invoke the method com.sybase.iq.sdk.vo.kpi.ConnectionUsageVO.getNumConnectionsAvailable() of a null object returned from com.sybase.iq.sdk.vo.kpa.AllStatsKPA.getConnectionUsageVO().
com.sybase.scc.jmx.SccGatewayException: Failed to invoke managed object "D8C73666CA3911E58000E1434AF837C1" mbean operations "retrieveKPAAsXml([])":java.lang.NullPointerException: while trying to invoke the method com.sybase.iq.sdk.vo.kpi.ConnectionUsageVO.getNumConnectionsAvailable() of a null object returned from com.sybase.iq.sdk.vo.kpa.AllStatsKPA.getConnectionUsageVO().
at com.sybase.scc.jmx.ManagedObjectGateway.invoke(ManagedObjectGateway.java:262)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) -
agent.log shows increasing value pattern suggesting cumulative pattern.
Caused by: java.lang.NumberFormatException: For input string: "3699239726"
Caused by: java.lang.NumberFormatException: For input string: "3699239726"
Caused by: java.lang.NumberFormatException: For input string: "3699608452"
Caused by: java.lang.NumberFormatException: For input string: "3703225639"
Caused by: java.lang.NumberFormatException: For input string: "3703225639"
Caused by: java.lang.NumberFormatException: For input string: "3703624272"
Caused by: java.lang.NumberFormatException: For input string: "3703917863"
Caused by: java.lang.NumberFormatException: For input string: "3704174493"
Caused by: java.lang.NumberFormatException: For input string: "3704906982"
Caused by: java.lang.NumberFormatException: For input string: "3706769218"
Caused by: java.lang.NumberFormatException: For input string: "3708944583"
Caused by: java.lang.NumberFormatException: For input string: "3709648674"
Caused by: java.lang.NumberFormatException: For input string: "3709648674"
Caused by: java.lang.NumberFormatException: For input string: "3710166081"
Caused by: java.lang.NumberFormatException: For input string: "3710361186"
Read more...
Environment
- SAP IQ 16+
- SAP Control Central 3+
Product
Keywords
com.sybase.iq.sdk.vo.kpi.ConnectionUsageVO.getNumConnectionsAvailable ; ManagedObjectVO ; AllStatsKPA ; SCC ; retrieveKPAAsXml ; java.lang.NumberFormatException ; Availability Statistics Collection ; java.lang.NullPointerException ; java.lang.Integer.parseInt , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.