When configuring Smart Reporting url in Midtier Configuration page, results in error

"Not able to Connect to Provided Smart Reporting URL"

This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

When Smart Reporting or Smart Reporting LB is configured to work with HTTPS, the reporting certificate needs to be added on the Mid-Tier java trust store.  Attached the documentation for same.

Configuration for Mid-Tier to enable the Smart Reporting SSL:

[Note: As the below steps are the Mid-Tier Configuration, this will need Mid-Tier Application Server restart]

1. Enable Smart Reporting Tomcat App Server with SSL using standard Tomcat SSL Configuration
2. Open Browser, navigate to Smart Reporting secured URL, and test SSL works using https://<SR_HostName>:<PORT>

For example: https://10.133.71.251:9443/

1. Click on ,
   1. View Site Information from URL Address bar à Go to Connection à Certification Information à Details à Copy to file à Next à Select Base-64 encoded X.509 (.CER) à Next à Provide the Certification name and save .cer file and keep this handy

For example: Reporting.cer

1. Go to Midtier tomcat server JAVA location.

For example: C:\Program Files\Java\jre1.8.0_65\lib\security
                And copy the Reporting.cer collected from JAVA path to above location.
 

1. Now go to JAVA Directory to execute the Keytool.exe for enabling the trusted keystore between the Reporting and Midtier server:

If customer is using a custom JRE instance, they need to ensure CA Certs are also updated in the Java > jre > lib > security folder in addition to the standard Java > lib > security folder

For example:

1. Open Command Prompt, navigate to à C:\Program Files\Java\jre1.8.0_65\bin>
2. Run command C:\Program Files\Java\jre1.8.0_65\bin>keytool -import -keystore "C:\Program Files\Java\jre1.8.0_65\lib\security\cacerts" -file "C:\Program Files\Java\jre1.8.0_65\lib\security\Reporting.cer"
3. Enter password : changeit <default>
4. Once this command run successfully, below results should be observed
5.  Make sure the cacerts file gets modified by checking the Date Modified once the step 5.d went      successful.

 

1.  Go to services and Restart the Mid-Tier tomcat Server
2. Make sure the https smart reporting URL is configured in Mid-Tier Report Setting configuration
3. Smart Reporting cross launch from Mid-Tier should work.

In case Smart Reporting is configure behind load balancer where SSL is configured only on load balancer, then it's mandatory to update the LB port (i.e proxy port) into Smart Reporting server.xml file as shown below