ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
SQL Agent does not failover to other CP's
Article ID: 87954
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message :
N/A
In a multi-node configuration, the SQL Agent will not attempt to make a connection to another CP if the CP it is connected to fails.
N/A
In a multi-node configuration, the SQL Agent will not attempt to make a connection to another CP if the CP it is connected to fails.
Cause
Cause type:
Defect
Root Cause: SQL Agent not identifying other CP's on reconnect.
Defect
Root Cause: SQL Agent not identifying other CP's on reconnect.
Environment
OS Version: N/A
Resolution
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Fix Version(s):
Agent SQL 12.0.1 - Available
Agent SQL 11.2.3 - Available
Automation.Engine 12.0.1 – Available
Automation.Engine 11.2.3 - Available
Fix Status: Released
Fix Version(s):
Agent SQL 12.0.1 - Available
Agent SQL 11.2.3 - Available
Automation.Engine 12.0.1 – Available
Automation.Engine 11.2.3 - Available
Additional Information
Workaround :
Stop and restart the Agent manually
Stop and restart the Agent manually
Feedback
Yes
No
Powered by
