[ART.114.302] Adapter Runtime (Transaction): Error while committing transaction

, ,
1

HI ,

am facing [ART.114.302] error runtime error. i have copied error dump also.
please advise me how to resolve this error.

thanks in advance.

bala

“[ART.114.302] Adapter Runtime (Transaction): Error while committing transaction 299479. The transaction in progress is 299487.com.wm.pkg.art.error.DetailedServiceExceptioncom.wm.pkg.art.error.DetailedServiceException: [ART.114.302] Adapter Runtime (Transaction): Error while committing transaction 299479. The transaction in progress is 299487. at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:122) at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:116) at com.wm.pkg.art.error.DetailedServiceException.create(DetailedServiceException.java:93) at com.wm.pkg.art.transaction.Service.commitTransaction(Service.java:154) at sun.reflect.GeneratedMethodAccessor328.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:443) at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:276) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:363) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:547) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:386) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:234) at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:194) at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324) at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:584) at com.wm.lang.flow.FlowState.step(FlowState.java:444) at com.wm.lang.flow.FlowState.invoke(FlowState.java:409) at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1057) at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:643) at com.wm.app.b2b.server.util.tspace.ReservationProcessor.process(ReservationProcessor.java:46) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:243) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:51) at com.wm.app.b2b.server.invoke.PipelineProcessor.process(PipelineProcessor.java:171) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:276) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:30) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:363) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:547) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:386) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:234) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:109) at com.wm.app.b2b.server.WebServicesProcessImpl._process(WebServicesProcessImpl.java:1160) at com.wm.app.b2b.server.WebServicesProcessImpl.process(WebServicesProcessImpl.java:256) at com.wm.app.b2b.server.HTTPWebServicesHandler.process(HTTPWebServicesHandler.java:11) at com.wm.app.b2b.server.HTTPRootWebServicesHandler.process(HTTPRootWebServicesHandler.java:46) at com.wm.app.b2b.server.HTTPDispatch.handleRequest(HTTPDispatch.java:181) at com.wm.app.b2b.server.Dispatch.run(Dispatch.java:354) at com.wm.util.pool.PooledThread.run(PooledThread.java:131) at java.lang.Thread.run(Thread.java:662)”

2

It looks like you’re trying to commit the outer transaction during the nested one. But this is just my guess. Finding the cause requires more detailed information about the situation in which the error occurred. Please tell me what you want to do, which adapter or adapters you used. Please tell me also something about WM version and installed fixes.

–
lskierkowski
www.bluesoft.net.pl

3

Hi Iskier,

thanks,

 we are using dynamic adapter service and the above posted error not happen frequently. very rar senario. but i need to find the route cast of this problem and fix.

summary : main service am having start commit transaction. am calling subservice in that; sub service having one select adapter service. will it gives problem please advise me.

Adapter connection : JDBC
connection max pool size :25
connection type : local transaction

4

Hi Bala,
As Iskier said, the issue here is you are trying to commit parent transaction before closing child transaction. Try to create wrapper service for handling start commit and rollback for each transactions and use the different variable names to map transaction values.

Regards,
Niteesh

5

Hi,

There are some possible reasons:

  1. Bug in webMethods Transaction Manager - try to install the newest fixes for WmART and so on.
  2. Simple bug in your code - check twice if you use proper transaction id
  3. Bug in jdbc library - try to install the newest one.

The problem occurs rare. Does it occure in special circumstances like heavy load? Maybe it is related with processed data (when you have arrays i.e.) ?

–
lskierkowski
www.bluesoft.net.pl

6

hi Bala,

The possible reason for this is that you are not using the unique transaction id’s for all the transactions that you are starting.
Assign transaction id of each transaction that you start to separate variables and use them across the transaction instead of using the default variable