UIM dashboards are not working. Running them as superuser gives: An unexpected error occurred while retrieving data, Please check the user access privileges or run as a different user.
Running a report instead of a dashboard gives: org.xml.sax.SAXParseException; lineNumber: 48; columnNumber: 19; Error at line 48 char 19: No query executer factory registered for the "dynamic" language.
Getting the following error message in the jasperserver.log file:
Failed to decrypt
The reason for the issue is, UIM JNDI datasource connection database password encryption got corrupted.
CABI Jasper 6.3.0 installed for Spectrum
Updated the connection details in <C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\META-INF>\context.xml file of CABI and used plain database password.