AWS jaspersoft server created AD hocs and reports not opening

[mc.bechara]

I have the Jaspersoft AWS version installed and I have created many adhoc views and reports since long and everything was working perfect. Except few days again, when I click on any of my existing adhocs or reports, it keeps loading and never opens. 

 

My internet connection is good. My datasource is well connected to oracle.

 

What is the problem?

[nthapa]

Have you looked at the log? any error, exceptions?

Please provide more details.

[mc.bechara]

no errors just as if it goes timeout and loader keeps turning

[marianol]

Is hard to figure out without more detail... Have you imported new elements to the repository? upgraded the server? I ssume your Oracle db is in RDS; have you changed the RDS security group? changed the user and or pass for your oracle DB?

 

It will be really useful to see the jasperserver.log to see what is happening in the backend. You should also enable logging of Domain Queries to see if those are sent to your Oracle backend. Since the wheel is spinning I'm thinking this is a connectivity issue with the DB, but the log will tell you what is going on.

 

To do that login as superuser to Jasperserver, go to Manage -> Server Settings ->log settings and select DEBUG in Log Domain Queries and also add this 2 classes at the end in DEBUG mode:

 

com.jaspersoft.commons.datarator.JdbcDataSet
com.jaspersoft.commons.semantic.dsimpl.JdbcDataSetFactory

 

Here you have some extra articles about troubleshooting datasources http://community.jaspersoft.com/wiki/data-source-troubleshooting