adamdiblasio Posted September 15, 2008 Share Posted September 15, 2008 I am experiencing the following intermittent problem and can't appear to find any helpful information within the logs! After an initial start of jboss (4.0.5-GA) I can successfully login to jasperserver (3.0.0) and view the contents of the home screen folder tree.It appears that once this jboss instance has been running for a certain period of time (roughly 1-2days) When I start a new jasper session - I get the 'loading' icon at the top left of the folder tree window, but the folders never appear.After multiple browser refresh I can sometimes manage to get the tree to load, but trying to expand any subfolder within the tree causes the same 'loading' icon to appear - and the contents are never displayed.So far I have found the only successful option is to restart the jboss instance, but obviously this is not a desired solution! Any help would be greatly appreciated. ThanksAdam Link to comment Share on other sites More sharing options...
swood Posted September 18, 2008 Share Posted September 18, 2008 This looks like a browser caching problem related to the Ajax based repository browser screen, but I can't be sure. I doubt it is JBoss specific. We will try to recreate it. ShermanJaspersoft Link to comment Share on other sites More sharing options...
adamdiblasio Posted September 18, 2008 Author Share Posted September 18, 2008 Thanks for your reply Sherman, I have found the problem to occur in several different browsers even after clearing the browser cache. Are there any other tests I can run on this side to provide you with more information? Thanks Adam Link to comment Share on other sites More sharing options...
Gaby38 Posted September 18, 2008 Share Posted September 18, 2008 Hello,I also got this trouble with Tomcat : I posted already posted about that one or two months ago. My feeling is that the metadatabase is "sleeping" and needs to be awaken! So I followed the advice of Lucian or Shermann (I don't remember) and I added "autoReconnectForPools=true" in the URL parameter of the metadatabase jndi definition (in my case MySql).Since I got no more this trouble. If you get it, you can get the tree working by clicking the Home menu instead of the refresh button. Link to comment Share on other sites More sharing options...
adamdiblasio Posted September 22, 2008 Author Share Posted September 22, 2008 Hi, thanks for the response, I will be testing this URL parameter. as for using the 'home' button instead of refreshing, I have tried this without any success. Thanks Adam Link to comment Share on other sites More sharing options...
adamdiblasio Posted September 23, 2008 Author Share Posted September 23, 2008 I have tried adding the URL parameter to the context.xml file. After several hours I am still getting the same problem, in addition I am now also getting the following error after logging back in to jasper server: org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:584) org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:745) org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:722) org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:325) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) $Proxy60.loadUserByUsername(Unknown Source) org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:86) org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:115) org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:183) org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:45) org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:71) org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:199) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) Any idea's on how to fix this? Thanks in advance Adam Link to comment Share on other sites More sharing options...
Gaby38 Posted September 23, 2008 Share Posted September 23, 2008 Here after the part of my context.xml file about the jasper database:<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasperdb" password="xxxxxxx" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1/jasperserver?useUnicode=true&characterEncoding=UTF-8&autoReconnectForPools=true"/>At this time I reconnected to my jasperserver after 2 or 3 days of inactivity and I got no problem. Perhaps is it another thing in my context??Code:<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasperdb" password="rambo2" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1/jasperserver?useUnicode=true&characterEncoding=UTF-8&autoReconnectForPools=true"/> Link to comment Share on other sites More sharing options...
adamdiblasio Posted September 25, 2008 Author Share Posted September 25, 2008 Comparing your context with my context file, they appear to have the same content.It appears that I have to restart at least every 24hours at the moment, plus I am now also receiving the error shown in my previous post. I have tried setting up the software from scratch several times now to no avail.Code:<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="xxxxxx" password="xxxxxxxx" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/jasperserver?useUnicode=true&characterEncoding=UTF-8&autoReconnectForPools=true" /> Link to comment Share on other sites More sharing options...
adamdiblasio Posted October 1, 2008 Author Share Posted October 1, 2008 I have now also tried Jasperserver Professional within a separate Jboss instance and I am getting the same behaviour, within 24 hours of starting the JVM the folder tree for the repository does not load and then a hibernate error (as shown above) appears on next login. Link to comment Share on other sites More sharing options...
ritesh12345 Posted February 11, 2009 Share Posted February 11, 2009 Hi I m new user nd right now i m working on Jasper report.I m facing same problem (loading icon) .plz tell me what is a solution.ThanksRitesh Link to comment Share on other sites More sharing options...
adamdiblasio Posted February 11, 2009 Author Share Posted February 11, 2009 Hi Ritesh, I found the solution in modifying the default js-mysql-ds.xml In here there is a parameter called which is by default set to 0. If you set this to any integer value other than 0 (I use 10) this will cause the mysql connections to timeout and be re-created by jasper. Regards Adam Link to comment Share on other sites More sharing options...
vsoneta Posted February 11, 2009 Share Posted February 11, 2009 Even I am facing the same issue not getting the folder... I able to successuly login to the jasperserver page but as soon as it comes to the default page it just tries to load the fodler and gets the below error in Tomcat and just hangs.Tomcat logs I am getting the below error : 11:12:19,817 ERROR JSErrorPage_jsp,ajp-8009-2:339 - com.jaspersoft.jasperserver.api.JSException: jsexception.null.uri at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:572) My Context.xml has : <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasperdb" password="XXXXX" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://XXXX:3306/jasperserver?useUnicode=true&characterEncoding=UTF-8&autoReconnectForPools=true"/> Using Jasper 3.1, Tomcat 6.0 and MySQL 5.0.. PLEASE HELP.. I AM JUST STUCK... Link to comment Share on other sites More sharing options...
ritesh12345 Posted February 13, 2009 Share Posted February 13, 2009 Hi Adam Thanks for reply, but adam my problem is folder icon in loading form when i login through the user not admin.Plz find the attached file/ThanksRitesh Post Edited by Ritesh Kumar at 02/13/09 06:33Post Edited by Ritesh Kumar at 02/13/09 14:20 Link to comment Share on other sites More sharing options...
ritesh12345 Posted February 16, 2009 Share Posted February 16, 2009 Hi Adamplz find the attached doc. file.Actually problem is when i login through particular user, folder icon is in loading form.that's is errorplz reply ASAP.Thanks Link to comment Share on other sites More sharing options...
swood Posted February 25, 2009 Share Posted February 25, 2009 What is in the repository database? Any folders or resources? You can see this in the jiresourcefolder and jiresource tables. ShermanJaspersoft Link to comment Share on other sites More sharing options...
ankushchhabra Posted December 16, 2012 Share Posted December 16, 2012 I faced and fixed this issue today .Open CC Cleaner . Clean your browser cache , application data , history and clean everything which CC Cleaner cleans by default.Restart db and server. ( may not be mandatory but i did ) Regards,Ankush Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now