Troubleshooting
Problem
Noapp.log Error: SQLCODE=-805, SQLSTATE=51002 Thrown When a Translation Map Connects to a DB2 z/OS Pool and Executes SQL Statements. Too many concurrent open statements.
Symptom
Exception stack trace:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=, DRIVER=4.15.113
com.ibm.db2.jcc.am.fd.a(fd.java:701)
com.ibm.db2.jcc.am.fd.a(fd.java:60)
com.ibm.db2.jcc.am.fd.a(fd.java:127)
com.ibm.db2.jcc.am.qo.c(qo.java:2770)
com.ibm.db2.jcc.am.qo.d(qo.java:2758)
com.ibm.db2.jcc.am.qo.a(qo.java:2191)
com.ibm.db2.jcc.am.ro.a(ro.java:7834)
com.ibm.db2.jcc.am.qo.a(qo.java:2167)
com.ibm.db2.jcc.t4.bb.h(bb.java:135)
com.ibm.db2.jcc.t4.bb.b(bb.java:40)
com.ibm.db2.jcc.t4.q.a(q.java:32)
com.ibm.db2.jcc.t4.rb.i(rb.java:135)
com.ibm.db2.jcc.am.qo.ib(qo.java:2160)
com.ibm.db2.jcc.am.ro.vc(ro.java:3658)
com.ibm.db2.jcc.am.ro.b(ro.java:4455)
com.ibm.db2.jcc.am.ro.jc(ro.java:808)
com.ibm.db2.jcc.am.ro.executeUpdate(ro.java:782)
com.sterlingcommerce.woodstock.util.frame.jdbc.SqlUtil.set_locale(SqlUtil.java:1928)
com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService.handleDbVendor(ConnectionService.java:276)
com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService.setConnectionProps(ConnectionService.java:257)
com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService.getConnection(ConnectionService.java:230)
com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService.getConnection(ConnectionService.java:769)
com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCService.getConnection(JDBCService.java:256)
com.csllc.sql.QuickSQL.select(QuickSQL.java:85)
sun.reflect.GeneratedMethodAccessor183.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:607)
com.sterlingcommerce.woodstock.translator.rules.UserExitOpcodes.callObjectMethod_JPJ(UserExitOpcodes.java:189)
sun.reflect.GeneratedMethodAccessor182.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:607)
com.sterlingcommerce.woodstock.translator.rules.ExtendedRuleExecuter.executeRule(ExtendedRuleExecuter.java)
com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.runOnEndExtendedRule(BlockSequence.java:1208)
com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.searchForward(BlockSequence.java:438)
com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSequence.processFileFormat(BlockSequence.java:403)
com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.translateInput(TranslationEngineImpl.java:1692)
com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.doTranslation(TranslationEngineImpl.java:1814)
com.sterlingcommerce.woodstock.translator.engine.TranslationEngineImpl.translate(TranslationEngineImpl.java:1346)
com.sterlingcommerce.woodstock.translator.engine.TranslationEngine.translate(TranslationEngine.java:194)
com.sterlingcommerce.woodstock.services.translation.TranslationServiceImpl.processData(TranslationServiceImpl.java:738)
com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.invokeService(ActivityEngineHelper.java:1818)
com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.nextMainLogic(ActivityEngineHelper.java:631)
com.sterlingcommerce.woodstock.workflow.activity.engine.ActivityEngineHelper.next(ActivityEngineHelper.java:362)
com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.doWork(WorkFlowQueueListener.java:440)
com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.run(WorkFlowQueueListener.java:236)
com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.onMessage(WorkFlowQueueListener.java:197)
com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.onMessage(WorkFlowQueueListener.java:184)
com.sterlingcommerce.woodstock.workflow.queue.wfTransporter.run(wfTransporter.java:444)
com.sterlingcommerce.woodstock.workflow.queue.BasicExecutor$Worker.run(BasicExecutor.java:508)
java.lang.Thread.run(Thread.java:781)
To view more of this document
Was this topic helpful?
Document Information
Modified date:
14 November 2019
UID
swg21696145