Direct links to fixes
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 number
JR48185
Reported component name
WC BUS DEV ED W
Reported component ID
5724I3900
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / Pervasive
Submitted date
2013-10-24
Closed date
2014-05-02
Last modified date
2014-05-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 DEV ED W
Fixed component ID
5724I3900
Applicable component levels
R700 PSY
UP
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
07 December 2021