UIM - Unified Reporter did not send out the scheduled reports after upgrade

book

Article ID: 196319

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

UR custom reports failed to run and also scheduled reports not working after UR upgrade from 8.51 to 9.02 

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)

Environment

Release : 9.0.2

Component : UIM - UNIFIED REPORTER

Resolution

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.

 

 

Additional Information

UIM- Unified Reporter failed to start with security check error