Getting null pointer Exception on scheduled jasper reports

[abhargava]

 

2011-04-21 19:27:16,438 ERROR ReportExecutionJob,quartzScheduler_Worker-1:313 - The report was not completed. An error occurred while executing it.
java.lang.NullPointerException
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.collectReportParameters(ReportExecutionJob.java:506)
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:494)
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:427)
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:231)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
2011-04-21 19:27:16,439 ERROR ReportExecutionJob,quartzScheduler_Worker-1:313 - The job was not completed. A system error occurred while running it.
java.lang.NullPointerException
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:441)
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:231)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
2011-04-21 19:27:16,465 ERROR ReportExecutionJob,quartzScheduler_Worker-1:313 - The report was not completed. An error occurred while executing it.
java.lang.NullPointerException
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.collectReportParameters(ReportExecutionJob.java:506)
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:494)
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:427)
        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:231)
                                                                                                                                        

Plz help

Thanks

[ernestoo]

When I see this it's usually because I failed to put in a value for a mandatory input control, could that be the case?

[abhargava]

Actually My reports are huge report as it took 50 min to generate the reports + it is of 14 pages,.

when i try to run any subreports or reports of 2 pages, then i am not getting any error in logs , i m getting only one mail as well,

but when i run main reports consists of 14 pages then i am getting this exception + 2 mails.

 

Plz help !! urgent

 

[sshvetsov]

I seem to get the same error for scheduled reports that take 30min-60min to execute. The reports seem to generate fine, but the error pops in the log at the end of the run.

There are no other reports running at the same time. I'm using JasperServer CP 4.2.1 (64bit vanila binary install) on Debian 6.0.4

Here's an example from my jasperserver.log:

 

Code:

2012-02-29 22:44:54,912 ERROR ReportExecutionJob,quartzScheduler_Worker-0:309 - The report was not completed. An error occurred while executing it.java.lang.NullPointerException        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.collectReportParameters(ReportExecutionJob.java:502)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:490)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:423)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:232)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)2012-02-29 22:44:54,932 ERROR ReportExecutionJob,quartzScheduler_Worker-0:309 - The job was not completed. A system error occurred while running it.java.lang.NullPointerException        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:437)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:232)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)2012-02-29 22:44:54,951 ERROR ReportExecutionJob,quartzScheduler_Worker-0:309 - The report was not completed. An error occurred while executing it.java.lang.NullPointerException        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.collectReportParameters(ReportExecutionJob.java:502)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:490)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:423)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:232)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)2012-02-29 22:44:54,958 ERROR ReportExecutionJob,quartzScheduler_Worker-0:309 - The job was not completed. A system error occurred while running it.java.lang.NullPointerException        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:437)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:232)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)2012-02-29 22:46:41,794 ERROR ReportExecutionJob,quartzScheduler_Worker-0:309 - The report was not completed. An error occurred while executing it.java.lang.NullPointerException        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.collectReportParameters(ReportExecutionJob.java:502)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:490)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:423)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:232)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)2012-02-29 22:46:41,794 ERROR ReportExecutionJob,quartzScheduler_Worker-0:309 - The job was not completed. A system error occurred while running it.java.lang.NullPointerException        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:437)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:232)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

[kcd]

 I am running into a similar problem occassionally with slow queries. The latest time my report ran indefinitely and I had to shut down Tomcat and clear the work and temp directories to save it from itself.

 

Code:

2012-05-25 10:35:53,972 ERROR ReportExecutionJob,quartzScheduler_Worker-0:310 - The job was not completed. A system error occurred while running it.java.lang.NullPointerException        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.createOutputs(ReportExecutionJob.java:588)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:427)        at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:233)        at org.quartz.core.JobRunShell.run(JobRunShell.java:195)        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)