CABI Report - "Input control validation failure" error

Products

• CA Spectrum

Issue/Introduction

When I try to run the "Top-N Devices and Models with the most alarms - group" report, I choose settings as below, then click on "apply", and error is displayed:

Error Message
Input controls validation failure (Error UID: a9dfd504-ad29-4966-9fdd-4c1827530458)

Error Trace
com.jaspersoft.jasperserver.api.ErrorDescriptorException: Input controls validation failure at com.jaspersoft.jasperserver.remote.services.ReportExecution.getFinalReportUnitResult(ReportExecution.java:173) at com.jaspersoft.jasperserver.remote.services.impl.RunReportServiceImpl$2.run(RunReportServiceImpl.java:491) at com.jaspersoft.jasperserver.api.logging.util.LoggableExecutorService$1.run(LoggableExecutorService.java:84) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750)

What's the cause of this and how to fix it?

Cause

Selecting all the alarm types and cause codes will make the SQL query syntax created to be huge, causing the error.

Resolution

Considering you want all the alarm types and cause codes, do not select any manually. They will be displayed by default.