Search Engine: Elastic

Article ID: 131110, created on Jul 5, 2017, last review on Jul 5, 2017

  • Applies to:
  • Operations Automation 7.1

Symptoms

Cleanup packages on host task fails:

ERROR [task:7061742:323 Thread-2-(ActiveMQ-client-global-threads-980324746):792 pau]: c.p.p.s.j.a.JobBase task 7061742 completed with exception: 
javax.ejb.EJBException: javax.ejb.EJBTransactionRolledbackException: Transaction rolled back

Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "hosts" violates foreign key constraint "components_fk_0" on table "components"

Detail: Key (host_id)=(90) is still referenced from table "components".

First task attempt failed with:

DBG [task:7061741:222 Thread-19-(ActiveMQ-client-global-threads-980324746):1705 pau]: c.p.p.s.m.e.MessengerBean loading user #259 mail subscriptions
.....
DBG [task:7061741:222 Thread-19-(ActiveMQ-client-global-threads-980324746):1705 pau]: c.p.p.c.ServiceInvoker OperationProcessor invocation failedjavax.ejb.EJBTransactionRolledbackException: javax.ejb.EJBTransactionRolledbackException: Failed to process executeDeinstallSequence for pkgId: 4576, ex message is: Removing a detached instance com.parallels.pa.service.messenger.domain.MailSubscription#com.parallels.pa.service.messenger.domain.MailSubscription$MailSubscriptionPK@5790adea

Also it could be seen in core.log that some of the components have been uninstalled from the corresponding node during the first attempt, but in OA DB all of the components for this node are marked as Not Uninstalled:

Cause

Software-related issue #POA-111936: "task 'Cleanup packages on host' is not retryable".

Resolution

Contact pta@odin.com or TAM to trace the status of the issue.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 8c199f0ee4305da1a577740620df4a51 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF