JR51908: A DuplicateKeyException exception is thrown during the processin g of a backorder when Order Line Metrics is enabled.

7.0.0.9-WS-WCServer-IFJR51908
7.0.0.9-WS-WCDeveloperEnterprise-IFJR51908
7.0.0.9-WS-WCDeveloperProfessional-IFJR51908
7.0.0.9-WS-WCDeveloperExpress-IFJR51908

APAR status

• Closed as program error.

Error description

• When WebSphere Commerce Resource Value Unit (RVU) Order Line
  Metrics is enabled, the DuplicateKeyException exception is
  thrown when the ProcessBackOrder scheduler job is running.
  When the system is processing a backorder, it attempts to insert
   a second record of ORDAUDIT for the same order.  This disrupts
  the unique constraint on the column ORDERS_ID.
  

Local fix

Problem summary

• USERS AFFECTED:
  Customers with WebSphere Commerce Resource Value Unit (RVU)
  Order Line Metrics enabled.
  
  PROBLEM ABSTRACT:
  A DuplicateKeyException exception is thrown during the
  processing of a backorder when Order Line Metrics is enabled.
  
  BUSINESS IMPACT:
  Backordered orders cannot be processed when WebSphere Commerce
  Resource Value Unit (RVU) Order Line Metrics is enabled.
  
  RECOMMENDATION:
  

Problem conclusion

• Find the DuplicateKeyException, when it is caught. Update the
  existing ORDAUDIT record instead of inserting a new one.
  

Temporary fix

Comments

APAR Information

• 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