My Oracle Support Banner

Transaction Monitoring Batch Is Failing : ERROR: 20005AccountBalance - Message 20005: Error rebuilding index PK_1209.P20210806 : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found (Doc ID 2820316.1)

Last updated on MAY 23, 2023

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Aml batch AccountBalance bdf is failing

Job log has below error:

/u03/ofsaa/bd806/bdf/inbox/AccountBalance_20210807_DLY_01.dat
2021-10-18 19:54:09,199 [PK_1209.P20210806] INFO : 22200AccountBalance - Message 22200: Rebuilding index PK_1209.P20210806
2021-10-18 19:54:09,199 [ACCT_BP_HHID_IDX.P20210809] INFO : 22200AccountBalance - Message 22200: Rebuilding index ACCT_BP_HHID_IDX.P20210809
2021-10-18 19:54:09,199 [PK_1209.P20210809] INFO : 22200AccountBalance - Message 22200: Rebuilding index PK_1209.P20210809
2021-10-18 19:54:09,198 [ACCT_BP_SEQID_IDX] INFO : 22200AccountBalance - Message 22200: Rebuilding index ACCT_BP_SEQID_IDX
2021-10-18 19:54:09,278 [PK_1209.P20210806] ERROR: 20005AccountBalance - Message 20005: Error rebuilding index PK_1209.P20210806 : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
2021-10-18 19:54:09,433 [ACCT_BP_HHID_IDX.P20210809] INFO : 22201AccountBalance - Message 22201: Done rebuilding index ACCT_BP_HHID_IDX.P20210809
2021-10-18 19:54:09,462 [PK_1209.P20210809] INFO : 22201AccountBalance - Message 22201: Done rebuilding index PK_1209.P20210809
2021-10-18 19:54:09,703 [ACCT_BP_SEQID_IDX] INFO : 22201AccountBalance - Message 22201: Done rebuilding index ACCT_BP_SEQID_IDX
2021-10-18 19:54:09,704 [main] ERROR: 10021AccountBalance - Message 10021: A Worker thread exited with an error
2021-10-18 19:54:09,705 [main] ERROR: 10200AccountBalance - Message 10200: com.ofss.bdf.common.FatalException: A Worker thread exited with an error
at com.ofss.bdf.common.IndexRebuilder.rebuildIndexes(Unknown Source)
at com.ofss.bdf.datamap.DataMapProcessor.process(Unknown Source)
at com.ofss.bdf.common.BDFProcessLauncher.main(Unknown Source)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.