Numerous Errors (ORABPEL-12511; 'TXN_FLAGS' not found in BRM; ERR_TRANS_NOT_OPEN) In AIA While Creating Accounts In BRM 7.3.1 During a Call to PCM_OP_CUST_COMMIT_CUSTOMER Wrapped In a Transaction (Doc ID 1301305.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.
***Checked for relevance on 08-Nov-2012***
Checked for relevance on 21-May-2014
Checked for relevance on 21-Oct-2015

Goal

Question 1:

When trying to create an account with the inputFlist below, got an error :

The Adapter Framework was unable to establish an outbound JCA connection due to the following issue: java.lang.IllegalStateException: New ManagedConnection cannot be created for a thread:260 which is already in BRM transaction; nested exception is:
ORABPEL-12511
Adapter Framework unable to create outbound JCA connection.

Details:
Request :-


<PCM_OP_CUST_COMMIT_CUSTOMER_inputFlist xmlns:brm="http://xmlns.oracle.com/BRM/schemas/BusinessOpcodes" xmlns="http://xmlns.oracle.com/BRM/schemas/BusinessOpcodes">
<brm:ACCTINFO elem="0">
<brm:ACCOUNT_NO>1-7Y2VN</brm:ACCOUNT_NO>
<brm:BUSINESS_TYPE>1</brm:BUSINESS_TYPE>
<brm:CURRENCY>840</brm:CURRENCY>
<brm:POID>0.0.0.1 /account -1 0</brm:POID>
<brm:AAC_ACCESS/>
<brm:AAC_SOURCE>333004682702</brm:AAC_SOURCE>
<brm:AAC_VENDOR>1-7Y2VN</brm:AAC_VENDOR>
<brm:BAL_INFO elem="0"/>
</brm:ACCTINFO>
<brm:BILLINFO elem="0">
<brm:AR_BILLINFO_OBJ>0.0.0.1 /billinfo 16819483 0</brm:AR_BILLINFO_OBJ>
<brm:BILLINFO_ID>34303932333038313835353739373236</brm:BILLINFO_ID>
<brm:PARENT_BILLINFO_OBJ>0.0.0.1 /billinfo 16819483 0</brm:PARENT_BILLINFO_OBJ>
<brm:PAY_TYPE>10007</brm:PAY_TYPE>
<brm:PAYINFO elem="0"/>
<brm:POID>0.0.0.1 /billinfo -1 0</brm:POID>
<brm:BAL_INFO elem="0"/>
</brm:BILLINFO>
<brm:FLAGS>0</brm:FLAGS>
<brm:GROUP_INFO>
<brm:PARENT>0.0.0.1 /account 16821787 0</brm:PARENT>
</brm:GROUP_INFO>
<brm:NAMEINFO elem="1">
<brm:ADDRESS>1409 FRENCH ST</brm:ADDRESS>
<brm:CITY>CASA GRANDE</brm:CITY>
<brm:COUNTRY>USA</brm:COUNTRY>
<brm:EMAIL_ADDR>abc@siebel.com</brm:EMAIL_ADDR>
<brm:FIRST_NAME>CRP Test1</brm:FIRST_NAME>
<brm:LAST_NAME>.</brm:LAST_NAME>
<brm:STATE>AZ</brm:STATE>
<brm:ZIP>85222-2366</brm:ZIP>
</brm:NAMEINFO>
<brm:PAYINFO elem="0">
<brm:PAY_TYPE>10007</brm:PAY_TYPE>
<brm:POID>0.0.0.1 /payinfo/subord -1 0</brm:POID>
</brm:PAYINFO>
<brm:POID>0.0.0.1 /plan -1 0</brm:POID>
<brm:TXN_FLAGS>2</brm:TXN_FLAGS>
<brm:BAL_INFO elem="0">
<brm:NAME>Default Balance Group</brm:NAME>
<brm:POID>0.0.0.1 /balance_group -1 0</brm:POID>
<brm:BILLINFO elem="0"/>
<brm:LIMIT elem="840">
<brm:CREDIT_LIMIT/>
</brm:LIMIT>
</brm:BAL_INFO>
</PCM_OP_CUST_COMMIT_CUSTOMER_inputFlist>



Response :-


<bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="code"><code>null</code>
</part><part name="summary"><summary>file:/aiaapp/oracle/product/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_CreateCustomerPartyPortalProvABCSImpl_BRMConnectivity.0_09a5c6aa71a9050e0c57f274d0a2237d.tmp/BRMCUSTServiceRef.wsdl [ BRMCUSTService_ptt::PCM_OP_CUST_COMMIT_CUSTOMER(PCM_OP_CUST_COMMIT_CUSTOMER_inputFlist,PCM_OP_CUST_COMMIT_CUSTOMER_outputFlist) ] - WSIF JCA Execute of operation 'PCM_OP_CUST_COMMIT_CUSTOMER' failed due to: Adapter Framework unable to create outbound JCA connection.
file:/aiaapp/oracle/product/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_CreateCustomerPartyPortalProvABCSImpl_BRMConnectivity.0_09a5c6aa71a9050e0c57f274d0a2237d.tmp/BRMCUSTServiceRef.wsdl [ BRMCUSTService_ptt::PCM_OP_CUST_COMMIT_CUSTOMER(PCM_OP_CUST_COMMIT_CUSTOMER_inputFlist,PCM_OP_CUST_COMMIT_CUSTOMER_outputFlist) ] - : The Adapter Framework was unable to establish an outbound JCA connection due to the following issue: java.lang.IllegalStateException: New ManagedConnection cannot be created for a thread:260 which is already in BRM transaction; nested exception is:
ORABPEL-12511
Adapter Framework unable to create outbound JCA connection
.
file:/aiaapp/oracle/product/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_CreateCustomerPartyPortalProvABCSImpl_BRMConnectivity.0_09a5c6aa71a9050e0c57f274d0a2237d.tmp/BRMCUSTServiceRef.wsdl [ BRMCUSTService_ptt::PCM_OP_CUST_COMMIT_CUSTOMER(PCM_OP_CUST_COMMIT_CUSTOMER_inputFlist,PCM_OP_CUST_COMMIT_CUSTOMER_outputFlist) ] - : The Adapter Framework was unable to establish an outbound JCA connection due to the following issue: java.lang.IllegalStateException: New ManagedConnection cannot be created for a thread:260 which is already in BRM transaction
Please examine the log file for any reasons. Enable DEBUG logging in the BPEL Console.
</summary>
</part><part name="detail"><detail>null</detail>
</part></bindingFault>



How to resolve this issue?

Question 2:

A user
1) installed <patch 10280482> on 7.3.1, and
2) implemented a call to PCM_OP_CUST_COMMIT_CUSTOMER in AIA with a global transaction flag (TXN_FLAGS=2) , i.e, the call was wrapped in a transaction with call flow: 
          PCM_OP_TRANS_OPEN
          PCM_OP_CUST_COMMIT_CUSTOMER
          PCM_OP_TRANS_COMMIT

