IBM Support

Noapp.log Error: SQLCODE=-805, SQLSTATE=51002 Thrown When a Translation Map Connects to a DB2 z/OS Pool and Executes SQL Statements

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)

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Mapping and Translation","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Sterling B2B Integrator

Software version:
All

Document number:
526003

Modified date:
14 November 2019

UID

swg21696145

Manage My Notification Subscriptions