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
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21598460