DB Unload fails at the 30 minute mark with a DEADLOCK and ORA-03135: connection lost contact

Products

• CA Automic Workload Automation - Automation Engine
• AUTOMIC WORKLOAD AUTOMATION
• CA Automic One Automation
• CA Automic Operations Manager
• CA Automic Oracle

Issue/Introduction

When running an Unload (as part of maintenance) the unload fails at a specific time interval with the following:

20190926/181705.788 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '1:664.377.999'
20190926/181705.788 - U00003525 UCUDB: ===> 'insert into DIVDB (DIVDB_PK) select distinct RH_AH_idnr from RH where RH_DeleteFlag = 1 and rownum <= 1000'
20190926/184708.443 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 106ef50  DB-HDBC: 10e6068
20190926/184708.443 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20190926/184708.443 - U00003592 UCUDB - Status: '' Native error: '3135' Msg: 'ORA-03135: connection lost contact

 

Environment

Release : 12.0

Component : AUTOMATION ENGINE

Resolution

This is due to a firewall/network setting that is severing the connection.

This can be due to the time involved in running a single command (for example, removing millions of rows in one sql statement).