Search Engine: Elastic

Article ID: 131289, created on Aug 11, 2017, last review on Aug 11, 2017

  • Applies to:
  • Operations Automation 6.0

Symptoms

Task on removal if IIS webspace fails with the following message:

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

In OA logs the database operation could be clarified by the following line:

Caused by: java.sql.SQLException: ERROR: update or delete on table "iis_webvdirs" violates foreign key constraint "iis_siteapps_virt_dirs_fk1" on table "iis_siteapps_virt_dirs"
  Detail: Key (dir_id)=(2151) is still referenced from table "iis_siteapps_virt_dirs". Query:  DELETE FROM  iis_webvsrvs  WHERE   (  srv_id  =  ?  )  Parameters: [5850]

The subscription itself is quite old and does not contain any siteapps.

Cause

Database inconsistency occurred in subscription's early days.

Resolution

Please contact Odin Technical Support to apply a workaround for task.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF