WatchList Management is failing in EDQ (Doc ID 2880855.1)

Last updated on JULY 07, 2022

Applies to:

Symptoms

Steps to reproduce:
Step1: Run watchlist Management with run profile

Actual Behavior:
Getting error of connection reset by peer

Expected Behavior:
Watchlist management job should be run successfully.

Issue Encountered:
1. Main0.log:
SEVERE: 02-Jul-2022 07:32:35: [EDQ-10325] Unable to connect to configuration database: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection for datasource 'edqResultsDS'. The DBMS driver exception was: IO Error: Connection reset by peer, Authentication lapse 1 ms.
SEVERE: 02-Jul-2022 07:32:35: [EDQ-01800] Error in database operation: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection for datasource 'edqResultsDS'. The DBMS driver exception was: IO Error: Connection reset by peer, Authentication lapse 1 ms.
weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection for datasource 'edqResultsDS'. The DBMS driver exception was: IO Error: Connection reset by peer, Authentication lapse 1 ms.
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:278)
at weblogic.jdbc.common.internal.WLDataSourceImpl.getPoolConnection(WLDataSourceImpl.java:563)
The above error is related to DB connectivity issue. Can you please check with your DB administrator on this please?
2. EDQ_server1.log:
In this log we see same error as above and also have below error:
<Jul 2, 2022 7:32:35,525 AM EAT> <Error> <oracle.edq.main> <EDQ-06914> <[process Initialise Output Staged Data [192]/job:Download, Prepare, Filter and Export All Lists (130):[65]] : error during process preparation
com.datanomic.director.runtime.AbortedProcessException: Failed to open record writer: Unable to add row to table column info table (Code: 200,310) (Code: 200,310) (Code: 200,310) (Code: 201,067)
at com.datanomic.director.runtime.writing.RuntimeWriterConfiguration.getSinks(RuntimeWriterConfiguration.java:166)
at com.datanomic.director.runtime.engine.RuntimeProcessGroup.execute(RuntimeProcessGroup.java:968)
at com.datanomic.utils.execution.Parallelizer$Worker.run(Parallelizer.java:222)
at com.datanomic.utils.execution.Parallelizer$Worker.runHere(Parallelizer.java:187)
at com.datanomic.utils.execution.Parallelizer.run(Parallelizer.java:85)
at com.datanomic.director.runtime.engine.RuntimeProcessCloud.execute(RuntimeProcessCloud.java:980)
at com.datanomic.director.runtime.coordination.BasicExecutionCoordinator.run(BasicExecutionCoordinator.java:132)
at com.datanomic.director.runtime.coordination.AbstractExecutionCoordinator.execute(AbstractExecutionCoordinator.java:171)
at com.datanomic.director.runtime.engine.jobs.RuntimeProcessJob.runTask(RuntimeProcessJob.java:486)
at com.datanomic.director.missionmanager.executor.ThreadResources.ThreadConstrainedWorkUnit$TaskWrapper.run(ThreadConstrainedWorkUnit.java:426)
at java.lang.Thread.run(Thread.java:748)
Caused By: com.datanomic.director.runtime.data.WriterConfigurationException: Unable to add row to table column info table (Code: 200,310) (Code: 200,310) (Code: 200,310)
at com.datanomic.director.stageddata.StagedRecordConsumer.getWriter(StagedRecordConsumer.java:100)
at com.datanomic.director.runtime.writing.RuntimeWriterConfiguration$W.toWriter(RuntimeWriterConfiguration.java:375)
at com.datanomic.director.runtime.writing.RuntimeWriterConfiguration.getSinks(RuntimeWriterConfiguration.java:150)

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.