Target host is null error when running the User Authorization for CA SDM report in Jaspersoft 6.3 in an SSL environment

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

After setting up CABI over SSL, when the serverURL value is set to the HTTPS URL of Jasper server,  the userAuthorization report fails with error: 

The server has encountered an error. Please excuse the inconvenience.  
Error Message  
java.lang.IllegalStateException: Target host is null 
 

When the same serverURL is set to an HTTP URL of Jasperserver, the report works fine. 

Environment

Release:
Component: SMJSPR

Resolution

Jasper server certificate needs to be imported into Jasper's Java layers installed here

1) C:\Program Files\CA\SC\CA Business Intelligence\jre\lib\security\cacerts  AND

2) C:\Program Files\CA\SC\CA Business Intelligence\java\lib\security\cacerts


The above are the 2 keystores to which Jasper's SSL certificates need to imported to. Here are the steps:

1) Backup the original cacerts keystores in both folders first

2) Copy Jasper SSL certificate to C:\foo.cer

3) Open a Windows Command Prompt and change directory to here

"C:\Program Files\CA\SC\CA Business Intelligence\jre\bin"

4) Type command: 

keytool -import -alias <alias> -file C:\foo.cer -keystore "..\..\java\lib\security\cacerts" -storepass changeit

Note: changeit is the default password for the cacerts keystore and the <alias> can be anything unique 

5) Ensure the command ran without any errors

6) Next change directory in the Command Prompt to here "C:\Program Files\CA\SC\CA Business Intelligence\java\bin"

7) Type command: 

keytool -import -alias <alias> -file C:\foo.cer -keystore "..\..\java\lib\security\cacerts" -storepass changeit

Note: changeit is the default password for the cacerts keystore and the <alias> can be anything unique

8) Restart CABI Tomcat