adamdiblasio

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

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.

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

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

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

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

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