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