adamdiblasio
-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by adamdiblasio
-
-
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
Home screen folder tree not loading
in Products
Posted
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