KBI 311901 Argent Job Scheduler Oracle Scripts randomly timing out

Version

Argent Job Scheduler 1804 or Above

Date

Wednesday, 13 January 2021

Summary

Argent Job Scheduler Oracle Scripts randomly timing out after moving to new Oracle 19 server

Technical Background

Some Argent Job Scheduler Oracle Scripts are timing out when running outside of Argent Job Scheduler and when running within Argent Job Scheduler

Upgraded to the newest Oracle ODBC drive by following instructions from Oracle website

https://www.oracle.com/database/technologies/releasenote-odbc-ic.html

Subnet for Argent Job Scheduler server is using Cisco Firewall

Firewall health checks were causing random packet losses causing Argent Job Scheduler scripts to fail

Resolution

Due to firewall health checks subnet for Argent Job Scheduler was removed from firewall