You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Scott Gray (JIRA)" <ji...@apache.org> on 2011/05/11 00:59:47 UTC
[jira] [Closed] (OFBIZ-4241) Custom Time Period Issue
[ https://issues.apache.org/jira/browse/OFBIZ-4241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Scott Gray closed OFBIZ-4241.
-----------------------------
Resolution: Invalid
Assignee: Scott Gray
This appears to be an opentaps specific issue, the code causing the memory error is part of an opensourcestrategies package.
It looks like they're retrieving the entire list of transactions instead of iterating over them with a cursor.
> Custom Time Period Issue
> ------------------------
>
> Key: OFBIZ-4241
> URL: https://issues.apache.org/jira/browse/OFBIZ-4241
> Project: OFBiz
> Issue Type: Bug
> Components: accounting
> Affects Versions: Release 4.0
> Reporter: Moahmed Ahmed Sabra
> Assignee: Scott Gray
> Priority: Critical
>
> Dear OFBIZ Developer,
> I Have this problem . first i have OFBIZ version 4.0 on mysql 5.0 the company worked on it from 2008 the "acctg_trans" table have more than 1000,000 million record you can imagine what in "acctg_trans_entry" more than 3000000 million entry.OK this is what happened when i tried within last week in 2/04/2011 to close 2008 time period but every time tried to close it this exception generated on the GUI:
> (by the way my JVM Worked on{ java -Xmx6144m -Xms6144m -jar ofbiz.jar}
> The Following Errors Occurred:
> * Error calling event: org.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [closeAllTimePeriods] call: Roll back error, could not commit transaction, was rolled back instead because of: Service [getAcctgTransAndEntriesByType] threw an unexpected exception/errororg.ofbiz.service.GenericServiceException: Service target threw an unexpected exception (Java heap space) (Service target threw an unexpected exception (Java heap space)))
> AND this error on console
> EntityListIterator Not Closed for Entity [AcctgTransAndEntries], caught in Finalize
> ====================================================================
> 2011-04-03 11:09:30,344 (http-0.0.0.0-8081-Processor2) [ ServiceDispatcher.java:417:DEBUG] [[Sync s
> ervice failed...- total:0.0010,since last(Begin):0.0010]] - 'financials / getAcctgTransAndEntriesByT
> ype'
> 2011-04-03 11:09:30,344 (http-0.0.0.0-8081-Processor4) [ ControlServlet.java:93 :INFO ] The char
> acter encoding of the request is: [null]. The character encoding we will use for the request and res
> ponse is: [UTF-8]
> 2011-04-03 11:09:30,347 (http-0.0.0.0-8081-Processor4) [ ControlServlet.java:129:DEBUG] [[[getNe
> wInternalMessagesJSON] Servlet Starting, doing setup- total:0.0,since last(Begin):0.0]]
> 2011-04-03 11:09:30,347 (http-0.0.0.0-8081-Processor4) [ ControlServlet.java:184:DEBUG] [[[getNe
> wInternalMessagesJSON] Setup done, doing Event(s) and View(s)- total:0.0,since last([getNewInternalM
> e...):0.0]]
> 2011-04-03 11:09:30,347 (http-0.0.0.0-8081-Processor2) [ ServiceDispatcher.java:420:ERROR]
> ---- exception report ----------------------------------------------------------
> Service [getAcctgTransAndEntriesByType] threw an unexpected exception/error
> Exception: org.ofbiz.service.GenericServiceException
> Message: Service target threw an unexpected exception (Java heap space)
> ---- stack trace ---------------------------------------------------------------
> org.ofbiz.service.GenericServiceException: Service target threw an unexpected exception (Java heap s
> pace)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:106)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:349)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> com.opensourcestrategies.financials.financials.FinancialServices.getIncomeStatementAccountSumsByDate
> (FinancialServices.java:634)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:94)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:349)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> com.opensourcestrategies.financials.ledger.LedgerServices.resetOrgGlAccountBalances(LedgerServices.j
> ava:2892)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:94)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:349)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:113)
> org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:141)
> org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:158)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:404)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:310)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:448)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:277)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:192)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProt
> ocol.java:664)
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> java.lang.Thread.run(Unknown Source)
> java.lang.OutOfMemoryError: Java heap space
> javolution.util.FastMap$1.create(Unknown Source)
> javolution.realtime.ObjectFactory.newObject(Unknown Source)
> javolution.realtime.RealtimeObject$Factory.object(Unknown Source)
> javolution.util.FastMap.newInstance(Unknown Source)
> org.ofbiz.entity.GenericValue.copyOriginalDbValues(GenericValue.java:151)
> org.ofbiz.entity.GenericValue.synchronizedWithDatasource(GenericValue.java:111)
> org.ofbiz.entity.util.EntityListIterator.currentGenericValue(EntityListIterator.java:152)
> org.ofbiz.entity.util.EntityListIterator.next(EntityListIterator.java:290)
> org.ofbiz.entity.util.EntityListIterator.getCompleteList(EntityListIterator.java:404)
> org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1709)
> org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1686)
> com.opensourcestrategies.financials.financials.FinancialServices.getAcctgTransAndEntriesByType(Finan
> cialServices.java:599)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:94)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:349)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> com.opensourcestrategies.financials.financials.FinancialServices.getIncomeStatementAccountSumsByDate
> (FinancialServices.java:634)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:94)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:349)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> com.opensourcestrategies.financials.ledger.LedgerServices.resetOrgGlAccountBalances(LedgerServices.j
> ava:2892)
> --------------------------------------------------------------------------------
> 2011-04-03 11:09:30,365 (http-0.0.0.0-8081-Processor3) [ UtilXml.java:246:DEBUG] XML Read
> 35.91s: file:/F:/spin_work/spin103_mdn_new/hot-deploy/opentaps-common/webapp/common/WEB-INF/common-
> controller.xml
> 2011-04-03 11:09:30,368 (http-0.0.0.0-8081-Processor2) [ TransactionUtil.java:294:WARN ]
> ---- exception report ----------------------------------------------------------
> [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where
> this is happening:
> Exception: java.lang.Exception
> Message: Service [getAcctgTransAndEntriesByType] threw an unexpected exception/error
> ---- stack trace ---------------------------------------------------------------
> java.lang.Exception: Service [getAcctgTransAndEntriesByType] threw an unexpected exception/error
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:294)
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:241)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:423)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> com.opensourcestrategies.financials.financials.FinancialServices.getIncomeStatementAccountSumsByDate
> (FinancialServices.java:634)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:94)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:349)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> com.opensourcestrategies.financials.ledger.LedgerServices.resetOrgGlAccountBalances(LedgerServices.j
> ava:2892)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:94)
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:349)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> org.ofbiz.service.eca.ServiceEcaAction.runAction(ServiceEcaAction.java:113)
> org.ofbiz.service.eca.ServiceEcaRule.eval(ServiceEcaRule.java:141)
> org.ofbiz.service.eca.ServiceEcaUtil.evalRules(ServiceEcaUtil.java:158)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:404)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:216)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:152)
> org.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:310)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:448)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:277)
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:192)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:251)
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProt
> ocol.java:664)
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> java.lang.Thread.run(Unknown Source)
> --------------------------------------------------------------------------------
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira