Search Engine: Elastic

Article ID: 130279, created on Feb 13, 2017, last review on Feb 13, 2017

  • Applies to:
  • Operations Automation 6.0

Symptoms

pem.removeSubscription OA API method fails with error:

"org.hibernate.exception.ConstraintViolationException: could not execute statement"

The following could be seen in the poa.log:

for MSSQL database:

 Caused by: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "domain_hosting_bindings_fk2". The conflict occurred in database "plesk", table "dbo.domain_hosting_bindings", column 'subscription_id'.

for PostgreSQL database:

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

Cause

Database inconsistency: subscription has linked data, located in several tables, expected to be removed already. A consequence of some canceled tasks in the past.

Resolution

Contact Odin Technical Support to resolve the issue.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF