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

Document ID : KB000118781
Last Modified Date : 31/10/2018
Show Technical Document Details
Issue:
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. 
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