Search Engine: Elastic

Article ID: 131116, created on Jul 8, 2017, last review on Aug 16, 2017

  • Applies to:
  • Operations Automation 7.0
  • Operations Automation 6.0

Symptoms

On attempt to destroy subscription, the following error appears:

Destroying service of Subscription #1001 failed: Parallels Operations Automation error #extype_id #1, module_id #Subscriptions, org.hibernate.exception.ConstraintViolationException: could not execute statement.

The following error can be found in /var/log/poa.log on Management Node for versions earlier than 7.0 and in /var/log/pa/core.log since OA 7.0:

Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "subscriptions" violates foreign key constraint "domain_services_fk_1" on table "domain_services"
Detail: Key (sub_id)=(1001) is still referenced from table "domain_services".

Cause

Domain service reference has not been removed from OA database due to canceled tasks in the past.

Resolution

Contact Odin Technical Support in order to find and fix affected DB records.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF