Article ID: 128049, created on Jan 13, 2016, last review on Jan 13, 2016

  • Applies to:
  • Operations Automation

Symptoms

Cancellation order fails with the following error:

"Provisioning for the Order #123456 is not completed. Provisioning on the Operations Automation side is in progress. Switch to "Operations" and check the tasks in queue."

The following error appear in poa.log:

Jun 12 16:12:47 mn.company.com : DBG [openapi:10.1.2.3:26553 RequestProcessor-4601 pau ]: com.parallels.pa.service.db.ejb.DBServiceBean Executing update: ' DELETE FROM aps_service_instance_resources WHERE service_instance_id =  ? AND (resource_type =  ? OR resource_type =  ? )'
Parameters: [2056, dns.record, dns.record.substituted] [sqlpid: -1]
Jun 12 16:12:47 mn.company.com : DBG [openapi:10.1.2.3:26553 RequestProcessor-4601 pau ]: com.parallels.pa.service.db.DbServiceInvocationExceptionConverter Failure in DBServicejavax.ejb.EJBTransactionRolledbackException: Could not open connection at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:162) ~[jboss-as-ejb3-7.3.0.Final-redhat-14.jar!/:7.3.0.Final-redhat-14] at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:252) ~[jboss-as-ejb3-7.3.0.Final-redhat-14.jar!/:7.3.0.Final-redhat-14]

Cause

The cause is software related issue:

APS-25775: "Cannot remove subscription with SpamExperts and Exchange - Resource for record NNN is not found".

Additionally, related to APS-28478: "exception on substituted DNS record activation because record was already removed".

Resolution

To prevent the issue re-occurence please consider to install the following Operations Automation update: "6.0.5 HOTFIX 127043 APS v4" or OA version higher then 6.0.5

The w\a for this software-related issue is to manually remove the substituted record from OA database, and re-process the order. Please, contact Odin Technical Support.

Search Words

Cancellation order fails

com.parallels.pa.service.db.ejb.DBServiceBean Executing update

Could not open connection at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx

Provisioning on the Operations Automation side is in progress

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF