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.
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.
Release : 10.4
Component : Spectrum Core / SpectroSERVER
Release: 6.4.3
Componente: CABI
DEFECT: DE439740