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

Article Id: 140688

Status: Published

Updated On: 22-11-2019 11:25

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).