When attempting to run a query in Jaspersoft Studio, an error comes back: "Error preparing statement for executing the report query". In the jasperserver.log file, the following errors may be noted:
2018-06-13 13:54:21,331 ERROR MetaDataServiceImpl,http-nio-8080-exec-2:89 [PPMSERVER_dev|dev_user] - Connection Error.Cannot get bean datasource connection:java.lang.reflect.InvocationTargetException
2018-06-13 13:54:21,331 ERROR MetaDataServiceImpl,http-nio-8080-exec-2:89 [PPMSERVER_dev|dev_user] - Connection Error.Cannot get bean datasource connection:java.lang.reflect.InvocationTargetException
Release: All
Component: Clarity Jaspersoft
This problem may be caused by the parameters on the jasperadmin user in Jaspersoft being out of sync with Clarity
Remove all attributes for the japseradmin user in Jaspersoft Server:
admin update jasperParameters
This will resync the proper attributes for the user in Jaspersoft Server, and should resolve the issue.