Article ID: 129650, created on Oct 23, 2016, last review on Oct 23, 2016

  • Applies to:
  • Operations Automation


Task Cleanup host hostname01.domain.tld fails with the following error:

Task ID 39123972
Queue name      host_operations_360
Task name       Cleanup host hostname01.domain.tld
Task description Task that moves hosts to archive in system database
Subscription ID 1
Queue status    Failed
Start not earlier than  Aug-25-2015 07:37
Method name     cleanupHost on SCREF:HostManager:0
Last execution output   Foreign key 'hd_host_fk3' violation while executing 'error executing work'.

The following constraint violation can be found in poa.log:

Caused by: java.sql.SQLException: ERROR: update or delete on table "hosts" violates foreign key constraint "hd_host_fk3" on table "home_directories"  Detail: Key (host_id)=(360) is still referenced from table "home_directories". Query:  DELETE FROM hosts WHERE host_id = ? Parameters: [360]


The issue occurs due to leftover records in OA DB. Exact reason has not been determined.


Please contact Odin technical support to fix the issue.

Search Words

Foreign key 'mssql_services_fk0' violation while executing 'error executing work'.

Remove Hardware Nodes MSSQL1 and WINWEB01

Foreign key 'hd_host_fk3' violation while executing 'error executing work'.


Cleanup host

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF