Below is the error in the log.
Subject:
The job failed to execute. Review its parameters.
Component:
Report Scheduler
Message:
Job: NTservices MSSQL (ID: 20116) Report unit: /public/xxxxx/CPU_Report_By_Origin_2 Quartz Job: ReportJobs.job_20116 Quartz Trigger: ReportJobs.trigger_20118_0 Exceptions: The report was not completed. An error occurred while executing it. com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632) at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:494) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:167) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1087) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:668) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:490) at sun.reflect.GeneratedMethodAccessor2209.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80) at com.jaspersoft.ji.license.LicenseCheckAspect.runReport(LicenseCheckAspect.java:140)
com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) The job error notification was not completed. An error occurred while sending it. org.springframework.mail.MailSendException: Mail server connection failed; nested exception is javax.mail.MessagingException: Could not connect to SMTP host: mail.localhost.com, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect. Failed messages: javax.mail.MessagingException: Could not connect to SMTP host: mail.localhost.com, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect; message exception details (1) are: Failed message 1: javax.mail.MessagingException: Could not connect to SMTP host: mail.localhost.com, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1282) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370) at javax.mail.Service.connect(Service.java:275) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:389) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:340) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:336) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl.sendMailNotification(ReportExecutionJobMailNotificationImpl.java:123) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:942) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:556) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:48) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) Caused by: java.net.ConnectException: Connection refused: connect at java.net.DualStackPlainSocketImpl.connect0(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at java.net.Socket.connect(Socket.java:538) at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:232) at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:189) at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1250) ... 12 more
Also errors as below seen in jasperserver logs
An error has occurred. Please contact your system administrator. (6632)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1250)
... 12 more
2020-06-30 09:00:00,918 ERROR Validator,quartzScheduler_Worker-1:493 - Invalid SQL:An error has occurred. Please contact your system administrator. (6632), SQL: declare @start date = DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) - 1, 0)
declare @end date = DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0)
Release : 9.0.2
Component : UIM - UNIFIED REPORTER
Please follow the below steps to resolve the issue :
1. Deactivate UMP wasp
2. Login to the UMP machine
3. Copy the jars ump_unifiedreports-9.1.0.jar and DroidSans.jar from the location
~\Nimsoft\probes\service\wasp\webapps\unifiedreports\WEB-INF\lib
4. Paste those jars to the location
~\Nimsoft\probes\service\wasp\webapps\reportscheduler\WEB-INF\lib
5. Also do below configuration changes (Below configuration prevents the database from validating the queries of the reports.)
a. Go to below file location and take a backup of the file "security-config.properties"
~\Nimsoft\probes\service\wasp\webapps\jasperserver-pro\WEB-INF\classes\esapi\security-config.properties
b. update the below setting to false
security.validation.sql.on=false
6.Clear work folder under wasp
7. Activate the wasp probe.