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

Last updated on NOVEMBER 25, 2022

Applies to:

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

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