Batch Screening And Real Time Screening Job Is Failing in OWS (Doc ID 3004657.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Symptoms

Batch and Real time screening are failing

Steps to Reproduce:
Step1: Run the watchlist screening job

Actual Behavior:
Job fails after some time

Expected Behavior:
Job should be successful without any errors

Error encountered:

SEVERE: 05-Feb-2024 07:47:54: [EDQ-06972] [!dt dt.entity.host=HOST-xxxxxxxxxxxxxxxx,dt.entity.host_group=HOST_GROUP-xxxxxxxxxxxxxxx,dt.entity.process_group_instance=PROCESS_GROUP_INSTANCE-xxxxxxxxxxx] [job: PART 3 - Batch Screening:xxxx][exid: xxxx][runlabel: Watchlist Screening][ch0][PROCESS Entity Batch SAN Screening:2235][DJW_Entities_SAN][2]: job failed: error reading record
com.datanomic.director.runtime.data.RecordReadException: Unable to read from staged data "DJW_Entities_SAN". (Code: 203,200)
at com.datanomic.director.stageddata.datareaders.DataReader.read(DataReader.java:199)
at com.datanomic.director.stageddata.StagedRecordReader.read(StagedRecordReader.java:95)
at com.datanomic.director.runtime.reading.ReaderRecordSource.read0(ReaderRecordSource.java:69)
at com.datanomic.director.runtime.reading.AbstractRecordSource.read(AbstractRecordSource.java:101)
at com.datanomic.director.runtime.engine.RuntimeProcess.doTheStuff(RuntimeProcess.java:322)
at com.datanomic.director.runtime.engine.RuntimeProcessGroup$ProcessExecutable.execute(RuntimeProcessGroup.java:1755)
at com.datanomic.utils.execution.Parallelizer$Worker.run(Parallelizer.java:236)
at java.lang.Thread.run(Thread.java:825)
Caused by: com.datanomic.director.results.database.exception.sql.ResultsSQLException: A database error has occurred : Result set already closed. (Code: 200,302)
at com.datanomic.director.results.database.translator.MapErrorCodes.mapException(MapErrorCodes.java:71)
at com.datanomic.director.results.database.translator.MapErrorCodes.mapException(MapErrorCodes.java:85)
at com.datanomic.director.results.database.ResultsRetrievalDao.retrieveDataFromResultSet(ResultsRetrievalDao.java:218)
at com.datanomic.director.results.database.ResultsRetrievalDao.getDataFromExistingResultSet(ResultsRetrievalDao.java:506)
at com.datanomic.director.results.database.ResultsRetrievalDao.retrieveData(ResultsRetrievalDao.java:92)
at com.datanomic.director.results.database.ResultsRetrievalDao.retrieveBatchData(ResultsRetrievalDao.java:588)
at com.datanomic.director.stageddata.datareaders.DataReader.primeResults(DataReader.java:151)
at com.datanomic.director.stageddata.datareaders.DataReader.read(DataReader.java:182)

Changes

 NA

Cause

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