Sample reports problem

 Hello,

 

I'm having a problem running the sample reports.

When I select any of them (sugarcrm or foodmart), it keeps loading indefinitely.

 

Could you help me please ?

 

I'm running JaserReports Server 4.5 under:

- OS X Lion Server

- Apple Java 1.6.0_31

- Tomcat 6

- MySQL 5.1.61

ladenise's picture
Joined: Apr 5 2012 - 5:25am
Last seen: 11 years 5 months ago

11 Answers:

Moving it to the JR Server forum ...

shertage's picture
22298
Joined: Sep 26 2006 - 8:06pm
Last seen: 2 months 3 weeks ago

Hi there,

we have just installed jasper server on a linux (Centos) and have the same problem.

We did the installation command line and accepted all the defaults, installed the sample stuff etc.

As database we took the postgresql as deliverd within the install.

Someone can help us out here?

Regards,

Jan

willeja's picture
300
Joined: Sep 8 2011 - 9:12am
Last seen: 8 years 9 months ago

 Hi,

I would suggest doing the manual WAR installation process, which is documented in the installation guide (it's a PDF in the docs folder). Also - are the log files recording any errors?

 

gdmoreno's picture
24664
Joined: Oct 26 2010 - 3:23pm
Last seen: 2 years 8 months ago

Now I did the WAR file install, but same problem.

When running the page, in the console (of firebug) I see the following:

$(fromLocation) is null

          toLoc.innerHTML = $(fromLocation).innerHTML;

willeja's picture
300
Joined: Sep 8 2011 - 9:12am
Last seen: 8 years 9 months ago
Hi Willja,
did you do the full install using the buildomatic/js-install script?
When you check your DB, can you see sugarcrm and foodmart DB, and is there any tables in each?
Raphael
rpeguet's picture
13838
Joined: Mar 8 2011 - 2:06am
Last seen: 4 days 12 hours ago

Hi Raphael,

I have the databases. This is a part of the tables of foodmart:

(select * from pg_tables;)

 

     schemaname     |           tablename           | tableowner | tablespace | hasindexes | hasrules | hastriggers
--------------------+-------------------------------+------------+------------+------------+----------+-------------
 public             | customer                      | postgres   |            | t          | f        | f
 public             | days                          | postgres   |            | f          | f        | f
 public             | department                    | postgres   |            | t          | f        | f
 public             | employee                      | postgres   |            | t          | f        | f
 public             | employee_closure              | postgres   |            | t          | f        | f
 public             | expense_fact                  | postgres   |            | t          | f        | f
 public             | position                      | postgres   |            | t          | f        | f
 public             | product                       | postgres   |            | t          | f        | f
 public             | product_class                 | postgres   |            | f          | f        | f
 

 

There is data in the tables too...



Post Edited by willeja at 06/22/2012 10:56
willeja's picture
300
Joined: Sep 8 2011 - 9:12am
Last seen: 8 years 9 months ago

gdmoreno
Wrote:

 Hi,

I would suggest doing the manual WAR installation process, which is documented in the installation guide (it's a PDF in the docs folder). Also - are the log files recording any errors?

 

gdmoreno,

in catalina.out I find following error when running a report:

2012-06-22 12:58:24,836 ERROR Digester,http-8080-3:1366 - Begin event threw error
java.lang.NoClassDefFoundError: Could not initialize class java.awt.Color

Hope this one helps?
 

willeja's picture
300
Joined: Sep 8 2011 - 9:12am
Last seen: 8 years 9 months ago

oke, strange thing I just noticed:

There are some reports that keeps loading like "Accounts Report" and "Employee List".

But there are also reports that just give a white page like "Sales By Month" or "Department".

Does this make it even more difficult?

willeja's picture
300
Joined: Sep 8 2011 - 9:12am
Last seen: 8 years 9 months ago

 Interesting error that showed up in your log files. I would try adding this option to your startup script:

-Djava.awt.headless=true

I know that the server works with this option, so let's see what happens when you add that to your startup scripts. A good place to do it would be in the setenv.sh file. If nothing else, it would eliminate this as a potential problem. I would be interested in seeing a fuller stack trace, to at least where the first JasperReports classes start showing up.

gdmoreno's picture
24664
Joined: Oct 26 2010 - 3:23pm
Last seen: 2 years 8 months ago

Thanks for the reply.

If I use this in my setenv.sh, the jasperserver won't start up...

Code:
[tele1906(root):/labo_data_01/jasperreports/server/apache-tomcat/bin] vi setenv.sh
JAVA_HOME=/labo_data_01/jasperreports/server/java
JRE_HOME=/labo_data_01/jasperreports/server/java
JAVA_OPTS=$JAVA_OPTS:-Djava.awt.headless=true
export JAVA_HOME
export JRE_HOME
export JAVA_OPTS
[tele1906(root):/labo_data_01/jasperreports/server/apache-tomcat/bin]

What output from which files do you need?



Post Edited by willeja at 06/25/2012 08:54
willeja's picture
300
Joined: Sep 8 2011 - 9:12am
Last seen: 8 years 9 months ago

gdmoreno
Wrote:

 Interesting error that showed up in your log files. I would try adding this option to your startup script:

-Djava.awt.headless=true

I know that the server works with this option, so let's see what happens when you add that to your startup scripts. A good place to do it would be in the setenv.sh file. If nothing else, it would eliminate this as a potential problem. I would be interested in seeing a fuller stack trace, to at least where the first JasperReports classes start showing up.

Good news: It works!

I added the "-Djava.awt.headless=true" option in the /xxx/jasperreports/apache-tomcat/scripts/ctl.sh file:

"export JAVA_OPTS="-Xms1024m -Xmx1536m -XX:PermSize=32m -XX:MaxPermSize=128m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Djava.awt.headless=true""

 

Thanks everyone for helping me out, thanks gdmoreno for pointing me to the wright direction!!

willeja's picture
300
Joined: Sep 8 2011 - 9:12am
Last seen: 8 years 9 months ago
Feedback
randomness