Article ID: 129273, created on Aug 19, 2016, last review on Aug 19, 2016

  • Applies to:
  • Operations Automation 6.0

Symptoms

Attempt to remove a domain via API fails with the following error:

com.parallels.pa.corba.ServiceInvoker AuthenticationManager invocation failedjavax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.ConstraintViolationException: could not execute statement 

Similar message is shown in OA main system log:

Mar 30 11:22:11 osscore : DBG [UI:9a256a22:50604873:1459329720463 RequestProcessor-352300 pau ]: com.parallels.pa.corba.ServiceInvoker AuthenticationManager invocation failedjavax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.ConstraintViolationException: could not execute statement#012#011at 

Cause

The domain has a service user that is bound to a disabled subscription:

select * from users where domain_id =1234567;
-[ RECORD 1 ]-----------+---------------------
user_id                 | 1231231
....
sub_id                  | 12345
domain_id               | 1234567
dns_path_of_domain_part | tld.domain
locked_by               |
deleting                | n

select is_active from subscriptions where sub_id = 12345;
is_active
-----------
        0

Resolution

Remove this service user, then try to remove the domain again.

You might need to re-enable the subscription in order to remove the service user, the pem.enableSubscription API method can be used to do it. After the user is removed, subscription can be disabled again using the pem.disableSubscription API method.

Search Words

AuthenticationManager

could not execute statement

Trying to remove domain from OSA, results in error

Odin API (pem.removeDomain): Unknown Error

pem.removedomain

remove domain

API remove domain

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF