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

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

Symptoms

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 'http://customer.com/'
Last execution output   Foreign key 'aps_service_instance_resources_fk0' violation while executing ' DELETE FROM aps_service_instances WHERE service_instance_id = ?'.

Cause

There is a defect in the POA APS Controller.

Resolution

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

aps_service_instance_resources_fk0

Finalizing unprovisioning

removeApplicationConfiguration

5b048d9bddf8048a00aba7e0bdadef37 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e ac82ce33439a9c1feec4ff4f2f638899 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF