USM Trend report reportscheduler portlet error-> UNABLE TO GENERATE REPORT!

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

reportscheduler portlet generates an error

Environment

- UMP 9.1.0

Cause

- Two .jar files were missing - each from a different location under the wasp directory

Resolution

Excerpt from the error log:

Started job at scheduled time on Monday, August 19, 2019 at 10:04:36 AM.

Generating Analysis Report "TestReport1" containing data from Sunday, August 18, 2019 at 10:04:36 AM to Monday, August 19, 2019 at 10:04:36 AM.

UNABLE TO GENERATE REPORT! The following error occurred : net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:

Resource cannot be resolved

value = new SimpleDateFormat(Resource.get("MM/dd/yyyy hh:mm:ss a", ((java.util.Locale)parameter_REPORT_LOCALE.getValue())), ((java.util.Locale)parameter_REPORT_LOCALE.getValue()));//dateFormat; //$JR_EXPR_ID=5$

etc...

The solution is more of a configuration change wherein you are just copying 2 files to another location, and it then the reportscheduler and the trend report work without any more errors/issues.

Deactivate UMP wasp
RDP to the UMP machine
Copy the jars ump_unifiedreports-9.1.0.jar and DroidSans.jar from the location:

...\Nimsoft\probes\service\wasp\webapps\unifiedreports\WEB-INF\lib

Paste those jars to the location

...\Nimsoft\probes\service\wasp\webapps\reportscheduler\WEB-INF\lib

Activate the wasp probe and wait until it has a port and a PID.
Generate a Trend report and save it.
Schedule it for email delivery/store on server

Example output:

Started job at scheduled time on Thursday, August 22, 2019 at 5:51:22 PM.

Generating Analysis Report "TestReport3" containing data from Wednesday, August 21, 2019 at 5:51:22 PM to Thursday, August 22, 2019 at 5:51:22 PM.

Successfully generated report in 5.284 seconds.

Emailing generated report to the following recipient(s) "[email protected]" with subject "Testing"

Successfully emailed report in 1.298 seconds.

Job finished on Thursday, August 22, 2019 at 5:51:29 PM taking 6.582 seconds to run.

2nd example with storing on the server selected.

Started job on Thursday, August 22, 2019 at 6:00:10 PM. Job was scheduled to run job on Thursday, August 22, 2019 at 6:00:10 PM.

Generating Analysis Report "LastReport" containing data from Wednesday, August 21, 2019 at 6:00:10 PM to Thursday, August 22, 2019 at 6:00:10 PM.

Successfully generated report in 0.908 seconds.

Emailing generated report to the following recipient(s) "[email protected]" with subject "Last Report YEAH"

Successfully emailed report in 2.473 seconds.

Storing generated report with file name "LastReport_20190822_150010.pdf" at this location "C:\Program Files (x86)\Nimsoft\probes\service\wasp\webapps\reportscheduler\archive\" on the server.

Successfully stored report with file name "LastReport_20190822_150010.pdf" on the server in 0.028 seconds.

Job finished on Thursday, August 22, 2019 at 6:00:13 PM taking 3.409 seconds to run.

Additional Information

The process outlined above may also be used to resolve an error when trying to run the USM Group ‘Trend Report’, “An Unknown Error has Occurred.”