Dev - transaction error when receiving returned product

[Michael Brohl]

Hi everyone,

we currently have a serious problem with one of our production systems. The system is somewhat outdated (last vendor import was just before the project structure changed to applications and framework separation) but cannot be updated at the moment.

The problem occurs when we try to receive returned products:

2005-12-23 10:33:34,024[     RequestHandler.java:199:INFO ] [Processing Request]: receiveReturnedProduct
2005-12-23 10:33:34,131[     AbstractEngine.java:84 :INFO ] Loaded Service Locations : {eedcc-test=http://localhost:8080/webtools/control/httpService, main-http=http://localhost:8080/webtools/control/httpService, entity-sync-http=http://localhost:8080/webtools/control/httpService, rita-rmi=rmi://localhost:1099/RMIDispatcher, entity-sync-rmi=rmi://localhost:1099/RMIDispatcher, main-rmi=rmi://localhost:1099/RMIDispatcher}
2005-12-23 10:33:34,188[  GroupServiceModel.java:110:INFO ] Running grouped service [prepareInventoryReceipt]
2005-12-23 10:33:34,804[  GroupServiceModel.java:110:INFO ] Running grouped service [createInventoryItem]
2005-12-23 10:33:35,207[      EntityEcaRule.java:117:INFO ] Running Entity ECA Service: createInventoryItemCheckSetAtpQoh, triggered by rule on Entity: InventoryItem
2005-12-23 10:33:35,215[  GroupServiceModel.java:110:INFO ] Running grouped service [createInventoryItemDetail]
2005-12-23 10:33:35,234[      EntityEcaRule.java:117:INFO ] Running Entity ECA Service: updateInventoryItemFromDetail, triggered by rule on Entity: InventoryItemDetail
2005-12-23 10:33:35,260[  GroupServiceModel.java:110:INFO ] Running grouped service [createShipmentReceipt]
2005-12-23 10:33:35,311[     ServiceEcaRule.java:122:INFO ] Running Service ECA Service: updateReturnStatusFromReceipt, triggered by rule on Service: createShipmentReceipt
2005-12-23 10:33:35,495[            IfEmpty.java:76 :INFO ] Map not found with name totalsMap, running operations
2005-12-23 10:33:35,529[ServiceEcaCondition.java:105:INFO ] From Field (orderId) is not found in context for createShipmentReceipt, defaulting to null.
2005-12-23 10:33:35,532[  GroupServiceModel.java:110:INFO ] Running grouped service [balanceInventoryItems]
2005-12-23 10:33:35,553[  GroupServiceModel.java:110:INFO ] Running grouped service [prepareInventoryReceipt]
2005-12-23 10:33:35,560[  GroupServiceModel.java:110:INFO ] Running grouped service [createInventoryItem]
2005-12-23 10:33:35,572[      EntityEcaRule.java:117:INFO ] Running Entity ECA Service: createInventoryItemCheckSetAtpQoh, triggered by rule on Entity: InventoryItem
2005-12-23 10:33:35,583[  GroupServiceModel.java:110:INFO ] Running grouped service [createInventoryItemDetail]
2005-12-23 10:33:35,600[      EntityEcaRule.java:117:INFO ] Running Entity ECA Service: updateInventoryItemFromDetail, triggered by rule on Entity: InventoryItemDetail
2005-12-23 10:33:35,627[  GroupServiceModel.java:110:INFO ] Running grouped service [createShipmentReceipt]
2005-12-23 10:33:35,639[     ServiceEcaRule.java:122:INFO ] Running Service ECA Service: updateReturnStatusFromReceipt, triggered by rule on Service: createShipmentReceipt
2005-12-23 10:33:35,655[            IfEmpty.java:76 :INFO ] Map not found with name totalsMap, running operations
2005-12-23 10:33:35,711[     ServiceEcaRule.java:122:INFO ] Running Service ECA Service: processReplacementReturn, triggered by rule on Service: updateReturnStatusFromReceipt
2005-12-23 10:33:35,830[     ServiceEcaRule.java:122:INFO ] Running Service ECA Service: checkReturnComplete, triggered by rule on Service: processReplacementReturn
2005-12-23 10:33:35,860[     ServiceEcaRule.java:122:INFO ] Running Service ECA Service: processCreditReturn, triggered by rule on Service: updateReturnStatusFromReceipt
2005-12-23 10:33:35,883[     ServiceEcaRule.java:122:INFO ] Running Service ECA Service: checkReturnComplete, triggered by rule on Service: processCreditReturn
2005-12-23 10:33:35,908[     ServiceEcaRule.java:122:INFO ] Running Service ECA Service: processRefundReturn, triggered by rule on Service: updateReturnStatusFromReceipt
2005-12-23 10:33:36,105[  ServiceDispatcher.java:390:ERROR] Service Error [refundPayment]: No payment settings found
2005-12-23 10:33:36,119[    TransactionUtil.java:248:INFO ] [TransactionUtil.setRollbackOnly] transaction roll back only set
2005-12-23 10:33:36,141[       SequenceUtil.java:295:WARN ]
---- exception report ----------------------------------------------------------
[SequenceUtil.SequenceBank.fillBank] SQL Exception while executing the following:
UPDATE SEQUENCE_VALUE_ITEM SET SEQ_ID=SEQ_ID+10 WHERE SEQ_NAME='ReturnItemResponse'
Error was:Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)
Exception: java.sql.SQLException
Message: Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)
---- stack trace ---------------------------------------------------------------
java.sql.SQLException: Cannot commit a transactional connection: See JDBC 2.0 Optional Package Specification section 7.1 (p25)
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.commit(XAClientConnection.java:250)
org.ofbiz.entity.util.SequenceUtil$SequenceBank.fillBank(SequenceUtil.java:249)
org.ofbiz.entity.util.SequenceUtil$SequenceBank.<init>(SequenceUtil.java:119)
org.ofbiz.entity.util.SequenceUtil.getNextSeqId(SequenceUtil.java:95)
org.ofbiz.entity.GenericDelegator.getNextSeqIdLong(GenericDelegator.java:2131)
org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2092)
org.ofbiz.entity.GenericDelegator.getNextSeqId(GenericDelegator.java:2082)
org.ofbiz.order.order.OrderServices.processRefundReturn(OrderServices.java:2695)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101)
org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:348)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:97)
org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:123)
org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:160)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:380)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:97)
org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:123)
org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:160)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:380)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214)
org.ofbiz.service.group.GroupServiceModel.invoke(GroupServiceModel.java:121)
org.ofbiz.service.group.GroupModel.runAll(GroupModel.java:155)
org.ofbiz.service.group.GroupModel.run(GroupModel.java:120)
org.ofbiz.service.group.ServiceGroupEngine.runSync(ServiceGroupEngine.java:57)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:348)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
org.ofbiz.content.webapp.event.ServiceMultiEventHandler.invoke(ServiceMultiEventHandler.java:250)
org.ofbiz.content.webapp.control.RequestHandler.runEvent(RequestHandler.java:377)
org.ofbiz.content.webapp.control.RequestHandler.doRequest(RequestHandler.java:239)
org.ofbiz.content.webapp.control.ControlServlet.doGet(ControlServlet.java:186)
org.ofbiz.content.webapp.control.ControlServlet.doPost(ControlServlet.java:85)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
org.ofbiz.content.webapp.control.ContextFilter.doFilter(ContextFilter.java:237)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535)
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
java.lang.Thread.run(Thread.java:534)



