Concurrent Commit conflicts with IS JDBC adapter

, ,
1

hello ,all
We got error as below:
[ART.114.302] Adapter Runtime (Transaction): Error while committing transaction 6304. The transaction in progress is 6305.
This error only occured when we are doing the stresss testing. We use concurrent thread to test the same service and some works fine. Others got this kind of error.
BTW, we use starttransaction, committransaction and rollback transaction.
I’ve tried using defined and default transaction name. Both got this error.
So how will this error come out?

enviroument configuration:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
HP-UNIX
IS version 6.1
fix: IS_6-1_SP1_Fix21
IS_6-1_SP1
IS_6-1_SP1_SCLP
IS_6-1_FP2

java version 1.4.2.02 (48.0)

jdbc configuration:
Enable Connection Pooling true
Minimum Pool Size 0
Maximum Pool Size 200
Pool Increment Size 1
Block Timeout (msec) 10000
Expire Timeout (msec) 10000
Startup Retry Count 5
Startup Backoff Timeout (sec) 10

Any comments are higyly appreciated.

shenjie

2

BTW, the jdbc adapter version is : 6.0.3
Thanks
Shenjie

3

Hi Shenjie,

is JDBC Adapter bare 6.0.3 or is it 6.0.3 FP1?

As you are already on IS 6.1 SP1, updating to 6.0.3 FP1 can use the new features of ART introduced in 6.1 SP1.

Ask your HP-UX Admins to install a newer version (1.4.2.09 recommended) of the jvm, as there are several known issues inside HP´s JVM affecting notification scheduler for the Adapters. Adjust the JAVA_DIR in server.sh accordingly.

Check for updates for the IS 6.1 SP and FP Fixes. The newest superceding Fix for SP1 Fix21 is SP1 Fix68 (WmFlatFile component).
There are several other fixes marked as “CRITICAL FIX”.
Check for JDBC Adapter Fixes as well as for ART-Fixes, too.

Check with wM Support for details.

Regards,
Holger