Task 'Cleanup packages on host' fails with: 'delete on table "iis_services" violates foreign key constraint "iis_websrvs_fk_0" on table "iis

Task 'Cleanup packages on host' fails with: 'delete on table "iis_services" violates foreign key constraint "iis_websrvs_fk_0" on table "iis_webvsrvs"'

Modified on: Wed, 5 Feb, 2020 at 10:09 PM

Operations Automation Operations Automation:7.0 Operations Automation:7.x

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.

Internal content

Link on internal Article

Did you find it helpful? Yes No