IBM Support

IV61614: IMPORT FAILS WITH ERROR: BATCH FAILURE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Import fails with error similar to:
    
    2014-06-16 18:43:18 (+0:00:00.001) INFO: ETL from IEM Production
    -
    SAM::RawPackageFact                (0x0000000000000000 -
    0x0000000530A423E1): Failed
    2014-06-16 18:43:18 (+0:00:00.046) ERROR: Sequel::DatabaseError:
    NativeException: com.ibm.db2.jcc.am.BatchUpdateException:
    [jcc][t4][102][10040][3.64.104] Batch failure.  The batch was
    submitted,
    but at least one exception occurred on an individual member of
    the
    batch.
    Use getNextException() to retrieve the exceptions for specific
    batched
    elements. ERRORCODE=-4229, SQLSTATE=null
     com/ibm/db2/jcc/am/bd.java:407:in `a'
     com/ibm/db2/jcc/am/Agent.java:399:in `endBatchedReadChain'
    

Local fix

Problem summary

  • ****************************************************************
    * Import fails with error similar to:
    *
    * 2014-06-16 18:43:18 (+0:00:00.001) INFO: ETL from IEM
    * Production
    * -
    * SAM::RawPackageFact                (0x0000000000000000 -
    * 0x0000000530A423E1): Failed
    * 2014-06-16 18:43:18 (+0:00:00.046) ERROR: Sequel::
    * DatabaseError:
    * NativeException: com.ibm.db2.jcc.am.BatchUpdateException:
    * [jcc][t4][102][10040][3.64.104] Batch failure.  The batch was
    * submitted, but at least one exception occurred on an
    * individual member of the batch. Use getNextException() to
    * retrieve the exceptions for specific batched elements.
    * ERRORCODE=-4229, SQLSTATE=null
    * com/ibm/db2/jcc/am/bd.java:407:in `a'
    * com/ibm/db2/jcc/am/Agent.java:399:in `endBatchedReadChain'
    ****************************************************************
    * RECOMMENDATION: Apply appropriate update when available.
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    packages:
     | Update | SUA 9.0.1
     | Update | ILMT 9.0.1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV61614

  • Reported component name

    IEM SW USE ANL

  • Reported component ID

    5725F57MT

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-06-17

  • Closed date

    2014-08-29

  • Last modified date

    2014-08-29

  • 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

    IEM SW USE ANL

  • Fixed component ID

    5725F57MT

Applicable component levels

  • R910 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSKLLW","label":"IBM BigFix Inventory"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
29 August 2014