IBM Support

JR45521: Repeated use of IAAdmin command with -getOutputTable option generates output with headers only.

 

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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback