Search Engine: Elastic

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

  • Applies to:
  • Operations Automation

Symptoms

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]

Cause

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

Resolution

Please contact Odin technical support to fix the issue.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF