CS batch failed at part2 preparing Reference data (Doc ID 2760428.1)

Last updated on NOVEMBER 25, 2022

Applies to:

Oracle Financial Services Customer Screening - Version 8.0.5 and later
Information in this document applies to any platform.

Symptoms

CS batch failed at PART 2 - Prepare Reference Data while triggering from OFSAA Batch Execution UI.

Error in EDQ main0.log

[EDQ-06917] [process Generate Watchlist Filter Flags [1082]/job:PART 2 - Prepare Reference Data (1259):[34215]] : started execution
SEVERE: Error while dropping table {0} : A database error has occurred : ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired. (Code: 200,302)
com.datanomic.director.results.database.exception.sql.ResultsSQLException: A database error has occurred : ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired. (Code: 200,302)
at com.datanomic.director.results.database.translator.MapErrorCodes.mapException(MapErrorCodes.java:71)
at com.datanomic.director.results.database.AbstractTableDAO.executeTransactionalSQL(AbstractTableDAO.java:113)
at com.datanomic.director.results.database.AbstractTableDAO.executeTransactionalSQL(AbstractTableDAO.java:86)
at com.datanomic.director.results.database.TableCreateAndDeleteDao.dropTableByName(TableCreateAndDeleteDao.java:533)
at com.datanomic.director.results.database.TableCreateAndDeleteDao.dropTable(TableCreateAndDeleteDao.java:259)
at com.datanomic.director.results.database.TableCreateAndDeleteDao.dropAndCreateTable(TableCreateAndDeleteDao.java:558)
SEVERE: 10-Mar-2021 10:28:41: [EDQ-06919] [process Generate Watchlist Filter Flags [1082]/job:PART 2 - Prepare Reference Data (1259):[34215]] : runtime process terminated uncleanly: Failed to open record writer: A database error has occurred : ORA-00955: name is already used by an existing object. (Code: 200,302) (Code: 200,302) (Code: 200,302) (Code: 201,067)

Steps to reproduce :

Step 1 : Open customer screening as Admin user.

Step 2 : Run CS batch through OFSAA UI

Step 3 : Check in task logs.

Expected result :

Call EDQ task must complete without issues and generate matches and alerts

Actual result :

Call EDQ task failed with Error in main0.log