We have encountered a problem when we attempt to delete or remove an old agents which no longer exist. We are seeing an error message "You cannot delete a server that is being used by Release Center artifacts."
Release : 6.6, 6.7, 6.8
Component : CA RELEASE AUTOMATION RELEASE OPERATIONS CENTER
There are two possible causes for this error:
1. The agent in question currently belongs to an agent group.
2. A problem with the database is preventing the removal. (This is an environment-specific problem in which somehow the data within the database was improperly altered/corrupted/etc.)
The Agent belonging to an Agent Group is the most likely cause of this and the following steps will allow remove for the majority of clients that encounter this issue.
If this steps above do not reveal or help address all associations then it is likely that the agent was directly assigned as the retrieval agent - or there is corruption in the database preventing the agent from being deleted or removed. The following information addresses how to clear an agent in this state directly from the database.
Note: Before proceeding, be absolutely certain that the agent does not belong to any agent groups using the steps above.
Please work with your database user/administrator to perform the following steps.
As with any changes directly in the database, ensure there is a backup prior to any modifications as there is a potential to damage the data in the tables leading to other problems or failures.
To void using database update statements to fix the problem, see the steps outlined in the "Additional Information" section for how to identify the artifacts - so they can be found through the UI and altered there instead.
To solve using DB select/update:
Once completed, you should be able to remove the agent in question.
If you want to avoid running the 'update' statement, you can try using the following queries to identify where the artifact can be found so that you can navigate to it via the UI and change the artifact retrieval agent/group of that artifact: