IBM Support

Why am I seeing a DuplicateKeyException error related to the BPM_TASK_INDEX_JOB table?

Question & Answer


Question

We found a DuplicateKeyException reported in the systemout.log file. What do I need to do about it?
[9/26/20 16:49:42:761 EDT] 000000d6 ProcessIndexU E com.ibm.bpm.search.process.spi.impl.ProcessIndexUpdaterDaemon processWithDBTransport() CWLLG0865E: The BPM task search index job encountered the following persistence error. com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (BPM_PS.BPM_TASK_INDEX_JOB_PK) violated (INSERT INTO BPM_PS.BPM_TASK_INDEX_JOB (INDEX_ID, INDEX_START_TIME, INDEX_END_TIME, INDEX_LAST_PURGE_TIME, RECORDS_INDEXED, RESULT_VALUE) VALUES (?, ?, ?, ?, ?, ?))
[9/26/15 17:17:13:413 EDT] 000000d6 FfdcProvider W com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on /opt/WebSphere/AppServer/profiles/appsrv23/logs/ffdc/APPPS_20.09.26_17.17.13.3542578259630535657360.txt

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"ARM Category":[{"code":"a8m50000000CccpAAC","label":"Process Portal-\u003EProcess Portal Searches-\u003ESearch Index (Quick Search)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
24 November 2020

UID

ibm16372260