After replacing an Agent all WPs stop functioning
search cancel

After replacing an Agent all WPs stop functioning


Article ID: 87274


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :
DS_REPLACE13 - Cannot insert duplicate key in object 'dbo.OLC

After Replacing an agent with another all WP's stop working.

A database error similar to the one above occurrs if the new Agent that should replace the old one is not in the Login object.  To avoid the database error be sure that the new Agent is in the Login object.

  1. Open the Agent tab in System Overview, right click on Agent_01 and Replace.
  2. Select the Agent_02 for replacing Agent_01
Automic then attempts to update Login_1 using and update similar to this:
update OLC set OLC_Host = 'Agent_02' where OLC_OH_Idnr = 100090 and OLC_Type = 'WINDOWS' and OLC_Host = 'Agent_01'

Because the OLC_Host is a PK we get "Cannot insert duplicate key in object 'dbo.OLC".



OS Version: N/A


Cause type:
Root Cause: A database error occurred by replacing an agent with another.


Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Automation Engine 12.1.0 - Available
Automation Engine 12.0.1 - Available
Automation Engine 11.2.4 – Available
Automation Engine 11.1.5 - Available

Additional Information

Workaround :
Perform a cold start.

BEWARE:  Performing a cold start can have adverse affects on the Automation Engine installation.  Contact Automic support prior to performing this action.