IBM Support

LG_DELIVERY_LOG exception

Troubleshooting


Problem

LG_DELIVERY_LOG exception

Symptom

SystemOut log shows the following exceptione:
ORA-20999: 20001 LG_DELIVERY_LOGI-1 ORA-00001: unique constraint (BCGAPPS.PK_DELIVERY_LOG) violated
AlertDB E com.ibm.bcg.alertEng.AlertDB dbError
AlertDB.getDocumentInfo - Error: java.sql.SQLException: Numeric Overflow at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMappinava:70)
AlertEventEng E com.ibm.bcg.alertEng.eventAlert.AlertEventEngineMessageHandler getRetryObj Receive failed max retries = 10, for msg <vuid>

Resolving The Problem

This error is typically seen after an abrupt system restart, or some other issue which caused the specific documents processing to fail.
To resolve this problem, locate the affected <vuids>, as in the above message then proceed as follows:
1 - Stop WPG appserver and bcgmas
2 - Open a terminal, switch to oracle user: su - <oracle user>, ie: su - oracle
3 - Connect to the WPG application database: sqlplus "<wpg application db name>/<wpg application db passeword>@<sid>", ie: sqlplus "bcgapps/bcgapps@orcl"
4 - Execute commands:
4a - delete from lg_delivery_log where activityid in ('vuid_1', 'vuid_n')
4b - commit;
5 - Restart bcgmas first and then WPG appserver

[{"Product":{"code":"SSDKKW","label":"WebSphere Partner Gateway Advanced Edition"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.2.1;6.2;6.1.1;6.1","Edition":"Advanced;Enterprise","Line of Business":{"code":"LOB02","label":"AI Applications"}},{"Product":{"code":"SSDKJ8","label":"WebSphere Partner Gateway Enterprise Edition"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"","label":"Linux on Power"},{"code":"","label":"Windows 2003 server"},{"code":"","label":"Linux pSeries"}],"Version":"6.2.1;6.2;6.1.1;6.1","Edition":"Advanced;Enterprise","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21598460

Page Feedback