When attempting to create an "Ad Hoc View" in the Jasper Report Server Console we face the below error:
The server has encountered an error. Please excuse the inconvenience.
Error Message
Error preparing statement for executing the report query: SELECT DISTINCT CASE WHEN UPPER('
[email protected]') LIKE '%ORACLE%' THEN 'CM_CONFIGURATION_ITEM_METRIC_D' ELSE 'CM_CONFIGURATION_ITEM_METRIC_DEFINITION' END AS ccimd FROM s_qos_data
Steps taken to reproduce the error:
1. Access the CABI JRS Web Console using superuser account.
2. Create New Ad Hoc View
3. Select the UIM Metrics Topic
4. The error occurs here before the input screen pops up.
The problem can be resolved by restarting the "CA Business Intelligence Tomcat" service OR logging out and accessing the JRS again via the superuser account.