The job failed to execute. Review its parameters

[ethan_2]

I have this erro when I have this schedule report.

The report run perfectly without scheduler.

Anyone help !!

 

 

Subject:

The job failed to execute. Review its parameters.

Date:

Today

Component:

Report Scheduler

Message:

Job: auto_date_day (ID: 1619) Report unit: /aa/bb Quartz Job: ReportJobs.job_1619 Quartz Trigger: ReportJobs.trigger_1638_0 Exceptions: The report was not completed. An error occurred while executing it. com.jaspersoft.jasperserver.api.JSException: java.lang.AssertionError: Last packet not finished at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:608) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReportUnitRequest(EngineServiceImpl.java:1896) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:67) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:490) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.runReport(ReportExecutionJob.java:659) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:624) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:460) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) Caused by: java.lang.AssertionError: Last packet not finished at org.mariadb.jdbc.internal.common.packet.PacketOutputStream.startPacket(PacketOutputStream.java:38) at org.mariadb.jdbc.internal.common.packet.commands.ClosePacket.send(ClosePacket.java:66) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.close(MySQLProtocol.java:672) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.close(MySQLProtocol.java:709) at org.mariadb.jdbc.MySQLConnection.close(MySQLConnection.java:246) at org.apache.commons.dbcp.DelegatingConnection.close(DelegatingConnection.java:151) at org.apache.commons.dbcp.PoolableConnection.reallyClose(PoolableConnection.java:95) at org.apache.commons.dbcp.PoolableConnectionFactory.destroyObject(PoolableConnectionFactory.java:301) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:800) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:55) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:68) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1690) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1055) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:989) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:900) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:878) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:599) ... 9 more fail to send out alert mail notification com.jaspersoft.jasperserver.api.JSExceptionWrapper: javax.mail.internet.AddressException: Illegal address in string ``'' at org.springframework.mail.javamail.MimeMessageHelper.parseAddress(MimeMessageHelper.java:708) at org.springframework.mail.javamail.MimeMessageHelper.setTo(MimeMessageHelper.java:592) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobAlertImpl.sendAlertMail(ReportExecutionJobAlertImpl.java:78) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendAlertMail(ReportExecutionJob.java:583) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:563) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

 

[zh3ntil]

javax.mail.internet.AddressException: Illegal address in string ``'' at org.springframework.mail.javamail.MimeMessageHelper.parseAddress(MimeMessageHelper.java:708) 

check the mail address in scheduler. it seems there are some invalid characters.

[ethan_2]

I test run the schedule reports many times with single email address.

This error throw out randomly, like 50/50.  

So weried