[HDC] Error In HDC Task But Batch Still Run Successfully (Doc ID 2928359.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

We are running batch for AML and have an issue as follow:
- The HDC task was error, no data was inserted to arc tables.
- When we checked the logs, there are some warning messages for connect error.


ERROR
-----------------------


[Thu 05/1/2023 03:27:03] [HDC] [ WARN] - HDC - Message 265184: Exception occurred while processing archive data: java.sql.SQLRecoverableException: IO Error: Connection reset by peer
[Thu 05/1/2023 03:29:11] [HDC] [ WARN] - HDC - Message 265184: Exception occurred while processing archive data: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
[Thu 05/1/2023 03:31:18] [HDC] [ WARN] - HDC - Message 265184: Exception occurred while processing archive data: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
[Thu 05/1/2023 03:33:25] [HDC] [ WARN] - HDC - Message 265184: Exception occurred while processing archive data: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
[Thu 05/1/2023 03:35:32] [HDC] [ WARN] - HDC - Message 265184: Exception occurred while processing archive data: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
[Thu 05/1/2023 03:36:13] [HDC] [ INFO] - HDC - Message 265111: Completed Historical Data Copy at Thu Jan 05 15:36:13 ICT 2023


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
$FIC_HOME/database/db_tools/bin/run_hdc.ksh

Cause

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