Skip to Content

Installation and upgrade issues

Refer to the following topics to troubleshoot problems that might occur during installing or upgrading TrueSight Smart Reporting - Platform.

Unable to access TrueSight Smart Reporting after an upgrade

You have upgraded TrueSight Smart Reporting - Platform to the latest version, and the upgrade is successful. However, when you access TrueSight Smart Reporting - Platform, you encounter errors. If you try to run the upgrade again, you cannot access TrueSight Smart Reporting - Platform and some database-related errors are displayed.

Solution

After upgrading TrueSight Smart Reporting - Platform once, do not run the upgrade again. Restart the TrueSightSmartReporting service to avoid this issue.

Unable to install TrueSight Smart Reporting on Windows because of a database error

If you are installing TrueSight Smart Reporting - Platform by using the SQL Server database and the authentication mode is Windows, you might see the following message, and the installation does not proceed:

An error occurred during installation:
com.hof.dbtool.DBException: Error executing update
ERR_UPDATEQUERY
Query:

ALTER AUTHORIZATION ON database:yellowfin TO <domain name>\<login name>

Solution

  1. Manually create the database.
  2. In the command line interface, run the following command:
    alter authorization on database::yellowfin TO "<domain name>\<login name>"
  3. Launch the installer and start the installation process.
  4. While entering the database details, clear the Create new database check box.
  5. Enter the details of the database that you manually created.
  6. Complete the installation process.

Unable to view the TrueSightSmartReporting service

After installing TrueSight Smart Reporting - Platform, you might not be able to view the TrueSightSmartReporting service. This can happen because of one or more of the following reasons:

  • The JAVA_HOME path is not set correctly.
  • The Install Windows service option was not selected during the TrueSight Smart Reporting - Platform installation.

Solution

Create a service for TrueSight Smart Reporting - Platform. Do the following:

  1. On the computer where you installed TrueSight Smart Reporting - Platform, set the JAVA_HOME variable to point to the JDK.
  2. Navigate to the following directory and open the command prompt
    <installation directory>\appserver\bin.
  3. Run the following command:
    service.bat install TrueSightSmartReporting

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

TrueSight Smart Reporting for Server Automation 19.01