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.
SAP Knowledge Base Article - Preview