Search Engine: Elastic

Article ID: 130397, created on Mar 8, 2017, last review on Mar 8, 2017

  • Applies to:
  • Operations Automation 6.0

Symptoms

It is not possible to "Unsubscribe" a subscription in Operations Automation or "Delete" a domain due to the following error:

javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

The following error message can be found in poa.log on the Management Node:

Sep 22 12:34:56 osscore : Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "subscriptions" violates foreign key constraint "domain_hosting_bindings_fk2" on table "domain_hosting_bindings"   Detail: Key (sub_id)=(1234567) is still referenced from table "domain_hosting_bindings".

Cause

Subscription and/or domain removal procedure fails in the circumstances when there are invalid records in `domain_hosting_bindings' table. The issue is caused by program code defect #POA-101582.

Resolution

The fix is planned to be included in one of future product updates.

Please contact Odin Technical Support in order to complete the problematic subscription/domain.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF