My Oracle Support Banner

Error while running watchlist management Job to load private list (Doc ID 2736641.1)

Last updated on DECEMBER 20, 2020

Applies to:

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

Symptoms

While executing download, prepare, filter job from the watchlist management project in EDQ, the private lists are not updated to the PRIV_Individuals_Prepared data.

Below error is observed in main0.log

SEVERE: 20-Nov-2020 00:09:16: [EDQ-06864] data batch 6 terminated by exception com.datanomic.director.runtime.data.RecordWriteException: Error writing to export ALL_Lists_Ind_JSON_Data: Problem writing insert batch to database: ORA-01400: cannot insert NULL into ("OFSAATFLT"."FSI_RT_LIST_DATA_STG"."N_REC_ID") (Code: 2,078) (Code: 203,051) at com.datanomic.director.exports.task.ExportWriter.write(ExportWriter.java:498) at com.datanomic.director.runtime.data.wrappers.RecordFromMessage.write(RecordFromMessage.java:45) at com.datanomic.director.runtime.data.util.DataPump$Worker.doStuff(DataPump.java:429) at com.datanomic.director.runtime.data.util.DataPump$Worker.run(DataPump.java:385) at java.lang.Thread.run(Thread.java:745) Caused by: com.datanomic.utils.databasespecies.DatabaseException: Problem writing insert batch to database: ORA-01400: cannot insert NULL into ("OFSAATFLT"."FSI_RT_LIST_DATA_STG"."N_REC_ID") (Code: 2,078) at com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.error(JDBCInserter.java:787) at com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.flushImpl(JDBCInserter.java:730) at com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.flush(JDBCInserter.java:660) at com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.doneImpl(JDBCInserter.java:707) at com.datanomic.utils.databasespecies.operations.jdbc.JDBCInserter.done(JDBCInserter.java:641) at com.datanomic.director.exports.task.ExportWriter.write(ExportWriter.java:488) ... 4 more

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


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