Hello All
This weekend I wanted to upgrade our production database from version 2.1.6 to version 2.3.0
As a start I had to switch from tomcat 6 to jetty 7.3
The upgrade process went smoothly, didn’t find any errors, until I got the reporting part
We use BIRT for our field reports, and I found out that BIRT doesn’t work well inside JETTY for some reason.
As soon as an employee runs a BIRT report inside JETTY the whole system drains out, no one can browse anything until that report finishes the querying.
It’s like everyone has to wait until one report finishes to continue working
There isn’t any RAM issues, not permgem issues, I even upgraded our mysql and JAVA to 64 bits, thinking that might be the problem
But no success
I checked the logs, I found that maybe 2 or 3 of the reports generated errors when launched, the others don’t generate anything they just run successfully but still drains Jetty out
BTW all reports display the results in the end, the problem is that jetty get slow to a level where everyone has to wait
Anyone tested something like that?
Any help would be good, since this problem is not allowing us to upgrade to version 2.3
PS:I included below the log I found when I ran the overdue report
Thank you all
==> user-directive include_page [on line 21, column 1 in clientsAndAccounts.ftl]
----------
Java backtrace for programmers:
----------
freemarker.template.TemplateException: javax.servlet.ServletException: javax.servlet.jsp.JspException: ServletException in '/pages/framework/jsp/mainlayout.jsp': org.eclipse.jetty.io.EofException
at freemarker.ext.servlet.IncludePage.execute(IncludePage.java:148)
at freemarker.core.Environment.visit(Environment.java:263)
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:126)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:210)
at freemarker.core.Environment.process(Environment.java:190)
at freemarker.template.Template.process(Template.java:237)
at org.springframework.web.servlet.view.freemarker.FreeMarkerView.processTemplate(FreeMarkerView.java:366)
at org.springframework.web.servlet.view.freemarker.FreeMarkerView.doRender(FreeMarkerView.java:283)
at org.springframework.web.servlet.view.freemarker.FreeMarkerView.renderMergedTemplateModel(FreeMarkerView.java:233)
at org.springframework.web.servlet.view.AbstractTemplateView.renderMergedOutputModel(AbstractTemplateView.java:167)
at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:262)
at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1157)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:927)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1352)
at org.mifos.servlet.filters.MifosAccessLogFilter.doFilter(MifosAccessLogFilter.java:72)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323)
at org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java:58)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
at org.mifos.security.authentication.MifosLegacyUsernamePasswordAuthenticationFilter.doFilter(MifosLegacyUsernamePasswordAuthenticationFilter.java:115)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323)
at org.mifos.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:474)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:480)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:934)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:404)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:869)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:151)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
at org.eclipse.jetty.server.Server.handle(Server.java:346)
at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:581)
at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1040)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:592)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214)
at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:526)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:41)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:528)
at java.lang.Thread.run(Unknown Source)
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: ServletException in '/pages/framework/jsp/mainlayout.jsp': org.eclipse.jetty.io.EofException
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:939)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:871)
at org.apache.jsp.pages.application.customer.jsp.clients_005faccounts_jsp._jspService(org.apache.jsp.pages.application.customer.jsp.clients_005faccounts_jsp:114)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:109)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1352)
at org.mifos.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:474)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:934)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:404)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:869)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:285)
at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:116)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1063)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:386)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:229)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:534)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1352)
at org.mifos.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:474)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:226)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:934)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:404)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:184)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:869)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.Dispatcher.include(Dispatcher.java:196)
at freemarker.ext.servlet.IncludePage.execute(IncludePage.java:144)
... 74 more
Caused by: javax.servlet.jsp.JspException: ServletException in '/pages/framework/jsp/mainlayout.jsp': org.eclipse.jetty.io.EofException
at org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.java:923)
at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:462)
at org.apache.jsp.pages.application.customer.jsp.clients_005faccounts_jsp._jspx_meth_tiles_insert_0(org.apache.jsp.pages.application.customer.jsp.clients_005faccounts_jsp:143)
at org.apache.jsp.pages.application.customer.jsp.clients_005faccounts_jsp._jspService(org.apache.jsp.pages.application.customer.jsp.clients_005faccounts_jsp:106)
... 119 more
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
Hello Ramesh
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec
INFO: Ignoring UnsupportedOperationException thrown by ODA driver (org.eclipse.birt.report.data.oda.jdbc); cannot set query specification before prepare.
Do you think this is related to the problem?
Thanks and Regards,
Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :ramesh.a.nayak@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Hi George,
I used attached report on your database dump, but I am not able to reproduce this issue because I am generating empty report all the time. Probably, the reason is that I am using wrong date, office or LA.
Could you tell me which combination of date, office and LA should I use to see this issue?
Regards,
Lukasz
------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________ Mifos-users mailing list Mifos...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
Thanks and Regards,
Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :ramesh.a.nayak@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Contact Number - Mob : +919739317276.
Thanks and Regards,
Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :ramesh.a.nayak@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Ramesh
Thanks and Regards,
Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :ramesh....@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Contact Number - Mob : +919739317276.
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
--
Thanks and Regards,
Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :ramesh....@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Contact Number - Mob : +919739317276.
------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev
Ramesh
Thanks and Regards,
Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :ramesh.a.nayak@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Contact Number - Mob : +919739317276.
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
--
Thanks and Regards,
Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :ramesh.a.nayak@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Contact Number - Mob : +919739317276.
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-users mailing list
Mifos...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
>>> <george...@almajmoua.org <mailto:georgeslteif@almajmoua.org>>
>>> <mailto:Mifos-users@lists.sourceforge.net>
>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>
>>> <https://lists.sourceforge.net/lists/listinfo/mifos-users>
>>>
>>>
>>>
>>>
>>> -- Thanks and Regards,
>>> Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies |
>>> Address :#412, 20th Main,Chord Road 1st Block Rajajinagar
>>> Bengaluru,Karnataka-560010 | Email
>>> :ramesh.a.nayak@confluxtechnologies.com
>>> <mailto:ramesh.a.nayak@confluxtechnologies.com> |
>>> website: www.Confluxtechnologies.com
>>> <http://www.confluxtechnologies.com/> |
>>> Contact Number - Mob : +919739317276.
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>>
>>> For Developers, A Lot Can Happen In A Second.
>>> Boundary is the first to Know...and Tell You.
>>> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
>>> http://p.sf.net/sfu/Boundary-d2dvs2
>>> <http://p.sf.net/sfu/Boundary-d2dvs2>
>>>
>>> _______________________________________________
>>> Mifos-users mailing list
>>> Mifos...@lists.sourceforge.net
>>> <mailto:Mifos-users@lists.sourceforge.net>
>>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>> <https://lists.sourceforge.net/lists/listinfo/mifos-users>
>>>
>>>
>>>
>>>
>>> -- Thanks and Regards,
>>> Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address
>>> :#412, 20th Main,Chord Road 1st Block Rajajinagar
>>> Bengaluru,Karnataka-560010 | Email
>>> :ramesh.a.nayak@confluxtechnologies.com
>>> <mailto:ramesh.a.nayak@confluxtechnologies.com> | website:
>>> www.Confluxtechnologies.com <http://www.confluxtechnologies.com/> |
>>> Contact Number - Mob : +919739317276.
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>>
>>> Better than sec? Nothing is better than sec when it comes to
>>> monitoring Big Data applications. Try Boundary one-second
>>> resolution app monitoring today. Free.
>>> http://p.sf.net/sfu/Boundary-dev2dev
>>> <http://p.sf.net/sfu/Boundary-dev2dev>
>>>
>>>
>>> _______________________________________________
>>> Mifos-users mailing list
>>> Mifos...@lists.sourceforge.net
>>> <mailto:Mifos-users@lists.sourceforge.net>