Z-Archive » Maybank Projects » Maybank RCAS » Maybank/Bii - RCAS - RCMS SIT/UAT support

Issue Description:
The error was thrown when system trying to insert data with duplicate primary key into ADMIN_AUDIT_LOG table.

From the result in excel file, the LOG_ID in ADMIN_AUDIT_LOG is 5987. But the last number in SQ_AUDIT_LOG is 5986. And, in ADMIN_AUDIT_LOG table, LOG_ID is the primary key, where this ID is get from the next number in SQ_AUDIT_LOG. In this case, system will use 5987 as LOG_ID, which 5987 already been used.

This duplicate key issue occurred is because there is possibility data is manually inserted into the database, or the last number in SQ_AUDIT_LOG has been changed.

Solution:
To solve this issue, execute below query to get latest LOG_ID,
"SELECT LOG_ID FROM ADMIN_AUDIT_LOG WHERE ROWNUM = 1 ORDER BY LOG_ID DESC;"

Then, use the latest LOG_ID from above query to minus 5986 and execute below query with the result (eg. latest LOG_ID - 5986 = $number),
"ALTER SEQUENCE SQ_AUDIT_LOG INCREMENT BY $number;
SELECT SQ_AUDIT_LOG.NEXTVAL FROM dual;
ALTER SEQUENCE SQ_AUDIT_LOG INCREMENT BY 1;"

Conclusion:
Issue solved, confirm by customer.

released to Bank