APAR status
Closed as program error.
Error description
After appox 600 runs of IAAdmin.sh with the -getOutputTable option ouput data is no longer returned, only column headers will be seen. Errors similar to the following may also been seen as the output which is indicative of running out of DB2 CLI statement handles. /home/IBM/InformationServer/ASBNode 500com.ascential.investigate.exception.ScratchAccessException : An error occurred while accessing the ScratchSpace DataRulesServiceBridge.getRowsForRule: SQL error: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031, DRIVER=3.58.135 SQL Query: SELECT AgentConfig.sh Agent.out Agent.pid AgentService.pid Agent.sh DEBUG DirectoryCommand.sh DirectorySync.sh dsoptions.bat dsoptions.sh DStageWrapper.sh DSUtilsServiceTest.sh DSXImportService.sh encrypt.sh executerule.sh GetJobRuns.bat GetJobRuns.sh IAAdmin.bat IAAdmin.sh IAJob.bat IAJob.sh IAValidation.bat IAValidation.sh ISDAdmin.sh ISDImportExport.sh logging-agent-0.err logging-agent-0.err.lck logging-agent-0.out logging-agent-0.out.lck LoggingAgent.out LoggingAgent.pid LoggingAgent.sh NodeAgents_env_DS.sh NodeAgents.sh OK orbtrc.19122012.1325.45.txt ProcessEnvVariables.bat ProcessEnvVariables.sh ProxyConfig.sh purgeappres_de_DE.properties purgeappres_es_ES.properties purgeappres_fr_FR.properties purgeappres_it_IT.properties purgeappres_ja_JP.properties purgeappres_ko_KR.properties purgeappres.properties purgeappres_pt_BR.properties purgeappres_zh_CN.properties purgeappres_zh_TW.properties PurgeJobRuns.bat PurgeJobRuns.sh RegistrationCommand.sh ReportingAdmin.sh runimportres_de_DE.properties runimportres_es_ES.properties runimportres_fr_FR.properties runimportres_it_IT.properties runimportres_ja_JP.properties runimportres_ko_KR.properties runimportres.properties runimportres_pt_BR.properties runimportres_zh_CN.properties runimportres_zh_TW.properties RunImportStart.bat RunImportStart.sh ServiceListApplications.sh SessionAdmin.sh setLanguageOptions.sh setupEnv.properties setupEnv.sh SyncProject.sh UpdateJobProperties.bat UpdateJobProperties.sh UpdateSignerCerts.sh FROM (SELECT ROW_NUMBER() OVER (ORDER BY ia_generated_key__) AS row_number, data_.ia_generated_key__ as IA_GENERATED_KEY__, data_.firstname as FIRSTNAME, 'TANKY' as RULEEXECUTABLENAME, ia_generated_key__ as RECORDID, 1-data_.nbViolatedRules as RULEMETORNOTMET, date('2012-06-20') as SYSTEMDATE, timestamp('2012-06-20 14:24:40') as SYSTEMTIMESTAMP FROM "ec1481df.f92d8a7c.aq03g212i.hoojpho.bcklma.d83a2ngtjpk4ldpc6kk4 v_DATA" as data_ )foo WHERE row_number>=1 at com.ascential.investigate.dr.DataRulesServiceBridge.getRowsForRu les(DataRulesServiceBridge.java:6440) at com.ascential.investigate.api.internal.ProjectExtractor.extractR uleExecutionOutputTable(ProjectExtractor.java:972) at com.ascential.investigate.api.APIServiceBridge.getOutputTable(AP IServiceBridge.java:1555) at com.ascential.investigate.api.server.impl.APIServiceBean.getOutp utTable(APIServiceBean.java:289) at com.ascential.investigate.api.server.EJSRemoteStatelessAPIServic e_7c9628f5.getOutputTable(Unknown Source) at com.ascential.investigate.api.server._APIServiceRemote_Stub.getO utputTable(_APIServiceRemote_Stub.java:1277) at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.ibm.is.binding.rest2.Servlet.callOperation(Servlet.java:390) at com.ibm.is.binding.rest2.Servlet.processRequest(Servlet.java:313 ) at com.ibm.is.binding.rest2.Servlet.doRequest(Servlet.java:261) at com.ibm.is.binding.rest2.Servlet.doGet(Servlet.java:205) at javax.servlet.http.HttpServlet.service(HttpServlet.java:718) at javax.servlet.http.HttpServlet.service(HttpServlet.java:831) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWr apper.java:1663) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(Ser vletWrapper.java:939) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(Ser vletWrapper.java:502) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest (ServletWrapperImpl.java:179) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleReques t(CacheServletWrapper.java:91) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer. java:864) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContai ner.java:1583) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLin k.java:186) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscr imination(HttpInboundLink.java:452) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRe quest(HttpInboundLink.java:511) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequ est(HttpInboundLink.java:305) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpI nboundLink.java:263) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sen dToDiscriminators(NewConnectionInitialReadCallback.java:214) at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.com plete(NewConnectionInitialReadCallback.java:113) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureComp leted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyn cFuture.java:217) at com.ibm.io.async.AsyncChannelFuture$1.run(AsyncChannelFuture.jav a:205) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604) Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031, DRIVER=3.58.135 at com.ibm.db2.jcc.am.ed.a(ed.java:679) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:127) at com.ibm.db2.jcc.am.zm.c(zm.java:2524) at com.ibm.db2.jcc.t4.fb.o(fb.java:830) at com.ibm.db2.jcc.t4.fb.g(fb.java:143) at com.ibm.db2.jcc.t4.fb.a(fb.java:40) at com.ibm.db2.jcc.t4.t.a(t.java:32) at com.ibm.db2.jcc.t4.ub.i(ub.java:135) at com.ibm.db2.jcc.am.zm.fb(zm.java:1963) at com.ibm.db2.jcc.am.zm.a(zm.java:2983) at com.ibm.db2.jcc.am.zm.a(zm.java:652) at com.ibm.db2.jcc.am.zm.executeQuery(zm.java:636) at com.ascential.investigate.sda.ScratchDataAccessImpl.execQueryfor ResultSetInternal(ScratchDataAccessImpl.java:613) at com.ascential.investigate.sda.ScratchDataAccessImpl.executeQuery forResultSet(ScratchDataAccessImpl.java:155) at com.ascential.investigate.dr.DataRulesServiceBridge.getRowsForRu les(DataRulesServiceBridge.java:6390) ... 32 more An error occurred while accessing the ScratchSpace DataRulesServiceBridge.getRowsForRule: SQL error: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203 0X5359534C564C3031, DRIVER=3.58.135 SQL Query: SELECT AgentConfig.sh Agent.out Agent.pid AgentService.pid Agent.sh DEBUG DirectoryCommand.sh DirectorySync.sh dsoptions.bat dsoptions.sh DStageWrapper.sh DSUtilsServiceTest.sh DSXImportService.sh encrypt.sh executerule.sh GetJobRuns.bat GetJobRuns.sh IAAdmin.bat IAAdmin.sh IAJob.bat IAJob.sh IAValidation.bat IAValidation.sh ISDAdmin.sh ISDImportExport.sh logging-agent-0.err logging-agent-0.err.lck logging-agent-0.out logging-agent-0.out.lck LoggingAgent.out LoggingAgent.pid LoggingAgent.sh NodeAgents_env_DS.sh NodeAgents.sh OK orbtrc.19122012.1325.45.txt ProcessEnvVariables.bat ProcessEnvVariables.sh ProxyConfig.sh purgeappres_de_DE.properties purgeappres_es_ES.properties purgeappres_fr_FR.properties purgeappres_it_IT.properties purgeappres_ja_JP.properties purgeappres_ko_KR.properties purgeappres.properties purgeappres_pt_BR.properties purgeappres_zh_CN.properties purgeappres_zh_TW.properties PurgeJobRuns.bat PurgeJobRuns.sh RegistrationCommand.sh ReportingAdmin.sh runimportres_de_DE.properties runimportres_es_ES.properties runimportres_fr_FR.properties runimportres_it_IT.properties runimportres_ja_JP.properties runimportres_ko_KR.properties runimportres.properties runimportres_pt_BR.properties runimportres_zh_CN.properties runimportres_zh_TW.properties RunImportStart.bat RunImportStart.sh ServiceListApplications.sh SessionAdmin.sh setLanguageOptions.sh setupEnv.properties setupEnv.sh SyncProject.sh UpdateJobProperties.bat UpdateJobProperties.sh UpdateSignerCerts.sh FROM (SELECT ROW_NUMBER() OVER (ORDER BY ia_generated_key__) AS row_number, data_.ia_generated_key__ as IA_GENERATED_KEY__, data_.firstname as FIRSTNAME, 'TANKY' as RULEEXECUTABLENAME, ia_generated_key__ as RECORDID, 1-data_.nbViolatedRules as RULEMETORNOTMET, date('2012-06-20') as SYSTEMDATE, timestamp('2012-06-20 14:24:40') as SYSTEMTIMESTAMP FROM "ec1481df.f92d8a7c.aq03g212i.hoojpho.bcklma.d83a2ngtjpk4ldpc6kk4 v_DATA" as data_ )foo WHERE row_number>=1com.ascential.investigate.exception.ScratchAccessEx ception/InformationAnalyzer/executableRule/outputTable Following will be seen in the SystemErr.log ************ Start Display Current Environment ************ Log file started at: [1/7/13 1:34:04:645 PST] ************* End Display Current Environment ************* [1/7/13 1:34:04:489 PST] 00000069 SystemErr R ***** Out of Package Error Occurred (2013-01-07 01:34:04.489) ***** Exception stack trace: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=NULLID.SYSLH203
Local fix
Re start the WebSphere Application Server The number of DB2 CLI statment handles can be increased by running the following command db2 ?bind @db2cli.lst blocking all sqlerror continue grant public CLIPKG 6? as the db2 administrator. The default setting is 3, the highest value is 30. This will not resolve the handle leak and eventually the issue will arise if the WebSpahere Application Server is not re started. Fix provided in rollup_RU5_IA_ALL_8701, rollup_RU12_IA_ALL_8503, rollup_RU6_IA_ALL_8701
Problem summary
IAAdmin command when run repeatedly with option -getOutputTable for exporting results to txt file results in generation of txt files with only column headers with out information of the data rule results
Problem conclusion
Fix for the issue of IAAdmin command when run repeatedly with option -getOutputTable results in generating text files with only column headers and no output information is delivered as 87rp6
Temporary fix
Comments
APAR Information
APAR number
JR45521
Reported component name
WIS INFORM ANAL
Reported component ID
5724Q36IA
Reported release
870
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-01-24
Closed date
2013-05-22
Last modified date
2013-08-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS INFORM ANAL
Fixed component ID
5724Q36IA
Applicable component levels
R850 PSY
UP
R870 PSY
UP
R910 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.7"}]
Document Information
Modified date:
17 October 2021