He/she is getting an error when trying to make the call:

<bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>file:/aiaapp/oracle/product/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_CreateCustomerPartyPortalProvABCSImpl_BRMConnectivity.1_7a5cdeed9aaf8ebd262b90ecd974e6b6.tmp/BRMCUSTServiceRef.wsdl [
BRMCUSTService_ptt::PCM_OP_CUST_COMMIT_CUSTOMER(PCM_OP_CUST_COMMIT_CUSTOMER_inputFlist,PCM_OP_CUST_COMMIT_CUSTOMER_outputFlist) ] - WSIF JCA Execute of
operation 'PCM_OP_CUST_COMMIT_CUSTOMER' failed due to:
org.xml.sax.SAXParseException: field 'TXN_FLAGS' not found in BRM; nested
exception is:
javax.resource.ResourceException: org.xml.sax.SAXParseException: field
'TXN_FLAGS' not found in BRM</summary>
</part><part name="detail"><detail>javax.resource.ResourceException:
org.xml.sax.SAXParseException: field 'TXN_FLAGS' not found in BRM</detail>
</part></bindingFault>


However, using the same flist from BRM testnap, the account can be created.
BRM JCA adapter from the patch has been deployed to application server.

What could be wrong?

Question 3:

After resolving the issue in Question 2 (pcm.jar and pcmext.jar files from the patch are copied to application server), the user made some progress:

• PCM_OP_TRANS_OPEN has been called successfully
• PCM_OP_CUST_COMMIT_CUSTOMER has been called successfully with TXN_FLAGS = 2
• PCM_OP_TRANS_COMMIT has failed with error ERR_TRANS_NOT_OPEN

The error shows:

<bindingFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>file:/aiaapp/oracle/product/10.1.3.1/OracleAS_1/bpel/domains/default/tmp/.bpel_CreateCustomerPartyPortalProvABCSImpl_BRMConnectivity.1_7a5cdeed9aaf8ebd262b90ecd974e6b6.tmp/BRMTXNServiceRef.wsdl [
BRMTXNService_ptt::PCM_OP_TRANS_OPEN(PCM_OP_TRANS_OPEN_inputFlist,PCM_OP_TRANS_OPEN_outputFlist) ] - WSIF JCA Execute of operation 'PCM_OP_TRANS_COMMIT'
failed due to: Caught Exception calling an opcode, error code: Location=PCP
ErrMsg=ERR_TRANS_NOT_OPEN ErrStr=ERR_TRANS_NOT_OPEN Field=UnknownField0
RecID=0; nested exception is:
javax.resource.spi.EISSystemException: Caught Exception
calling an opcode, error code: Location=PCP ErrMsg=ERR_TRANS_NOT_OPEN
ErrStr=ERR_TRANS_NOT_OPEN Field=UnknownField0 RecID=0</summary>
</part><part name="detail"><detail>javax.resource.spi.EISSystemException:
Caught Exception calling an opcode, error code: Location=PCP
ErrMsg=ERR_TRANS_NOT_OPEN ErrStr=ERR_TRANS_NOT_OPEN Field=UnknownField0
RecID=0</detail>
</part></bindingFault>


How to resolve this issue?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms