Home screen folder tree not loading

0

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

 

adamdiblasio's picture
Joined: Sep 15 2008 - 2:27am
Last seen: 6 years 3 months ago

15 Answers:

0

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.

 

Sherman

Jaspersoft

swood's picture
2064
Joined: Jun 21 2006 - 12:48pm
Last seen: 2 years 2 months ago
0
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
adamdiblasio's picture
Joined: Sep 15 2008 - 2:27am
Last seen: 6 years 3 months ago
0

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.

Gaby38's picture
301
Joined: Mar 22 2008 - 1:49am
Last seen: 6 years 9 months ago
0
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
adamdiblasio's picture
Joined: Sep 15 2008 - 2:27am
Last seen: 6 years 3 months ago
0
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
adamdiblasio's picture
Joined: Sep 15 2008 - 2:27am
Last seen: 6 years 3 months ago
0

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&amp;characterEncoding=UTF-8&amp;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&amp;characterEncoding=UTF-8&amp;autoReconnectForPools=true"/></td></tr></tbody></table>
Gaby38's picture
301
Joined: Mar 22 2008 - 1:49am
Last seen: 6 years 9 months ago
0

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&amp;characterEncoding=UTF-8&amp;autoReconnectForPools=true"  /></td></tr></tbody></table>
adamdiblasio's picture
Joined: Sep 15 2008 - 2:27am
Last seen: 6 years 3 months ago
0
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.
adamdiblasio's picture
Joined: Sep 15 2008 - 2:27am
Last seen: 6 years 3 months ago
0

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.

Thanks

Ritesh

 

ritesh54321's picture
Joined: Feb 11 2009 - 3:44am
Last seen: 5 years 10 months ago
0
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
adamdiblasio's picture
Joined: Sep 15 2008 - 2:27am
Last seen: 6 years 3 months ago
0

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&amp;characterEncoding=UTF-8&amp;autoReconnectForPools=true"/>

 

Using Jasper 3.1, Tomcat 6.0 and MySQL 5.0..

 

PLEASE HELP.. I AM JUST STUCK...

 

 

 

vsoneta's picture
63
Joined: Feb 4 2009 - 5:50am
Last seen: 5 years 10 months ago
0

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/

Thanks

Ritesh

 

Post Edited by Ritesh Kumar at 02/13/09 06:33



Post Edited by Ritesh Kumar at 02/13/09 14:20
ritesh54321's picture
Joined: Feb 11 2009 - 3:44am
Last seen: 5 years 10 months ago
0

Hi Adam

plz find the attached doc. file.

Actually problem is when i login through particular user, folder icon is in loading form.that's is error

plz reply ASAP.

Thanks

 

ritesh54321's picture
Joined: Feb 11 2009 - 3:44am
Last seen: 5 years 10 months ago
0

What is in the repository database? Any folders or resources? You can see this in the jiresourcefolder and jiresource tables.

 

Sherman

Jaspersoft

swood's picture
2064
Joined: Jun 21 2006 - 12:48pm
Last seen: 2 years 2 months ago
0

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

ankushchhabra's picture
Joined: Oct 7 2010 - 4:22am
Last seen: 4 weeks 19 hours ago
Feedback
randomness