Unable to open TrueSight Smart Reporting from the TrueSight Server Automation - Data Warehouse console

This section lists the issues that you might encounter when accessing TrueSight Smart Reporting - Platform from the TrueSight Server Automation - Data Warehouse console.

Connection fails because the host name or IP address has changed

When you open TrueSight Smart Reporting - Platform from the TrueSight Server Automation - Data Warehouse console, an error appears. This might happen because the TrueSight Smart Reporting - Platform host name or IP address has changed. You must update the changed host name or IP address in TrueSight Server Automation - Data Warehouse. Do the following:

1. Connect to the TrueSight Server Automation - Data Warehouse database as the data warehouse database user.

2. In the System_property table, update the host name or IP address by executing the following query:

   update system_property

   SET VALUE = 'https://<changed hostname or IP>:<port>/'

   WHERE NAME = 'ReportingURL'

   where <changed hostname or IP>  is the updated host name or IP address  for TrueSight Smart Reporting - Platform, and <port> is the port number where TrueSight Smart Reporting - Platform is installed.

3. Commit the database changes.
4. Restart the TrueSight Server Automation - Data Warehouse service.

Connection fails because of a custom certificate

You cannot open TrueSight Smart Reporting - Platform from the TrueSight Server Automation - Data Warehouse console because TrueSight Server Automation - Data Warehouse is configured with a custom certificate.

You must import the TrueSight Server Automation - Data Warehouse custom certificate in the <Smart Reporting install directory>/appserver/conf/tsr.keystore file. Do the following:

1. Stop the TrueSight Smart Reporting - Platform server.
2. Obtain the custom certificate from TrueSight Server Automation - Data Warehouse.

3. Import it in a temporary keystore file by using the following command:

   keytool -importcert -file <certificate file> -keystore tsr.keystore -alias "newtsrkey"

   where "newtsrkey" is the new alias that you create.

   Note: Import all certificates according to their hierarchy

   Ensure that you import all certificates in the order of their hierarchy. Import the parent first, followed by subsequent children.

4. Start the TrueSight Smart Reporting - Platform server.