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.