You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Ashish Vijaywargiya <to...@yahoo.com> on 2006/07/06 17:27:15 UTC
Getting trouble in creating Direct Invoice.
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(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)
1779272 (http-0.0.0.0-8443-Processor2) [ TransactionUtil.java:280:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set.
1779275 (http-0.0.0.0-8443-Processor2) [ ServiceDispatcher.java:412:ERROR] Service Error [createGlAccountOrganization]: ERROR: Could not complete the Create GlAccountOrganization [file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createGlAccountOrganization] process [problem creating the newEntity value: 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)))]
1779277 (http-0.0.0.0-8443-Processor2) [ TransactionUtil.java:243:ERROR] [TransactionUtil.rollback]
java.lang.Exception: Stack Trace
at org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:242)
at org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:224)
at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:416)
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)
1779280 (http-0.0.0.0-8443-Processor2) [ TransactionUtil.java:253:INFO ] [TransactionUtil.rollback] transaction rolled back
1779281 (http-0.0.0.0-8443-Processor2) [ RequestHandler.java:283:ERROR] Request createGlAccountOrganization caused an error with the following message: ERROR: Could not complete the Create GlAccountOrganization [file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createGlAccountOrganization] process [problem creating the newEntity value: 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)))]
1779283 (http-0.0.0.0-8443-Processor2) [ RequestHandler.java:395:INFO ] [RequestHandler.doRequest]: Response is a view.
1779301 (http-0.0.0.0-8443-Processor2) [ RequestHandler.java:547:INFO ] servletName=control, view=EditGlobalGlAccountOrganizations
1779514 (http-0.0.0.0-8443-Processor2) [ UtilXml.java:263:DEBUG] XML Read 0.208s: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/widget/AccountingScreens.xml
1779526 (http-0.0.0.0-8443-Processor2) [ ScreenFactory.java:120:INFO ] Got 12 screens in 0.222s from: file:/ashish/eclipse/ofbiz_workspace/ofbiz/applications/accounting/widget/AccountingScreens.xml
1779528 (http-0.0.0.0-8443-Processor2) [ ControlServlet.java:198:ERROR] Error in request handler:
java.lang.IllegalArgumentException: Could not find screen with name [EditGlobalGlAccountOrganizations] in class resource [component://accounting/widget/AccountingScreens.xml]
at org.ofbiz.widget.screen.ScreenFactory.getScreenFromLocation(ScreenFactory.java:127)
at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:107)
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 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)
1779531 (http-0.0.0.0-8443-Processor2) [ ControlServlet.java:208:ERROR] An error occurred, going to the errorPage: /error/error.jsp
Although i also imported the data folder from financial module.
Please help me as soon as possible.
One more thing.I am able to do the same process successfully in the online Opentaps demo.
Thanks in advance.
Regards
Ashish Vijaywargiya
---------------------------------
Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail Beta.
Re: Getting trouble in creating Direct Invoice.
Posted by Si Chen <si...@opensourcestrategies.com>.
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])