IBM Support

JR43090: CMVC - 223432 PROVIDE ONE OPTIONAL PARAMETER ROLLBACKFORANYEXCEPTION IN THE DATA LOAD CONFIGURATION..

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Dataload utility will rollback a transaction only in the
    event of an SQL exception. For some business cases, the
    transaction may need to be rolled back for any type of
    exception, such as incorrect data in the input file that leads
    to a NumberFormatException or similar exception.
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce users on v7.0 who use dataload utility.
    
    PROBLEM ABSTRACT:
    The Dataload utility will rollback a transaction only in the
    event of an SQL exception.  Other exceptions are not considered
    for rollback.
    
    BUSINESS IMPACT:
    The business user will not be able see the transaction get
    rollback properly.
    
    RECOMMENDATION:
    

Problem conclusion

  • The APAR provides an optional parameter to support to rollback
    database transaction for any exceptions. By adding one extra
    parameter in the wc-dataload.xml:
    <_config:property name="rollbackForAnyException" value="true" />
    
    If this value is set to be "true", the Dataload utility will
    rollback the database transaction for any type of exception.
    
    -------------------------------------------------------------
    The latest available maintenance information can be obtained
    from the Recommended Fixes for WebSphere Commerce technote:
    http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR43090

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-13

  • Closed date

    2012-07-27

  • Last modified date

    2012-07-27

  • 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

    WC BUS EDITION

  • Fixed component ID

    5724I3800

Applicable component levels

  • R700 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
27 July 2012