RDW Batches Fail With Database Connection Error: "IO Error: Connection Reset" (Doc ID 1415233.1)

Last updated on JUNE 16, 2016

Applies to:

Oracle Retail Data Warehouse - Version 13.1.3 and later
Information in this document applies to any platform.


With RDW 13.1/RETL 13.1 and DB, the batches fail with the below error when they are scheduled in parallel:


Starting the threads
FATAL - retl 13.1.3 build 1758 (20.2-b06 :: Sun Microsystems Inc. :: i386 :: Linux :: 2.6.18-194.el5)

FATAL - E135: Exception in operator [oraread:3]
E415: Unable to obtain connection to database. (connectionstring="jdbc:oracle:thin:@",userid="rdwprd")
--- SQLException caught ---
java.sql.SQLRecoverableException: IO Error: Connection resetMessage: IO Error: Connection resetXOPEN SQL State: 08006
Database Vendor Driver/Source Error Code: 17002


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms