Error "Unable to update data source for Transactional Reports sdm_ds" when integrating Jasper 7.9 with SDM 17.3

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

Error:

When trying to integrate Jasper 7.9 with SDM 17.3 across any RU patch update, the following error appears during the integration wizard:

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:537) ~[smsi.jar:17.3.0-SNAPSHOT-265.265]
 at com.ca.smsi.installcore.util.JasperServerHelper.configureCABI(JasperServerHelper.java:404) ~[smsi.jar:17.3.0-SNAPSHOT-265.265]
 at com.ca.smsi.installui.tasks.JasperServerConfigTask.configureCABI(JasperServerConfigTask.java:170) ~[smsi.jar:17.3.0-SNAPSHOT-265.265]
 at com.ca.smsi.installui.tasks.JasperServerConfigTask.run(JasperServerConfigTask.java:69) [smsi.jar:17.3.0-SNAPSHOT-265.265]
 at com.ca.smsi.wizard.task.Task.start(Task.java:240) [smsi.jar:17.3.0-SNAPSHOT-265.265]
 at com.ca.smsi.installcore.DeployThread.run(DeployThread.java:1321) [smsi.jar:17.3.0-SNAPSHOT-265.265]
DEBUG [DeployThread: Configuring CABI JasperReports Server ] [ProgressPage] ProgressPage - Task Changed Configuring CABI JasperReports Server 

 

 

Environment

Release : 17.3 and higher

Component : SDM - Reporting/BOXI/JasperSoft

Cause

Unknown

Resolution

Use lowercases for the SDM Privileged user and FQDN for the SDM Web Host