IBM Support

SQL exception or ORA-20999

Troubleshooting


Problem

java.sql.sqlexception: ORA-20999: 20002 LG_eventi_ah1-1 ORA-00001: unique constraints (BCGAPPS.PK_event) violated

Symptom

java.sql.sqlexception:
ORA-20999: 20002 LG_eventi_ah1-1
ORA-00001: unique constraints (BCGAPPS.PK_event) violated

Cause

The SQL errors occur when the same events are attempted to be updated again into DB. After certain number of attempts, finally these events are moved into the DataLogErrorq. Once the event is logged into the database, the event should be removed from the MQ queue. Looks like here, even though the event is logged into the database, it's not removed from the queue and as a result, its attempted to be updated again.

Resolving The Problem

Follow these steps to resolve the problem:

  1. Stop the servers
  2. Clear the datalogErrorQ and the datalogQ
  3. Clear router logs
  4. Restart the servers

[{"Product":{"code":"SSDKJ8","label":"WebSphere Partner Gateway Enterprise Edition"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.0;6.0.0.1;6.0.0.2;6.0.0.3;6.0.0.4;6.0.0.5;6.0.0.6;6.0.0.7","Edition":"Advanced","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21307552

Page Feedback