Article ID: 126996, created on Sep 25, 2015, last review on Sep 25, 2015

  • Applies to:
  • Operations Automation 6.0

Symptoms

Update named task fails with the following output:

Update named ns1.provider.ru(1)
Last execution output   
org.hibernate.exception.ConstraintViolationException: could not execute statement

In the logs of failed tasks one may find the following entries:

Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "domains" violates foreign key constraint "domain_hosting_bindings_fk3" on table "domain_hosting_bindings"
Detail: Key (domain_id)=(741) is still referenced from table "domain_hosting_bindings".

domain_id=741 - is the cause of this task failure. It could be checked in OA PCP by searching the domain with this ID.

Cause

This is caused by POA-92638 and APS-21892

Resolution

The aforementioned issues were fixed in OA 6.0.4

Search Words

VPS's doens't created

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

ERROR: update or delete on table "domains" violates foreign key constraint "domain_hosting_bindings_fk3" on table "domain_hosting_bindings"

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF