vinvar

Hi All, I want to sequentially schedule my reports. I have found a post on this site which states that I can do this by changing the number of scheduling threads to 1. It will be highly helpfull if someone could let me know which file/parameter should be changed. The original post can be found by searching "scheduling threads". Thanks In advance. Warm Regards, Vin

Hi All, I want to sequentially schedule my reports. I have found a post on this site which states that I can do this by changing the number of scheduling threads to 1. It will be highly helpfull if someone could let me know which file/parameter should be changed. The original post can be found by searching "scheduling threads". Thanks In advance. Warm Regards, Vin

I don't even get the blank reports. Some of the reports do not get generated at all

Hello All, I am actually working on a project for a company that uses JasperServer 2.1 in Linux environment. It is part of our customers requirement to generate 19 reports whould contain a wide content of data from Server utilizations to sales figures. There is a large amount of data that is reported. Few of the Reports( PDF format ) run into several thousands of pages. We encountered a major hurdle during testing. When we scheduled JasperServer to generate all the 19 reports at the same time, we observe that some of them do not get generated. However all the reports get generated without any problem when run manually. We went through the internet and found the following two potential solutions. 1.) Modifying the js.quartz.properties file at /opt/jasperserver-2.1/apache-tomcat/webapps/jasperserver/WEB-INF/js.quartz.properties org.quartz.scheduler.instanceName=JasperServerScheduler org.quartz.threadPool.threadCount=2 org.quartz.threadPool.threadPriority=3 org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate change the threadCount to 25 2.) Change the applicationContext.xml file <bean id="dataSourceObjectPoolFactory" class="org.apache.commons.pool.impl.GenericObjectPoolFactory"> <constructor-arg type="org.apache.commons.pool.PoolableObjectFactory"><null/></constructor-arg> <constructor-arg type="int" value="5"/> </bean> should be changed to ‘25’( Since we need 19 Reports ). Unfortunately both solutions have not worked. I am also providing the characteristics of the DB server as observed from mysql SUN Dashboard. 1.) The number of row accesses shoots upto 120,000 average rows per second from a near zero. 2.) Row writes goes upto 28,000 from a near zero. 3.) CPU utilization goes upto 35% from a near zero. One final piece of information, the following is the error in the Catalina.out file [Catalina.out log] 16:00:58,069 ERROR ReportExecutionJob, JasperServerScheduler_Worker-20:208 - java.lang.NullPointerException java.lang.NullPointerException Kindl advise on what further action we need to take as this error is hampering our confidence and progress.

Inputs will be most welcome and appreciated. Thanks

We have two sections in our Report(PDF file Output) 1.) The main report that has all the raw data. This is fetched using JasperReport 2.) A summary of the raw data which is part of the subreport(JRXML file is used) The blank page occurs in between the rawdata and the summary. I can see the problem occuring all the time.

Hello All, I am sorry. For some reason there seem to be two threads that have been created for the same topic.

Hello All, I am actually working on a project for a company that uses JasperServer 2.1 in Linux environment. It is part of our customers requirement to generate 19 reports whould contain a wide content of data from Server utilizations to sales figures. There is a large amount of data that is reported. Few of the Reports( PDF format ) run into several thousands of pages. We have observed that at times there appears to be a Blank page between the main report and the subreport. The main report is loaded by selecting the JasperReport option and the Subreport by choosing the JRXML file. Please advice us on how we can tackle this issue.

Hello All, I am actually working on a project for a company that uses JasperServer 2.1 in Linux environment. It is part of our customers requirement to generate 19 reports whould contain a wide content of data from Server utilizations to sales figures. There is a large amount of data that is reported. Few of the Reports( PDF format ) run into several thousands of pages. We have observed that at times there appears to be a Blank page between the main report and the subreport. The main report is loaded by selecting the JasperReport option and the Subreport by choosing the JRXML file. Please advice us on how we can tackle this issue.

Hello, I am actually working on a project for a company that uses JasperServer 2.1 in Linux environment. It is part of our customers requirement to generate 19 reports whould contain a wide content of data from Server utilizations to sales figures. There is a large amount of data that is reported. Few of the Reports( PDF format ) run into several thousands of pages. We encountered a major hurdle during testing. When we scheduled JasperServer to generate all the 19 reports at the same time, we observe that some of them do not get generated. However all the reports get generated without any problem when run manually. We went through the internet and found the following two potential solutions. 1.) Modifying the js.quartz.properties file at /opt/jasperserver-2.1/apache-tomcat/webapps/jasperserver/WEB-INF/js.quartz.properties org.quartz.scheduler.instanceName=JasperServerScheduler org.quartz.threadPool.threadCount=2 org.quartz.threadPool.threadPriority=3 org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate change the threadCount to 25 2.) Change the applicationContext.xml file <bean id="dataSourceObjectPoolFactory" class="org.apache.commons.pool.impl.GenericObjectPoolFactory"> <constructor-arg type="org.apache.commons.pool.PoolableObjectFactory"><null/></constructor-arg> <constructor-arg type="int" value="5"/> </bean> should be changed to ‘25’( Since we need 19 Reports ). Unfortunately both solutions have not worked. I am also providing the characteristics of the DB server as observed from mysql SUN Dashboard. 1.) The number of row accesses shoots upto 120,000 average rows per second from a near zero. 2.) Row writes goes upto 28,000 from a near zero. 3.) CPU utilization goes upto 35% from a near zero. One final piece of information, the following is the error in the Catalina.out file [Catalina.out log] 16:00:58,069 ERROR ReportExecutionJob, JasperServerScheduler_Worker-20:208 - java.lang.NullPointerException java.lang.NullPointerException Kindl advise on what further action we need to take as this error is hampering our confidence and progress.