OFSAA DATA_LOAD_20220818 - AccountBalance datamap task failed.
(Doc ID 2891816.1)
Last updated on APRIL 24, 2023
Applies to:
Oracle Financial Services Behavior Detection Platform - Version 8.0 and laterInformation in this document applies to any platform.
Symptoms
On : 8.0 version, Data Ingestion
OFSAA DATA_LOAD_20220818 fail to run
Data load batch failed immediately after flexcube extraction was successfully done for 18th August 2022.
Please kindly look into this issue urgently as it affect the business day activities.
ERROR
-----------------------
2022-08-19 08:47:11,319 [PK_1223.P20220817] ERROR: 20005AccountBalance - Message 20005: Error rebuilding index PK_1223.P20220817 : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
2022-08-19 08:47:11,675 [ACCT_BP_HHID_IDX.P20220818] INFO : 22201AccountBalance - Message 22201: Done rebuilding index ACCT_BP_HHID_IDX.P20220818
2022-08-19 08:47:11,741 [PK_1223.P20220818] INFO : 22201AccountBalance - Message 22201: Done rebuilding index PK_1223.P20220818
2022-08-19 08:47:12,169 [ACCT_BP_SEQID_IDX] INFO : 22201AccountBalance - Message 22201: Done rebuilding index ACCT_BP_SEQID_IDX
2022-08-19 08:47:12,169 [main] ERROR: 10021AccountBalance - Message 10021: A Worker thread exited with an error
2022-08-19 08:47:12,170 [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)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
execute.sh AccountBalance
BUSINESS IMPACT
-----------------------
Delay in batch execution
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 |