We recently upgraded our Integration Server to IS_6-0-1_SP1 and started
to use the WmART.pub.art.transaction package, since the WmDB.pub.db is
deprecated. We encountered several problems:
- Other adapter service (SelectSQL) frequently get the following error:
[ART.117.4036] Adapter Runtime (Adapter Service): Unable to rollback
transaction. Transaction state:Transaction is marked for rollback .
- After a while, Other adapter service (SelectSQL) get the following
error:
[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter
service. Error occured when connecting to resource database.jdbc:atcODF.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection
to resource database.jdbc:atcODF. The pool doesn’t have a connection
available for the request.
- If we call an adapter service (SelectSQL) before the startTransaction,
we get the following error:
[ART.117.4000] Adapter Runtime (Adapter Service): Unable to invoke
adapter service database.adapterServices.vendor:insertUpdateVendor.
Unable to establish connection to connection database.jdbc:atcODF.
[ART.117.4011] 4011
- If we use the Developer to trace the flow service that contains the
transaction, we get the following error:
An error occurred while tracing.
com.wm.app.b2b.client.ns.NSRuntimeException
The test flow service we use has the follow steps:
-> startTransaction (WmART.pub.art.transaction:startTransaction)
-> getWmUserId (an adapter service, SelectSQL)
-> insertUpdateVendor (an adapter service, Stored Procedure)
-> commitTransaction (WmART.pub.art.transaction:commitTransaction)
or
-> rollbackTransaction (WmART.pub.art.transaction:rollbackTransaction)
Any suggestions or workarounds?
Thanks,