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.