JCA Adapter Throws Error ERR_TRANS_ALREADY_OPEN When Submitting Large Number Of Orders Through AIA (Doc ID 1158514.1)

Last updated on AUGUST 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 04-Apr-2012***
Checked for relevance on 6-Sep-2013.

Goal

In the following integration scenario (using AIA for Comms PIP):

 Siebel CRM --> AIA 2.4 --> BRM 7.4


while doing heavy load testing, below error is encountered in the JCA adapter logs :

2010-07-06T14:52:13.360+03:00] [tip] [ERROR] [] [adapter.brm.BRMOpcodeCaller]
[tid: 931] [ecid: xxx.16.12.174:35724:1278417133345:2361,0] EBufException
exception msg: execOpcode ERR_TRANS_ALREADY_OPEN
[2010-07-06T14:52:13.360+03:00] [tip] [ERROR] [] [adapter.brm.BRMInteraction]
[tid: 931] [ecid: xxx.16.12.174:35724:1278417133345:2361,0] Exception
Occured while execuitng Opcode
[2010-07-06T14:52:13.364+03:00] [tip] [ERROR] [] [adapter.brm.BRMInteraction]
[tid: 931] [ecid: xxx.16.12.174:35724:1278417133345:2361,0] Caught Exception
calling an opcodeDeterminateError - ERR_TRANS_ALREADY_OPEN[[FList.java:0: ErrBuf Fields:
Error=ERR_TRANS_ALREADY_OPEN Loc=FM
Field=UnknownField0 Rec=0 reserved=0
Facility=0 MessageID=0 Time=4:00 AM Version=0 Reserved2=0
Args=<none>
Nested Error:
<none>


The corresponding cm pinlog shows  below error :

E Tue Jul 6 14:51:59 2010 perf_aparwin1 cm_aia:13502
fm_cust_commit_customer.c:6461:perf-amumwin1:UnknownProgramName:0:RMICallHandler-104:63:1278417273:0
commit_customer needs own transaction
<location=PIN_ERRLOC_FM:5 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1
errno=PIN_ERR_TRANS_ALREADY_OPEN:37>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>


Note - the load test constituted about 100 parallel users firing orders from Siebel CRM and other web services, through AIA. So, parallel orders are submitted, including new account creations, payments, adjustments, balance enquiry, etc. Under such load situation, the JCA adapter would throw the ERR_TRANS_ALREADY_OPEN error mostly for the op_cust_commit_customer opcode call and the error snippets are as shown above.

How to resolve this error ?

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