Article ID: 117409, created on Sep 20, 2013, last review on Apr 25, 2014

  • Applies to:
  • Operations Automation 5.5
  • Operations Automation 5.4


The APS task Finalizing unprovisioning fails in POA 5.5 with the following error message:

Foreign key 'aps_service_instance_resources_fk0' violation

More detailed diagnostics are provided in the example below:

Task name       APS application 'WordPress', id 120, instance 1487 -> service 'wordpress', instance 1254: Finalizing unprovisioning, site ''
Last execution output   Foreign key 'aps_service_instance_resources_fk0' violation while executing ' DELETE FROM aps_service_instances WHERE service_instance_id = ?'.


There is a defect in the POA APS Controller.


Upgrade POA to 5.5.1 or a later version; the problem is fixed in 5.5.1.

Run the failed task after the upgrade.

Search Words

foreign key violation


Finalizing unprovisioning


5b048d9bddf8048a00aba7e0bdadef37 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e ac82ce33439a9c1feec4ff4f2f638899 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF