Search Engine: Elastic

Article ID: 131906, created on Dec 13, 2017, last review on Dec 13, 2017

  • Applies to:
  • Operations Automation 7.0

Symptoms

Task "Cleanup packages on host" fails with message: "error while executing work". In core.log more verbose error message is available:

Caused by: java.sql.SQLException: ERROR: update or delete on table "iis_services" violates foreign key constraint "iis_websrvs_fk_0" on table "iis_webvsrvs"
Detail: Key (service_id)=(68) is still referenced from table "iis_webvsrvs". Query:  DELETE FROM  iis_services  WHERE   (  service_id  =  ?  )  Parameters: [68]

Cause

Due to database inconsistency some entries related to sharepoint webspaces were left on host.

Resolution

In order to process the tasks direct database interaction is required. Please contact Odin Technical Support.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF