search cancel

SQL JOB fails with IO Error: Socket read timed out

book

Article ID: 241111

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

A SQL job object that runs a query on a database using a SQL connection object occasionally fails with this "socket read time out" error message:

2022-04-15 15:30:09 - U02012031 The database driver returned the following error message:
2022-04-15 15:30:09 IO Error: Socket read timed out
2022-04-15 15:30:09 - U02004025 Job-script execution was aborted.

4/15/2022 03:30:09 PM
 
U00011003 Job 'SQL.JOB.NAME' (RunID '0017814985') on Host 'SQL_AGENT_NAME' aborted (return code='0102'). Remote status=Waiting for Database

Execution history of when this job fails fails with a timeout always after the same amount of time such as a minute.

Environment

Release : 12.3

Component : Database agent

Resolution

This is due to settings on the database.  There is either a timeout set or something else that is blocking connections to the database from remote servers.  

In one case, there was a month end processes that caused a heavy load on the db and so the db was set up to no longer allow new connections that would add to stress, so it timed them all out.