cdr70800 Posted February 2, 2009 Share Posted February 2, 2009 Hi!I am testing JasperServer for our company and we're quite impressed regarding all the features it offers.Unfortunately my JasperServer is often not responding for long periods, after i've tried to generate an report.Amazingly the Tomcat is responding and the workload of the java & mysql processes is 0 ...It just seems to do nothing while the Browser is waiting for the resulting page. I'm using Jasperserver 3.1.0.1 on Debian 4.0r5 in an VirtualBox VM (Version 2.1.2) Thank you for your help. Link to comment Share on other sites More sharing options...
swood Posted February 7, 2009 Share Posted February 7, 2009 If you try hitting something on the server, does it work? There maybe an Ajax issue that you can't see. What browser are you using? ShermanJaspersoft Link to comment Share on other sites More sharing options...
cdr70800 Posted February 23, 2009 Author Share Posted February 23, 2009 Hi! I am using Firefox 3.0.6 and IE 6.Although the server is not responing for a long time, after that time the report is shown.It just seems to wait for a long time before starting to generate. I also tried to install JasperServer on a real maschine with Debian 4, but there is the same Problem. Link to comment Share on other sites More sharing options...
swood Posted February 27, 2009 Share Posted February 27, 2009 Looks like a performance problem. Is it a complicated report, or one that generates a lot of pages? Does the query take a long time to process outside of JasperServer? How does the report run in iReport? What amount of memory (JVM) are you using for the server? ShermanJaspersoft Link to comment Share on other sites More sharing options...
cdr70800 Posted February 27, 2009 Author Share Posted February 27, 2009 This issue comes with every shipped samplereport.And how can it be an performance problem if the workload on the server is zero?When i try to open a report, the server is doing nothing. After some time it starts to process the report.But why does it wait before it starts? The memory amount should be at its default value Link to comment Share on other sites More sharing options...
tkavanagh Posted February 27, 2009 Share Posted February 27, 2009 Take a look at the Install Guide. It gives details on JAVA_OPTS memory values to set. If you install using the installer (the Bundled Tomcat and Bundled mysql) then all the JAVA_OPTS are setup for you already.However, if you install manually (ie using jasperserver-3.1-bin.zip) then you must set the java opts in your tomcat startup script. Also, you can bump up the recommended defaults higher if you have the memory to support this.see section 5.12 "Set JAVA JVM Options" (found in <install-dir>/docs directory) Link to comment Share on other sites More sharing options...
cdr70800 Posted March 3, 2009 Author Share Posted March 3, 2009 I did use the bundled installer with mysql and tomcat.My machine has only 1 gig of Ram. The JVM max memory option was set to 512mb and i raised it to 768mb now.But the Java Process never took more than ~350mb during my tests. Link to comment Share on other sites More sharing options...
swood Posted March 9, 2009 Share Posted March 9, 2009 Looks like it is a database, or Debian/VM performance issue. Do the queries in the reports run quickly outside of the reports? If you open the reports in iReport, via the plugin, you can see the queries. ShermanJaspersoft Link to comment Share on other sites More sharing options...
cdr70800 Posted March 10, 2009 Author Share Posted March 10, 2009 I tried the sales by month report from the sample repository.The query runs superfast on the database."47 rows in set (0.01 sec)" The report takes some minutes to respond.This is on a Dual Core Xeon with 2.8 ghz and 1gb of Ram.How could this problem be related to the Debian System? EDIT: I see this report has a subreport, so there are 47 additional queries. Unfortunately my ireport wont open the subreport. Post Edited by cdr 70800 at 03/10/09 15:34 Link to comment Share on other sites More sharing options...
swood Posted March 16, 2009 Share Posted March 16, 2009 Is it just that Sales by Moth report with the subreport that is slow? Meaning, do the other sample reports have the same problem? From what you are saying, I suspect all are having a problem. I don't really know where the issue is. If you try scheduling the report, does it run quickly? What about through web services? You can run the report from iReport with the plugin. ShermanJaspersoft Link to comment Share on other sites More sharing options...
cdr70800 Posted March 18, 2009 Author Share Posted March 18, 2009 If i schedule the report it also takes that long. Yes i have this problem with every samplereport. What is the webservices plugin? My next step will be installing the Server onto much more performant hardware (2,3Ghz Quadcore with 4GB Ram), maybe this helps. Link to comment Share on other sites More sharing options...
swood Posted March 20, 2009 Share Posted March 20, 2009 The hardware you have should be fine for running the sample reports with a few users. Did you use the installer, or manually install the WAR? Is it just reports that are slow? What about logging in, browsing the repository etc? iReport has a graphical plugin that allows you to maintain the JasperServer repository remotely - manage folders, edit and publish and run reports, data sources etc. It uses web services to communicate with the server. ShermanJaspersoft Link to comment Share on other sites More sharing options...
cdr70800 Posted March 20, 2009 Author Share Posted March 20, 2009 I did use the installer and browsing the server is nice and fast. No Problems there.The analysis views are also working great and responsive. Even our selfmade Test-Reports are running in reasonable time (the bottleneck with them is our old Database).Only the sample reports are that slow but the queries on the database finish quite fast, so i really can't imagine where the problem could be. In fact i do not really have a problem with them being slow, as long as our selfmade reports run fast, but try to tell my boss we should spend that much money on a solution which does not perform in his eyes. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now