When trying to integrate CABI JasperReports Server with Service Management, the following error appears in the logs:
ERROR [DeployThread: Configuring CABI JasperReports Server ] [JasperServerConfigTask] CABI JasperReports Server configuration Task failed for : [] with error :
java.lang.Exception: Unable to update data source for Transactional Reports sdm_ds, refer logs for more details.
at com.ca.smsi.installcore.util.JasperServerHelper.updateDataSourceforTransReports(JasperServerHelper.java:496)
at com.ca.smsi.installcore.util.JasperServerHelper.configureCABI(JasperServerHelper.java:368)
at com.ca.smsi.installui.tasks.JasperServerConfigTask.configureCABI(JasperServerConfigTask.java:148)
at com.ca.smsi.installui.tasks.JasperServerConfigTask.run(JasperServerConfigTask.java:66)
at com.ca.smsi.wizard.task.Task.start(Task.java:239)
at com.ca.smsi.installcore.DeployThread.run(DeployThread.java:1309)
Release : 17.3
Pre-requisites to increase the length of the field which stores the password of sdm_ds
Solution
Implement the steps noted under Integration with JasperReports 7.2 – Changes in JasperReports Database
RU 9:
RU 10:
RU 11: