search cancel

The installation "Configuring CABI JasperReports Server" fails.

book

Article ID: 229061

calendar_today

Updated On:

Products

CA Service Desk Manager

Issue/Introduction

The installation "Configuring CABI JasperReports Server" fails.
Error in install.log:

2021/11/16 10.48.11.719 DEBUG [DeployThread: Configuring CABI JasperReports Server ] [JasperServerHelper] Rest URI HTTP://sdm:8081/jasperserver-pro/rest_v2/resources/organizations/casm_insights/SDM/Transactional/datasources/sdm_ds
2021/11/16 10.48.11.958 ERROR [DeployThread: Configuring CABI JasperReports Server ] [JasperServerHelper] Unable to update data source for Transactional Reports  sdm_ds Response code : 500
2021/11/16 10.48.11.959 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-243.243]
 at com.ca.smsi.installcore.util.JasperServerHelper.configureCABI(JasperServerHelper.java:404) ~[smsi.jar:17.3.0-SNAPSHOT-243.243]
 at com.ca.smsi.installui.tasks.JasperServerConfigTask.configureCABI(JasperServerConfigTask.java:170) ~[smsi.jar:17.3.0-SNAPSHOT-243.243]
 at com.ca.smsi.installui.tasks.JasperServerConfigTask.run(JasperServerConfigTask.java:69) [smsi.jar:17.3.0-SNAPSHOT-243.243]
 at com.ca.smsi.wizard.task.Task.start(Task.java:240) [smsi.jar:17.3.0-SNAPSHOT-243.243]
 at com.ca.smsi.installcore.DeployThread.run(DeployThread.java:1321) [smsi.jar:17.3.0-SNAPSHOT-243.243]

We followed the steps from 
https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/installing/installing-ca-service-management-17-3/installing-common-components-ca-eem-cabi-jasperreports-ca-process-automation/cabi-jasperreports-server-for-ca-service-management/Install-and-Integrate-JasperReports-Server-r7-2-with-CA-Service-Management-17-3-0-10.html


STEPS TO REPRODUCE
-----------------------
1. RU10 is installed
2. Install JasperReports Server 7.9 (PostgresSQL)
3. copy the 'jasperserver.license' from CA Service Management 17.3.0.10
4. Increase the Password field length from 250 to 500 characters in JasperReports Server.
5. "Integrate CABI JasperReports Server with CA Service Management " option in the CA Service Management Common Installer

 

 

Environment

Release : 17.3 Ru10/ Jasper 7.9

 

Resolution

# Checked etc\host updated it with Jasper server IP and hostname details:
# Ipconfig show client configure ipv4 & ipv6 ipaddress. 
#Tried to perform the Pre-install steps
Copy the jar files from the CA Service Management 17.3.0.10 extracted location. Navigate to CASM 17.3.0.10 extracted location  \filestore\Jasper\7.2 or 7.9\ ExternalAuthJars and copy the following:
BOPintegration.jar
cabi-jasperreportsserver-commonutil.jar
cabi-jasperreportsserver-dynamicjdbc.jar
cabi-jasperreportsserver-rolebasedflow.jar
cabi-jasperreportsserver-sso.jar
cabi-jasperreportsserver-userlocate.jar
cabi-jasperreportsserver-versionapi.jar
sd-utils.jar
slump.jar
domsrvr_utils.jar

#  Paste the above jar files to where you have installed JasperServer Reports 7.2 or 7.9.
For example: C:\Jaspersoft\jasperreports-server-7.2 or 7.9\apache-tomcat\webapps\jasperserver-pro\WEB-INF\lib
#  Take a backup of the following xml files from ..\Jaspersoft\jasperreports-server-7.2 or 7.9\apache-tomcat\webapps\jasperserver-pro\WEB-INF:
applicationContext.xml
applicationContext-externalAuth-template-mt.xml
applicationContext-rest-services.xml
applicationContext-security.xml
applicationContext-security-web.xml
applicationContext-semanticLayer.xml
applicationContext-jdbc-metadata.xml
#  Copy the below XML files from CA Service Management 17.3.0.10 extracted location, \filestore\Jasper\7.2 or 7.9\ExternalAuthXMLs:
applicationContext.xml
applicationContext-externalAuth-template-mt.xml
applicationContext-rest-services.xml
applicationContext-security.xml
applicationContext-security-web.xml
applicationContext-semanticLayer.xml
applicationContext-jdbc-metadata.xml
#  Paste it in the location: \Jaspersoft\jasperreports-server-7.2.0 or 7.9\apache-tomcat\webapps\jasperserver-pro\WEB-INF.
#  Restart Jasper Tomcat Services.
# Add contactUUID for superuser: Perform the following steps:
From JasperSoft Reports 7.2 or 7.9, go to Manage Users, select superuser, click Edit, select Attributes, Click Add New Attribute.
  Provide the Name field as contactUUID and click Ok.
  Click Save.

# Checked the password strength It was set to 504: 

UPDATE pg_attribute SET atttypmod = 500+4
WHERE attrelid = 'jijdbcdatasource'::regclass
AND attname = 'password';

# Restarted Apache tomcat services for Jaspersoft & Restarted SDM services. 
#tomcat8w.exe //ES//jasperreportsTomcat  -Java-> add  -Djava.net.preferIPv4Stack=true
# Restart all the services..