Interested in this also, we decom'd a machine before evicting it from Bladelogic Application Servers.
I have the same issue old server from 7.6 environment which was shutdown and decom'd.
Anyone know how to resolve this?
Never mind I found this solution that was posted.. this should work.
SQL>select host_name from application_server where IS_DELETED=0;
SQL> update application_server set is_deleted = 1 where host_name in ('HOSTNAME1', 'HOSTNAME2');
replace the HOSTNAMEx with your hostname you want to get rid of.
I would update application_server_model, not application_server.
1 of 1 people found this helpful
Normally you should use the infrastructure management to delete an app_server deployment properly. However if this wasn't done before the server was decommissioned, you won't be able to, so do this:
(let's say your deployment is named job_server_1)
update application_server set status_id = 4 where app_server_name = 'job_server_1' update application_server_model set name = 'job_server_1(deleted)', is_deleted = 1 where display_name = 'job_server_1'
That's basically what the GUI is doing when you delete a server from the infrastructure management window. The only exception is that the GUI uses a random float number in the name of the app server it deletes instead of using the word "deleted" like I did. The end result will be the same however.
Then restart all other app servers to refresh the infrastructure management window.
Note: if the deployment was a second instance on an existing application server, manually delete the deployment folder for the deployment you want to remove before restarting the application servers
typically tagging the row as is_deleted = 1 in both tables is all that's needed.