[
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
