IBM Support

JR43708: DATABASE CONNECTION MANAGEMENT ISSUE WITH THE WORKITEM MIGRATION TOOL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When migratedDB.py is executed, depending on the chosen slice
    size a lot of database connections can be used up and may not be
    freed properly
    

Local fix

  • N/A
    

Problem summary

  • Problem Description:
    The migrateDb.py migration script might terminate with the
    following exception: Insufficient data. ERRORCODE=-4499,
    SQLSTATE=08001
    
    Problem Summary:
    The migrateDb.py migration script might terminate with the
    following exception:
    
    com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException:
    [jcc][t4][2030][11211][3.64.82] A communication error occurred
    during operations on the connection's underlying socket, socket
    input stream,
    or socket output stream.  Error location: Reply.fill() -
    insufficient data (-1).  Message: Insufficient data.
    ERRORCODE=-4499, SQLSTATE=08001
     at com.ibm.db2.jcc.am.bd.a(bd.java:321)
     at com.ibm.db2.jcc.t4.a.a(a.java:501)
     at com.ibm.db2.jcc.t4.a.a(a.java:496)
     at com.ibm.db2.jcc.t4.x.b(x.java:334)
     at com.ibm.db2.jcc.t4.x.c(x.java:360)
     at com.ibm.db2.jcc.t4.x.c(x.java:473)
     at com.ibm.db2.jcc.t4.x.v(x.java:1241)
     at com.ibm.db2.jcc.t4.y.a(y.java:47)
     at com.ibm.db2.jcc.t4.b.c(b.java:1349)
     at com.ibm.db2.jcc.t4.b.b(b.java:1221)
     at com.ibm.db2.jcc.t4.b.b(b.java:788)
     at com.ibm.db2.jcc.t4.b.a(b.java:760)
     at com.ibm.db2.jcc.t4.b.a(b.java:421)
     at com.ibm.db2.jcc.t4.b.a(b.java:396)
     at com.ibm.db2.jcc.t4.b.<init>(b.java:334)
     at
    com.ibm.db2.jcc.t4.T4XAConnection.<init>(T4XAConnection.java:32)
     at
    com.ibm.db2.jcc.DB2PooledConnection.<init>(DB2PooledConnection.j
    ava:199)
     at
    com.ibm.db2.jcc.DB2XAConnection.<init>(DB2XAConnection.java:56)
     at
    com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.
    java:167)
     at
    com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.
    java:135)
     at
    com.ibm.bpe.database.ConnectionHandler.getConnection(ConnectionH
    andler.java:152)
     at
    com.ibm.bpe.database.WiAssocBucketMigrationWorker.execute(WiAsso
    cBucketMigrationWorker.java:106)
     at
    com.ibm.bpe.database.WiAssocBucketMigrationThread.run(WiAssocBuc
    ketMigrationThread.java:111)
    
    For XA or pooled data sources, the migrateDb.py scripts opens
    too many connections to the database.
    
    Problem Conclusion:
    
    This iFix limits the number of active database connections and
    closes closes database connections earlier.
    

Problem conclusion

  • Problem fixed
    iFix available on top of V751 FP1
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR43708

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-08-09

  • Closed date

    2013-01-07

  • Last modified date

    2013-01-07

  • APAR is sysrouted FROM one or more of the following:

    IV25893

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    BPM ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R751 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
12 October 2021