Banner Agent Fails with Error 17410 SQLState 08000 Due to Network Idle Timeout

Products

• Automic Applications Manager

Issue/Introduction

Scheduled Banner jobs fail intermittently with SQLState 08000 (No more data to read from socket) when jobs run concurrently or after periods of inactivity. This issue occurs when the network device or database listener terminates the connection due to an idle timeout setting, causing the Banner Agent Job to abort due to connectivity loss.

Symptoms:

• Banner jobs abort with ErrorCode 17410 (SQLState 08000).
• Error message: "No more data to read from socket".
• Issue occurs after a period of inactivity on Banner Agent
• AgentService logs indicate connection termination on Job abort

Environment

• Automic Applications Manager
• BannerAgent

Resolution

The error 17410 indicates the socket connection between the Banner Agent and the database has been closed by the network infrastructure (e.g., firewall or network idle timeout).

1. Review network idle timeout settings on the firewall, load balancer, or network devices between the Banner Agent host and the Oracle database server.
2. Adjust the network idle timeout to be longer than the maximum expected duration of job inactivity.
3. If a firewall is terminating the connection, verify if keep-alive settings can be adjusted or if a persistent connection can be maintained.
4. Consult with the network team to ensure the Banner Agent connection is not being dropped by network policies.

Workaround:

Schedule a "dummy" or low-impact Banner job to run on an interval shorter than the firewall/network/timeout window or shortly before period of inactivity ends. 

Additional Information

If the issue persists after reviewing network settings, please Contact Broadcom Support for further investigation.