My Oracle Support Banner

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

Last updated on JANUARY 16, 2020

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.4.0]
Information in this document applies to any platform.


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[[ ErrBuf Fields:
Field=UnknownField0 Rec=0 reserved=0
Facility=0 MessageID=0 Time=4:00 AM Version=0 Reserved2=0
Nested Error:

The corresponding cm pinlog shows  below error :

E Tue Jul 6 14:51:59 2010 perf_aparwin1 cm_aia:13502
commit_customer needs own transaction
<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 ?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.