Search Engine: Elastic

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

  • Applies to:
  • Operations Automation 7.0
  • Operations Automation 7.1
  • Operations Automation 6.0

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 0871c0b47b3b86ae3b1af4c2942cd0ce 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF