JR48185: DuplicateKeyException error shows for CATENTDESC when catalog data is uploaded using the data load utility

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• When trying to upload catalog data via the Websphere Commerce
  Management Center or via the data load utility, a
  DuplicateKeyException error may appear in the log, similar to
  the following :
  
  000001ac database      1   Execute statement : INSERT INTO
  CATENTDESC (CATENTRY_ID, LANGUAGE_ID, NAME, SHORTDESCRIPTION,
  THUMBNAIL, AUXDESCRIPTION1, FULLIMAGE, AUXDESCRIPTION2,
  AVAILABLE, PUBLISHED, AVAILABILITYDATE, KEYWORD, OPTCOUNTER,
  LONGDESCRIPTION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
  ?)
  ..
   000001ac util >
  com.ibm.commerce.foundation.dataload.util.DataLoadHelper
  printSQLException ENTRY
  com.ibm.websphere.ce.cm.DuplicateKeyException: DB2 SQL Error:
  SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;DB2ADMIN.CATENTDESC,
  DRIVER=4.14.113
  000001ac util W SQL Exception: DB2 SQL Error: SQLCODE=-803,
  SQLSTATE=23505, SQLERRMC=1;DB2ADMIN.CATENTDESC, DRIVER=4.14.113,
  SQL
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere commerce users who use the data load utility for
  catalog data for SEOURL and CATENTDESC
  
  PROBLEM ABSTRACT:
  DuplicateKeyException error shows for CATENTDESC when catalog
  data is uploaded using the data load utility
  
  BUSINESS IMPACT:
  Unable to load data in to the WebSphere Commerce database
  
  RECOMMENDATION:
  

Problem conclusion

• The internal logic for the dataload utility caused all tables to
   be treated as insertions when the primary table is determined
  to be an insertion.  An enhancement  has been added to the
  catalog mediator to allow an update of an entry rather than
  insertion in the CATENTDESC  table to avoid the
  DuplicateKeyException.
  -------------------------------------------------------------
  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 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 DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP