Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT)

Showing 1-15 of 15 messages
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Ramesh Nayak 4/13/12 5:14 AM
Hi George,

Mifos 2.3 on-wards has Cloud Foundry support(http://sourceforge.net/projects/mifos/files/mifos/2.3.1/mifos-v2.3.1-CF.war/download) these cloud foundry war can run inside tomcat.

I was also upgrading client from 2.1.6 to 2.3.1 and so for not encountered any issues(all operations and custom birt reports are working fine).

If you are facing any jetty specific issues, downloading cloud foundry war and using your current tomcat infrastructure could also be an option.

Thanks,
Ramesh

PS:I have not yet completed testing thoroughly, in case if I encounter any issues I will let you know.

On Fri, Apr 13, 2012 at 4:23 PM, George Lteif <george...@almajmoua.org> wrote:

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




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

Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Georges Lteif 4/13/12 1:42 PM
Hello Ramesh
thank you for your help
i will give it a try tomorrow and post the feedback

just a quick question, did you use the scripts upgrade from 2.1.6 ? or you directly upgraded using the War file?



thank you 
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Ramesh Nayak 4/13/12 8:54 PM
Hi George,

I am using scripts to upgrade from 2.1.6 to 2.3.1.

Thanks and Regards,
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




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

Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Ramesh Nayak 4/14/12 2:51 AM
Hi George,

While upgrading I encountered this issue (ALTER TABLE loan_offering ADD CONSTRAINT loan_offering_penalty FOREIGN KEY (penalty_id) REFERENCES penalty(penalty_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
Duplicate key name 'loan_offering_penalty' ).

To fix this issue I removed ALTER TABLE loan_offering ADD CONSTRAINT loan_offering_penalty FOREIGN KEY (penalty_id) REFERENCES penalty(penalty_id) ON DELETE NO ACTION ON UPDATE NO ACTION  query in changelog-Release_H.xml(mifos-v2.3.1\db\changesets) file.

Thanks and Regards,
Ramesh
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Georges Lteif 4/15/12 11:04 PM
Hello Ramesh
thanks for the tip, i encountered the same error while upgrading :)

i installed the CF version on our current structure (TOMCAT)
and it ran smoothly, but it didn't fix the report problem though
i checked the catlina log
and i found this

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?

Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Georges Lteif 4/16/12 3:29 AM
I included a report we are using maybe it can help tracking the problem
?
thanks
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Ramesh Nayak 4/17/12 8:44 PM
Hi Lukasz,

I followed this link to upgrade mifos db 2.1.6 to 2.3.1(http://tinyurl.com/bu7zmw2).

When I ran expand_db.sh script after some time I got this error(ALTER TABLE loan_offering ADD CONSTRAINT loan_offering_penalty FOREIGN KEY (penalty_id) REFERENCES penalty(penalty_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
Duplicate key name 'loan_offering_penalty').

To fix this issue I removed ALTER TABLE loan_offering ADD CONSTRAINT loan_offering_penalty FOREIGN KEY (penalty_id) REFERENCES penalty(penalty_id) ON DELETE NO ACTION ON UPDATE NO ACTION  query in changelog-Release_H.xml(mifos-v2.3.1\db\changesets) file.

After making this change expand_db.sh script ran successfully.

Please let me know still you need any information.

Thanks and Regards,
Ramesh

On Tue, Apr 17, 2012 at 4:56 PM, Lukasz Chudy <lch...@soldevelo.com> wrote:
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....@confluxtechnologies.com | website: www.Confluxtechnologies.com |
Contact Number - Mob : +919739317276.
 

Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Ramesh Nayak 4/18/12 12:17 AM
Hi George,

I have seen this stack trace a lot of times but it does not seem to affect any report.

I went through your report and that product ids are hard-coded in them, so I cant really test them without making changes to the report/using the database for which the report was developed

If you can share a zipped dump of your mifos database (for version 2.3), I can try running your reports against it and help debug/fix the issue.

Thanks and Regards,
Ramesh
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Georges Lteif 4/24/12 4:09 AM
Hello Ramesh
just a curious question, did you have time to test the dump just to see if you encountered the same problem?

thanks




On Friday, April 13, 2012 3:14:34 PM UTC+3, Ramesh Nayak wrote:

On Friday, April 13, 2012 3:14:34 PM UTC+3, Ramesh Nayak wrote:
Hi George,

Mifos 2.3 on-wards has Cloud Foundry support(http://sourceforge.net/projects/mifos/files/mifos/2.3.1/mifos-v2.3.1-CF.war/download) these cloud foundry war can run inside tomcat.

I was also upgrading client from 2.1.6 to 2.3.1 and so for not encountered any issues(all operations and custom birt reports are working fine).

If you are facing any jetty specific issues, downloading cloud foundry war and using your current tomcat infrastructure could also be an option.

Thanks,
Ramesh

PS:I have not yet completed testing thoroughly, in case if I encounter any issues I will let you know.

On Fri, Apr 13, 2012 at 4:23 PM, George Lteif <george...@almajmoua.org> wrote:

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

...
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Lukasz Chudy 4/24/12 6:45 AM
Hi George,

Finally, I reproduced this issue and behavior is exactly as your described - Mifos freezes after running report. I created Jira issue for that bug: http://mifosforge.jira.com/browse/MIFOS-5579.

We will prepare a new Mifos hotfix release (v2.3.3) that will contain fix for this bug.

Best regards,
Lukasz ...
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Georges Lteif 4/24/12 8:17 AM
Thank you so much Lukasz, that is great news
BTW what was causing the problem?
...
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Lukasz Chudy 4/25/12 4:42 AM
Hi George,

We are still working to fix this issue. Once we resolve it, I will let you know what was causing the problem.

Best regards,
Lukasz ...
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Ramesh Nayak 4/25/12 5:51 AM
Hi George,

I also face the same problem when I ran the report.

Thanks and Regards,
Ramesh
...
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Jakub Sławiński 4/30/12 5:41 AM

Hi,

we finally fixed the mentioned bug (MIFOS-5579). Please check the newest
war from the h release branch, which contains our fix:

https://ci.mifos.org/hudson/job/head-h-release-archive/64/org.mifos$mifos-war/artifact/org.mifos/mifos-war/1.10-SNAPSHOT/mifos.war

If you do not notice any new problems, we will prepare the official
Mifos 2.3.3 release by the end of this week.

George, this was a synchronization issue, which causes that only one
HTTP request could be run at the same time.


Regards,
  Jakub.


On 04/25/2012 01:42 PM, Lukasz Chudy wrote:
> Hi George,
>
> We are still working to fix this issue. Once we resolve it, I will let
> you know what was causing the problem.
>
> Best regards,
> Lukasz
>
>
> On 04/24/2012 05:17 PM, Georges Lteif wrote:
>> Thank you so much Lukasz, that is great news
>> BTW what was causing the problem?
>>
>>
>>
>> On Tuesday, April 24, 2012 4:45:27 PM UTC+3, Lukasz Chudy wrote:
>>
>>     Hi George,
>>
>>     Finally, I reproduced this issue and behavior is exactly as your
>>     described - Mifos freezes after running report. I created Jira
>>     issue for that bug: http://mifosforge.jira.com/browse/MIFOS-5579
>>     <http://mifosforge.jira.com/browse/MIFOS-5579>.
>>
>>     We will prepare a new Mifos hotfix release (v2.3.3) that will
>>     contain fix for this bug.
>>
>>     Best regards,
>>     Lukasz
>>
>>
>>     On 04/18/2012 09:17 AM, Ramesh Nayak wrote:
>>>     Hi George,
>>>
>>>     I have seen this stack trace a lot of times but it does not seem
>>>     to affect any report.
>>>
>>>     I went through your report and that product ids are hard-coded in
>>>     them, so I cant really test them without making changes to the
>>>     report/using the database for which the report was developed
>>>
>>>     If you can share a zipped dump of your mifos database (for
>>>     version 2.3), I can try running your reports against it and help
>>>     debug/fix the issue.
>>>
>>>     Thanks and Regards,
>>>     Ramesh
>>>
>>>     On Mon, Apr 16, 2012 at 11:34 AM, Georges Lteif
>>>     <george...@almajmoua.org <mailto:george...@almajmoua.org>>
>>>     wrote:
>>>
>>>         Hello Ramesh
>>>         thanks for the tip, i encountered the same error while
>>>         upgrading :)
>>>
>>>         i installed the CF version on our current structure (TOMCAT)
>>>         and it ran smoothly, but it didn't fix the report problem though
>>>         i checked the catlina log
>>>         and i found this
>>>
>>>         */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?
>>>
>>>         *
>>>         *
>>>
>>>         *
>>>         *
>>>
>>>
>>>         On Friday, April 13, 2012 3:14:34 PM UTC+3, Ramesh Nayak wrote:
>>>
>>>             Hi George,
>>>
>>>             Mifos 2.3 on-wards has Cloud Foundry
>>>            
>>> support(http://sourceforge.net/projects/mifos/files/mifos/2.3.1/mifos-v2.3.1-CF.war/download
>>>
>>>            
>>> <http://sourceforge.net/projects/mifos/files/mifos/2.3.1/mifos-v2.3.1-CF.war/download>)
>>>
>>>             these cloud foundry war can run inside tomcat.
>>>
>>>             I was also upgrading client from 2.1.6 to 2.3.1 and so
>>>             for not encountered any issues(all operations and custom
>>>             birt reports are working fine).
>>>
>>>             If you are facing any jetty specific issues, downloading
>>>             cloud foundry war and using your current tomcat
>>>             infrastructure could also be an option.
>>>
>>>             Thanks,
>>>             Ramesh
>>>
>>>             PS:I have not yet completed testing thoroughly, in case
>>>             if I encounter any issues I will let you know.
>>>
>>>             On Fri, Apr 13, 2012 at 4:23 PM, George Lteif
>>>             <george...@almajmoua.org
>>>                 <http://org.eclipse.jetty.io>.EofException
>>>                 <http://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
>>>                 <http://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
>>>                 <http://p.sf.net/sfu/Boundary-d2dvs2>
>>>                 _______________________________________________
>>>                 Mifos-users mailing list
>>>                 Mifos...@lists.sourceforge.net
>>>                 <mailto:Mifos...@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....@confluxtechnologies.com
>>>             <mailto:ramesh....@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...@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....@confluxtechnologies.com
>>>     <mailto:ramesh....@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...@lists.sourceforge.net>
>>>     https://lists.sourceforge.net/lists/listinfo/mifos-users
>>> <https://lists.sourceforge.net/lists/listinfo/mifos-users>
>>
>>
>>
>> ------------------------------------------------------------------------------
>>
>> 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
>
>
>
>
> ------------------------------------------------------------------------------
> 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


------------------------------------------------------------------------------
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/
Re: [Mifos-users] Upgrade from version 2.1.6 to version 2.3 (Problem Jetty/BIRT) Georges Lteif 4/30/12 2:31 PM
Thank you so much Jakub
this will help us to go live with the new version by next week

thank you all for you help

best
...