It seems that OfBiz is not able to commit the manual transaction in the fillBank method. Since this works fine in all other cases, I assume the error must have something to do with the amount of different services involved. I searched the net and the OfBiz Wiki and tried to increase the SAPDB MAXLOCKS parameter from 8092 to 20000. I also changed the pool size parameter in the entityengine.xml from pool-maxsize="20" to pool-maxsize="50". Both changes didn't help.

Has anyone stumbled over this problem also? Any ideas how to solve this or trach down the cause?

Thanks and regards,

Michael Brohl

Agrenon GmbH a member of Lynx Consulting Group,
Johanniskirchplatz 6, D-33615 Bielefeld, Germany
Tel. [phone], Mobile [phone], Fax.[phone]
E-Mail: [hidden email]
http://www.agrenon.com

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev

[Ray Barlow]

Hi Michael,

 

Looking at the first error message in the list:

.....

2005-12-23 10:33:35,908[     ServiceEcaRule.java:122:INFO ] Running Service ECA

Service: processRefundReturn, triggered by rule on Service: updateReturnStatusFromReceipt
2005-12-23 10:33:36,105[  ServiceDispatcher.java:390:ERROR] Service Error [refundPayment]: No payment settings found
2005-12-23 10:33:36,119[    TransactionUtil.java:248:INFO ] [TransactionUtil.setRollbackOnly] transaction roll back only set
......

 

you have problems with payment settings that has thrown an error causing the transaction to be marked for roll back. Your best bet is to look at the code in and around processRefundReturn and maybe compare it to more recent SVN versions.

 

Ray

 

 

 

 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev