IBM Support

IT07370: SET CURRENT LOCALE LC_CTYPE = STATEMENT NOT BEING CLOSED, CAUSES AN OUT OF PACKAGE ERROR

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Receiving Out of Package Error from DB2 z/OS DB:
    
    Exception stack trace:
    com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805,
    SQLSTATE=51002,
    SQLERRMC=D2U2DDF.NULLID.SYSLH21E.5359534C564C3031;DISTSERV;04,
    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_local
    e(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.getCo
    nnection(JDBCService.java:256)
        com.csllc.sql.QuickSQL.select(QuickSQL.java:85)
        sun.reflect.GeneratedMethodAccessor183.invoke(Unknown
    Source)
    
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.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(DelegatingMethod
    AccessorImpl.java:43)
        java.lang.reflect.Method.invoke(Method.java:607)
    
    com.sterlingcommerce.woodstock.translator.rules.ExtendedRuleExec
    uter.executeRule(ExtendedRuleExecuter.java)
    
    com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSe
    quence.runOnEndExtendedRule(BlockSequence.java:1208)
    
    com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSe
    quence.searchForward(BlockSequence.java:438)
    
    com.sterlingcommerce.woodstock.translator.blockprocessor.BlockSe
    quence.processFileFormat(BlockSequence.java:403)
    
    com.sterlingcommerce.woodstock.translator.engine.TranslationEngi
    neImpl.translateInput(TranslationEngineImpl.java:1692)
    
    com.sterlingcommerce.woodstock.translator.engine.TranslationEngi
    neImpl.doTranslation(TranslationEngineImpl.java:1814)
    
    com.sterlingcommerce.woodstock.translator.engine.TranslationEngi
    neImpl.translate(TranslationEngineImpl.java:1346)
    
    com.sterlingcommerce.woodstock.translator.engine.TranslationEngi
    ne.translate(TranslationEngine.java:194)
    
    com.sterlingcommerce.woodstock.services.translation.TranslationS
    erviceImpl.processData(TranslationServiceImpl.java:738)
    
    com.sterlingcommerce.woodstock.workflow.activity.engine.Activity
    EngineHelper.invokeService(ActivityEngineHelper.java:1818)
    
    com.sterlingcommerce.woodstock.workflow.activity.engine.Activity
    EngineHelper.nextMainLogic(ActivityEngineHelper.java:631)
    
    com.sterlingcommerce.woodstock.workflow.activity.engine.Activity
    EngineHelper.next(ActivityEngineHelper.java:362)
    
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.doWork(WorkFlowQueueListener.java:440)
    
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.run(WorkFlowQueueListener.java:236)
    
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.onMessage(WorkFlowQueueListener.java:197)
    
    com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListe
    ner.onMessage(WorkFlowQueueListener.java:184)
    
    com.sterlingcommerce.woodstock.workflow.queue.wfTransporter.run(
    wfTransporter.java:444)
    
    com.sterlingcommerce.woodstock.workflow.queue.BasicExecutor$Work
    er.run(BasicExecutor.java:508)
        java.lang.Thread.run(Thread.java:781)
    

Local fix

  • RTC 454899
    FB/FB
    
    Circumvention:
    None
    

Problem summary

  • Users Affected: All users accessing DB2 for z/OS database
    with Sterling B2B Integrator.
    
    Problem Description:
    When working with a DB2 for z/OS database, Sterling B2B
    Integrator
    will issue an SQL statement to set the current locale, but it
    does not properly close the statement object. This may
    eventually result in an "Out of Package Error" in the database.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    The code was changed so that the statement object in question
    was closed after the statement was executed.
    
    Delivered In:
    5020500_3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07370

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-02-26

  • Closed date

    2015-03-06

  • Last modified date

    2015-03-20

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

  • R525 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
20 March 2015