IBM Support

JR46732: CMVC 228513

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When running StagingProp with Oracle backend databases, the
    utility may terminate abnormally if the following conditions are
     satisfied:
     - Backend databases are Oracle
     - Table being propagated has one or more LOB-type columns
     - Operation being propagated is of type 'I' or INSERT
     - Diagnostic data in the StagingProp utility log file contains
    output similar to the following:
     ...
     20130501-160621| <Error> The command failed to propagate the
    change related to the STAGLOG record <number>.
     20130501-160621|
     <SQLException> ORA-24816: Expanded non LONG bind data supplied
    after actual LONG or LOB column
    
     SQLState: 99999
     Vendor Error Code: 24816
     Stack trace:
     java.sql.SQLException: ORA-24816: Expanded non LONG bind data
    supplied after actual LONG or LOB column
    
          at
    oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:7
    65)
          at
    oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:6
    62)
          at
    oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPr
    eparedStatement.java:546)
          at
    oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPrepar
    edStatement.java:729)
          at
    oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
    atement.java:1329)
          at
    oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
    ePreparedStatement.java:3584)
          at
    oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OracleP
    reparedStatement.java:3665)
          at
    oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(
    OraclePreparedStatementWrapper.java:1352)
     ...
    

Local fix

  • None exists
    

Problem summary

  • USERS AFFECTED:
     WebSphere Commerce users on v7.0 with Oracle 10g or 11g as
    their backend database attempting to propagate tables with
    LOB-type data in them
    
     PROBLEM ABSTRACT:
     ORA-24816 Exception encountered by the StagingProp utility
    
     BUSINESS IMPACT:
     This issue will prevent newly added data from being propagated
    to production environments via the StagingProp utility
    
     RECOMMENDATION:
     Contact WebSphere Commerce Support for assistance
    

Problem conclusion

  • Revised the StagingProp utility by reordering columns in INSERT
    statements to always place LONG and LOB-type columns at the end
    of the column specification list during the propagation phase of
     the utility
     -------------------------------------------------------------
     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

    JR46732

  • 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

    2013-05-23

  • Closed date

    2013-11-02

  • Last modified date

    2013-11-02

  • 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:
02 November 2013