Symptoms
On attempt to remove Microsoft SQL server from OA, the following task fails:
Task ID 123123123
Queue name host_operations_350
Task name Cleanup host mssql.hosting.local
Task description Task that moves hosts to archive in system database
Subscription ID 1
Queue status Failed
Start not earlier than Sep-10-2014 13:48
Method name cleanupHost on SCREF:HostManager:0
Last execution output
Foreign key 'mssql_services_fk0' violation while executing ' DELETE FROM services WHERE service_id = ?'.
Cause
Task Cleanup packages on host %hostname%
does not remove entries from mssql_service
s table.
The issue has been submitted to the development team as POA-88609.
Resolution
Please contact Odin technical support to clean up records from OA database.