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
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
