Error Spectrum report - Service Summary by Service Name

Products

• CA eHealth
• CA Spectrum

Issue/Introduction

After enter the report parameters, and click OK, an error message is displayed:  There was an error on the server. Try again or contact site administrators. (Error UID: c74a30de-4dd0-4db2-bd25-d9333b6d1026)

 

 

 

The problem affects this specific report only, and it can be reproduced with any Jasper user.

Cause

Next message can be observed in <CABI_ROOT_DIRECTORY>/apache-tomcat/webapps/jasperserver-pro/WEB-INF/logs/jasperserver.log

############################

2019-11-11 19:24:26,073 ERROR ErrorPageHandlerAction,http-nio-8080-exec-2:118 - Error UID c74a30de-4dd0-4db2-bd25-d9333b6d1026

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Service Summary Report.

...

Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'model_customers.landscape_h' in 'on clause'

############################

The problem is on the query executed by the report, specifically when the Enable Security is set to True, in Report Manager preferences.

When this occurs, a new JOIN is added to the query, which causes this problem.

Environment

Release : 10.4

Component : Spectrum Core / SpectroSERVER

Release: 6.4.3

Componente: CABI

Resolution

It has been detected by Sustaining Engineering that the report query needs to be modified. This correction will be included in first Spectrum 10.4 BMP, which is planned to be released in mid December 2019.

Additional Information

DEFECT: DE439740