OnCommand Unified Manager fails to import report
Applies to
- Oncommand Unified Manager versions prior to 9.6
Issue
An error is reported when OnCommand Unified Manager (UM) attempts to import a report from Business Intelligence and Reporting Tools (BIRT):
Failed to import report. Error occurred while validating the report. Connection cannot be established, check "Connection URL" or "Username" or "Password" provided in the report designfile. See log for more details.
In the ocumserver.log, errors similar to below may be seen
.2019-08-16 10:38:15,003 INFO [admin] [default task-11] [c.n.d.i.r.BirtReportRestService]Received responseCode 403 for urlhttps://xx.xx.xx.xx:443/um/actuatejavacomponent/report/report_name.rptdesign?report_design_directory_path=/tmp
2019-08-16 10:38:15,009 ERROR [admin] [default task-11] [c.n.d.w.s.r.ReportImportServlet]Failed to import report. Error occurred while validating the report. Connection cannot beestablished, check "Connection URL" or "Username" or "Password" provided in the report designfile. See log for more details.com.netapp.dfm.impl.report.ReportServiceException: Error occurred while validating the report.Connection cannot be established, check "Connection URL" or "Username" or "Password"provided in the report design file. See log for more details
In the ocum-report.log, errors similar to below may be seen:
2019-08-16 10:38:14 [ERROR] [default task-21] [ReportGenerator:170] - BIRT error whilegenerating report in csv format: org.eclipse.birt.report.engine.api.EngineException: The task iscancelled.; org.eclipse.birt.report.engine.api.EngineException: An exception occurred duringprocessing. Please see the following message for details:Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc. org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class:com.mysql.jdbc.NonRegisteringDriver.