Article ID: 127191, created on Oct 18, 2015, last review on Oct 18, 2015

  • Applies to:
  • Operations Automation 5.5

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.

Search Words

Foreign key 'mssql_services_fk0' violation while executing ' DELETE FROM services WHERE service_id = ?'.

remove hardware node

cleanup

Cleanup host MSSQL01.secure.local

deleteing servers from POA

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF