Reports do not get created when scheduled

[vinvar]

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.

[vinvar]

Inputs will be most welcome and appreciated.

Thanks

[svenn]

You might want to repost this in the JasperServer forum.