IBM Support

IZ65705: CMVC 194305 - FIX DBCLEAN CONFIG FOR OBJECT 'PAYMENTRULE' AND TYPE 'OBSOLETE' WHICH CAN CAUSE LOSS OF DATA IN PPCPAYINST TABLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DBClean configuration for object "PaymentRule" and type
    "obsolete" can cause loss of data in the PPCPAYINST table when
    the RMA table is empty due to an error in the delete statement
    that is executed.
    

Local fix

Problem summary

  • USERS AFFECTED:
    This issue applies to WebSphere Commerce V6.0 and V7.0 customers
    using the Database Cleanup utility (dbclean) for object
    "PaymentRule" and type "obsolete".
    
    PROBLEM ABSTRACT:
    Correct the DBClean configuration for object "PaymentRule" and
    type "obsolete" which can cause loss of data in the PPCPAYINST
    table.
    
    BUSINESS IMPACT:
    The PPCPAYINST table is used by the Payment Plug-in Controller
    to store payment instructions. Data on this table could be lost
    when DBClean is used for this table and the RMA table is empty.
    
    RECOMMENDATION:
    

Problem conclusion

  • The Interim Fix associated with APAR IZ65705 updates the delete
    statement for the PPCPAYINST table which is contained in the
    CLEANCONF table. Apply this fix to resolve the issue.
    
    -------------------------------------------------------------
    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

    IZ65705

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3801

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-23

  • Closed date

    2010-01-28

  • Last modified date

    2010-01-28

  • 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

    5724I3801

Applicable component levels

  • R600 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":"6.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
28 January 2010