Hi,
I have taken latest ofbiz update from Apache SVN :418742. I also taken update of financial component in hot-deploy directory. And apply the patch regarding to base directory place change in build.xml file as David described before three or four days. I am getting trouble in creating direct invoice from accounting component and capturing payment for this invoice.I also imported the data folder of financial module from Webtools import module. Now Let's see where i am getting error (Here i am creating direct invoice for particular product ):- 1) Go to Accounting-->Invoice 2) Click on Create New Invoices button. 3) From here i created Sales invoice.And it is working fine for me. 4) Next i added items to this invoice. 5) Also defined roles for this invoice. 6) Now when i click on "Status To Ready" button i am getting following error. The Following Errors Occurred: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Commit transaction failed) And log message for this error is : 1380177 (http-0.0.0.0-8443-Processor4) [ UtilXml.java:263:DEBUG] XML Read 0.066s: file:/ashish/eclipse/ofbiz_workspace/ofbiz/framework/common/script/org/ofbiz/common/period/PeriodServices.xml 1380198 (http-0.0.0.0-8443-Processor4) [ SimpleMethod.java:778:INFO ] The env-to-field operation has been deprecated in favor of the set operation; found use of this in [Create a CustomTimePeriod [file:/ashish/eclipse/ofbiz_workspace/ofbiz/framework/common/script/org/ofbiz/common/period/PeriodServices.xml#createCustomTimePeriod]]: <env-to-field env-name="customTimePeriodId" field-name="customTimePeriodId" map-name="newEntity"/> 1380202 (http-0.0.0.0-8443-Processor4) [ SimpleMethod.java:774:INFO ] The env-to-env operation has been deprecated in favor of the set operation; found use of this in [Find a CustomTimePeriod [file:/ashish/eclipse/ofbiz_workspace/ofbiz/framework/common/script/org/ofbiz/common/period/PeriodServices.xml#findCustomTimePeriods]]: <env-to-env env-name="parameters.organizationPartyId" to-env-name="getParentOrganizationsCallMap.organizationPartyId"/> 1380279 (http-0.0.0.0-8443-Processor4) [ UtilXml.java:263:DEBUG] XML Read 0.074s: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/party/script/org/ofbiz/party/party/PartyServices.xml 1380472 (http-0.0.0.0-8443-Processor4) [ TransactionUtil.java:276:WARN ] [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception at org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:276) at org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:226) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:697) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:109) at org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:135) at org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:173) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:373) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at com.opensourcestrategies.financials.ledger.LedgerServices.postInvoiceToGl(LedgerServices.java:201) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101) at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:109) at org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:135) at org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:173) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:373) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) 1380484 (http-0.0.0.0-8443-Processor4) [ ServiceDispatcher.java:412:ERROR] Service Error [postAcctgTrans]: Could not find a CustomTimePeriod (fiscal period) for the Transaction Date [2006-07-06 20:46:22.0] (is for Organization Party with ID [Company]), Could not find a CustomTimePeriod (fiscal period) for the Transaction Date [2006-07-06 20:46:22.0] (is for Organization Party with ID [Company]) 1380521 (http-0.0.0.0-8443-Processor4) [ TransactionUtil.java:280:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. java.lang.Exception: Stack trace at java.lang.Thread.dumpStack(Thread.java:1064) at org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:194) at org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:423) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) 1380537 (http-0.0.0.0-8443-Processor4) [ ServiceDispatcher.java:425:ERROR] Could not commit transaction org.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead (null) at org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:196) at org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:423) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) javax.transaction.RollbackException at org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(GeronimoTransactionManager.java:82) at org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:181) at org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:423) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) 1380541 (http-0.0.0.0-8443-Processor4) [ServiceEventHandler.java:317:ERROR] Service invocation error org.ofbiz.service.GenericServiceException: Commit transaction failed at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:426) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) 1380545 (http-0.0.0.0-8443-Processor4) [ RequestHandler.java:283:ERROR] Request setInvoiceStatus caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Commit transaction failed) 1380546 (http-0.0.0.0-8443-Processor4) [ RequestHandler.java:395:INFO ] [RequestHandler.doRequest]: Response is a view. 1380547 (http-0.0.0.0-8443-Processor4) [ RequestHandler.java:547:INFO ] servletName=control, view=invoiceOverview 1380577 (http-0.0.0.0-8443-Processor4) [ UtilXml.java:263:DEBUG] XML Read 0.027s: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/widget/InvoiceScreens.xml 1380584 (http-0.0.0.0-8443-Processor4) [ ScreenFactory.java:120:INFO ] Got 9 screens in 0.034s from: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/widget/InvoiceScreens.xml 1380586 (http-0.0.0.0-8443-Processor4) [ TransactionUtil.java:530:WARN ] WARNING: In setTransactionBeginStack a stack placeholder was already in place, here is where the transaction began: java.lang.Exception: Tx Stack Placeholder at org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:524) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:280) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) 1380588 (http-0.0.0.0-8443-Processor4) [ TransactionUtil.java:532:WARN ] WARNING: In setTransactionBeginStack a stack placeholder was already in place, here is the current location: java.lang.Exception: Current Stack Trace at org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:531) at org.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:525) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:57) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:130) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:108) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:93) at org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:77) at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:612) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:397) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) 1380874 (http-0.0.0.0-8443-Processor4) [ UtilXml.java:263:DEBUG] XML Read 0.065s: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/widget/CommonScreens.xml 1380892 (http-0.0.0.0-8443-Processor4) [ ScreenFactory.java:120:INFO ] Got 10 screens in 0.084s from: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/widget/CommonScreens.xml 1381366 (http-0.0.0.0-8443-Processor4) [ UtilXml.java:263:DEBUG] XML Read 0.089s: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/widget/Menus.xml 1381396 (http-0.0.0.0-8443-Processor4) [FlexibleStringExpander.java:357:WARN ] Could not find value in environment for the name [], inserting nothing. 1381620 (http-0.0.0.0-8443-Processor4) [ UtilXml.java:263:DEBUG] XML Read 0.18s: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/webapp/accounting/invoice/InvoiceForms.xml 1381690 (http-0.0.0.0-8443-Processor4) [ FieldToResult.java:75 :WARN ] Field value not found with name person.middleName in Map with name 1381692 (http-0.0.0.0-8443-Processor4) [ FieldToResult.java:75 :WARN ] Field value not found with name person.personalTitle in Map with name 1381694 (http-0.0.0.0-8443-Processor4) [ FieldToResult.java:75 :WARN ] Field value not found with name person.suffix in Map with name 1381731 (http-0.0.0.0-8443-Processor4) [FlexibleStringExpander.java:260:WARN ] BSH scriplet evaluated to null [if(invoice.get("dueDate")!=null)return(invoice.getString("dueDate").substring(0,10));], got no return so inserting nothing. 1381743 (http-0.0.0.0-8443-Processor4) [FlexibleStringExpander.java:260:WARN ] BSH scriplet evaluated to null [if(invoice.get("paidDate")!=null)return(invoice.getString("paidDate").substring(0,10));], got no return so inserting nothing. 1381775 (http-0.0.0.0-8443-Processor4) [ ModelForm.java:1098:INFO ] No object for list or iterator name:invoiceApplications found. 1381886 (http-0.0.0.0-8443-Processor4) [ HtmlFormRenderer.java:1909:WARN ] TargetService is empty. 7) And when i click on "Status to Sent" button then it is working fine and when i collect payment for this invoice and click on the Status to Recieved then it is giving me the following error : The Following Errors Occurred: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service Error [getPaymentAccountAndParties]: No GL Account found for Payment with paymentId 10000) And the log message for this is : 1778865 (http-0.0.0.0-8443-Processor2) [ RequestHandler.java:212:INFO ] [Processing Request]: createGlAccountOrganization 1778952 (http-0.0.0.0-8443-Processor2) [ UtilXml.java:263:DEBUG] XML Read 0.081s: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml 1779148 (http-0.0.0.0-8443-Processor2) [ GenericDelegator.java:588:ERROR] Failure in create operation for entity [GlAccountOrganization]: org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:GlAccountOrganization][createdStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][createdTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][glAccountId,120000(java.lang.String)][lastUpdatedStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)] (while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][createdTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][glAccountId,120000(java.lang.String)][lastUpdatedStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)] (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '120000-Company' for key 1))). Rolling back transaction. org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:GlAccountOrganization][createdStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][createdTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][glAccountId,120000(java.lang.String)][lastUpdatedStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)] (while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][createdTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][glAccountId,120000(java.lang.String)][lastUpdatedStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)] (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '120000-Company' for key 1))) at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:130) at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][createdTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][glAccountId,120000(java.lang.String)][lastUpdatedStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)] (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '120000-Company' for key 1)) at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:185) at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127) at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '120000-Company' for key 1) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439) at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180) at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127) at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) java.sql.SQLException: Duplicate entry '120000-Company' for key 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1085) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:670) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1159) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061) at org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:436) at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180) at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127) at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) 1779217 (http-0.0.0.0-8443-Processor2) [ TransactionUtil.java:276:WARN ] [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: java.lang.Exception at org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:276) at org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:226) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:591) at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) 1779221 (http-0.0.0.0-8443-Processor2) [ CreateValue.java:75 :ERROR] org.ofbiz.entity.GenericEntityException: Exception while inserting the following entity: [GenericEntity:GlAccountOrganization][createdStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][createdTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][glAccountId,120000(java.lang.String)][lastUpdatedStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)] (while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][createdTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][glAccountId,120000(java.lang.String)][lastUpdatedStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)] (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '120000-Company' for key 1))) at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:130) at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][createdTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][glAccountId,120000(java.lang.String)][lastUpdatedStamp,2006-07-06 20:53:01.375(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-06 20:53:01.229(java.sql.Timestamp)][organizationPartyId,Company(java.lang.String)] (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '120000-Company' for key 1)) at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:185) at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127) at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, POSTED_BALANCE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry '120000-Company' for key 1) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:439) at org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:180) at org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:127) at org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75) at org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:570) at org.ofbiz.minilang.method.entityops.CreateValue.exec(CreateValue.java:73) at org.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:928) at org.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:568) at org.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:115) at org.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:97) at org.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:86) at org.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:61) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:340) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:214) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:123) at org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:301) at org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:416) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:252) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:191) at org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) at javax.servlet.http.HttpServlet.service(HttpServlet.java:615) at javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:258) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:534) java.sql.SQLException: Duplicate entry '120000-Company' for key 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1085) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:670) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1159) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061) at org.ofbiz.minerva.pool.jdbc.PreparedStatementInPool.executeUpdate(PreparedStatementInPool.java:82) at org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLPr |
This is significant. You need to define time periods for your
organization so the postAcctgTrans knows which time period to post your invoice in. 1380484 (http-0.0.0.0-8443-Processor4) [ ServiceDispatcher.java: 412:ERROR] Service Error [postAcctgTrans]: Could not find a CustomTimePeriod (fiscal period) for the Transaction Date [2006-07-06 20:46:22.0] (is for Organization Party with ID [Company]), Could not find a CustomTimePeriod (fiscal period) for the Transaction Date [2006-07-06 20:46:22.0] (is for Organization Party with ID [Company]) On Jul 6, 2006, at 8:27 AM, Ashish Vijaywargiya wrote: > 1380484 (http-0.0.0.0-8443-Processor4) [ ServiceDispatcher.java: > 412:ERROR] Service Error [postAcctgTrans]: Could not find a > CustomTimePeriod (fiscal period) for the Transaction Date > [2006-07-06 20:46:22.0] (is for Organization Party with ID > [Company]), Could not find a CustomTimePeriod (fiscal period) for > the Transaction Date [2006-07-06 20:46:22.0] (is for Organization > Party with ID [Company]) |
Free forum by Nabble | Edit this page |