'Cleanup host' task fails with the error Foreign key 'mssql_services_fk0' violation while executing 'DELETE FROM services WHERE service

'Cleanup host' task fails with the error Foreign key 'mssql_services_fk0' violation while executing 'DELETE FROM services WHERE service_id = ?'.

Modified on: Wed, 5 Feb, 2020 at 9:56 PM

Operations Automation Operations Automation:5.5 Operations Automation:5.x Operations Automation:6.0 Operations Automation:6.x Operations Automation:7.1 Operations Automation:7.3 Operations Automation:7.4 Operations Automation:7.x

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_services 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.

Internal content

Link on internal Article

Did you find it helpful? Yes No