Share This:

TrueSight Smart Reporting for Server Automation (TSSR-SA) 19.2 Patch 2 released on February 27th, 2020.

 

The official product version is TSSR-SA 19.2.02. As of July 9 2020, 19.2 Patch 2 is still the latest version and this blog posting will be updated after the next release in August 2020.

 

TSSR-SA is the Smart Reporting solution for Truesight Server Automation (TSSA) environments and is the replacement product for BDSSA which reached its End-Of-Life in August 2019.

 

The TSSR-SA solution consists of two main products which currently use different versioning schemes. Although documented, this can sometimes result in confusion around which versions of the product components are compatible and should be downloaded and installed together for a valid TSSR-SA solution installation.

 

The goals of this month’s blog are to clarify details around:

 

  1. Which products make up the TSSR-SA 19.2.02 solution.
  2. Which versions of the constituent products are compatible.
  3. Which versions of TSSA are compatible with TSSR-SA 19.2.02
  4. Which files should be downloaded from the BMC EPD site in order to install or upgrade to TSSR-SA 19.2.02
  5. When to follow the documented install path vs the upgrade path

 

All of this information can be found in the official product documentation and documentation links will be provided when referenced.

 

Since some of this information exists in the TSSR-SA documentation space and some exists in the TSSR Platform documentation space, this blog aims to help avoid confusion by highlighting the most important information in one single place.

 

As a first step, its a good idea to read Sean Berry's TrueSight Smart Reporting (TSSR, BDSSA) FAQ blog posting which is a higher level introduction to Truesight Smart Reporting for Server Automation.

 

Thanks,


John O’Toole

Principal Technical Supp Analyst

BMC Software Customer Support

 

 

 

1. What products make up the TSSR-SA Smart Reporting Solution?

 

 

TSSR-SA consists of two main constituent products:

  • TrueSight Server Automation - Data Warehouse (TSSA-DW)
  • TrueSight Smart Reporting – Platform (TSSR Platform)

 

 

The product version information for TSSR-SA 19.2.02, as listed in the Release Notes, is as follows:

 

 

TrueSight Smart Reporting for Server Automation 19.2.02 (Solution)

Component

Version

TrueSight Server Automation - Data Warehouse

8.9.04.004

TrueSight Smart Reporting - Platform

20.02

 

 

For completeness, this can be compared with the product version information for TSSR-SA 19.02.01 (Patch 1) which released in December 2019:

 

 

TrueSight Smart Reporting for Server Automation 19.2.01 (Solution)

Component

Version

TrueSight Server Automation - Data Warehouse

8.9.04.003

TrueSight Smart Reporting - Platform

19.3

 

And with TSSR-SA 19.2 which released in July 2019:

 

TrueSight Smart Reporting for Server Automation 19.2. (Solution)

Component

Version

TrueSight Server Automation - Data Warehouse

8.9.04.002

TrueSight Smart Reporting - Platform

19.2

 

 

 

2. Which versions of TSA-DW are compatible with which versions of TSSR Platform?

 

 

This information can be found in the TSSR-SA 19.2.02 Release Notes:

 

 

 

 

As we can see here, in a valid TSSR-SA environment, there is a tight relationship between the versions of TSA-DW and TSSR Platform.

 

When downloading the TSSA-DW and TSSR Platform installers, it is important that compatible versions are downloaded.

 

 
3. Which versions of TrueSight Server Automation (TSSA) are compatible with which versions of TSSR-SA?

 

This information can also be found in the TSSR-SA 19.2.02 Release Notes:

 

Compatibility with TrueSight Server Automation

The following versions of TrueSight Server Automation are supported with TrueSight Server Automation - Data Warehouse:

  • BMC Server Automation 8.9.0.x and 8.9.02
  • TrueSight Server Automation 8.9.03.x, 8.9.04.x, and 20.02

 

So, every version of TSSR-SA 19.2.X is compatible with every version of BSA/TSSA 8.9.X and TSSA 20.02

 

The version numbers of TSSA and TSA-DW are not tightly coupled i.e. if an environment is currently running TSSA 8.9.03 the version of TSA-DW installed does not need to match.

 

What is important is that the version of TSA-DW installed is compatible with the corresponding version of TSSR-Platform. (see previous compatibility matrix)

 

For example, the following would be a valid combination:

 

TSSA 8.9.03

TSSA-DW 8.9.04 Patch 4          (part of TSSR-SA 19.2.02)

TSSR Platform 20.02                 (part of TSSR-SA 19.2.02)

 

 

4. Which files should I download in order to install a TSSR-SA 19.2.02 environment?

 

As mentioned previously, the TSSR-SA 19.2.02 solution consists of the following product versions:

 

TrueSight Smart Reporting for Server Automation 19.2.02 (Solution)

Component

Version

TrueSight Server Automation - Data Warehouse

8.9.04.004

TrueSight Smart Reporting - Platform

20.02

 

 

Details on which files to download for both TSA-DW 8.9.04.004 and TSSR Platform 20.02 can be found in the “Downloading the Patch” section of the TSSR-SA 19.2.02 release notes.

 

 

 

a) Locating and downloading the installer files for TSSA-DW 8.9.04.004

 

Since TSSA-DW 8.9.04.004 is a patch, the installation files are found under the “Product Patches” tab on EPD as highlighted below:

 

 

 

From here, we navigate to the TSSA-DW 8.9.04 area:

 

 

Under here, the TSSA 8.9.04.004 installation files are all dated 02/27/2020:

 

 

 

b) Locating and downloading the installer files for TSSR Platform 20.02

 

TSSR Platform 20.02 is a full product release so the installation files are found under the “Licensed Products” tab on EPD as highlighted below:

 

 

 

 

 

From here, we download either the Windows or the Linux installer depending on the OS of the TSSR-SA Server:

 

 

 

 

5. Once the installation files are downloaded, which documentation steps do I follow to install or upgrade TSSR-SA 19.2.02?

 

 

The steps to follow depend on whether this is the initial installation of TSSR-SA in the environment or whether a previous version of TSSR-SA (i.e. 19.2, 19.2.01) was previously installed and is now being upgraded to TSSR-SA 19.2.02.

 

 

Scenario A – Installing TSSR-SA for the first time in an environment:

 

This is the initial installation of TSSR-SA in this environment.

 

BDSSA is the TSSA reporting solution currently in use and we want TSSR-SA to use the same Warehouse DB that BDSSA has been using. This is sometimes referred to as a "migration" from BDSSA to TSSR-SA.

 

These are also the steps to follow if neither BDSSA nor TSSR have previously been installed in this environment.

 

In this scenario, we want to follow the Installing section in the TSSR-SA documentation.

 

Since the installation process includes steps from both the TSSA-DW and TSSR Platform documentation spaces, they are listed here in order:

 

  1. Review the TSSR-SA 19.2.02 Release Notes
  2. Review the TSSR-SA 19.2.02 Orientation for BDSSA users
  3. Review the TSSR-SA 19.2.02 Getting Started section
  4. Complete the Planning activities for TSSA-DW. Note: If the TSSA-DW installation will be using the same databases as BDSSA, no new databases or schemas need to be created for TSSA-DW.
  5. Complete the Prepare to install activities for TSSA-DW
  6. Complete the TSSA-DW Installation steps
  7. Complete the TSSA-DW Post-Installation tasks. Note: Step 2 of the Post-Installation tasks is the step where we provide TSSA-DW with the database information for the Warehouse, two ETL databases and the TSSA database.

 

 

As this point, we should have a functioning TSSA-DW installation and should be able to perform an ETL run as mentioned in step 6 of the Post Installation tasks.

 

If ETL is successful, we can continue to the TSSR 20.02 Platform installation which consists of the following steps:

 

8. Complete the TSSR Platform 20.02 Planning activities.

9. Complete the TSSR Platform 20.02 Preparing To Install activities. ( See point 6B below)
10. Complete the TSSR Platform 20.02 Installation steps
11. Complete the TSSR platform 20.02 Post Installation tasks which consists of two main steps:

  1. Adding the TSA-DW Component to TSSR Platform
  2. Configuring TSSR Platform settings

 

 

Scenario B – Upgrading an existing TSSR-SA environment:

 

A previous version of TSSR-SA (19.2 or 19.2.01) has already been installed in this environment and the goal is to upgrade it to TSSR-SA 19.2.02.

 

In this case, we want to follow the Upgrade steps in the TSSR-SA documentation.

 

  1. Review the  TSSR-SA 19.2.02 Release Notes
  2. Review the TSSR-SA 19.2.02 Upgrading page
  3. Complete the TSSA-DW Preparing to upgrade activities
  4. Complete the TSSA-DW Upgrade steps.
  5. Complete the TSSR Platform 20.02 Preparing to upgrade activities
  6. Complete the TSSR Platform 20.02 Upgrade steps
  7. Complete the TSSR-SA 19.2.02 Post-upgrade tasks. These steps are very important in order to avoid post-upgrade performance, resource usage, data-refresh or authentication issues

 

 

6. Important points and common questions/pitfalls

 

This section will be updated as common TSSR-SA 19.0.02 install/upgrade issues and questions are encountered.

 

A) Warehouse DB data condition to check before running TSSA-DW post-installation steps.

 

Make sure step 1 of the TSSA-DW Post-installation steps is followed if this is the initial migration of a BDSSA environment to TSSR-SA. Skipping this step may result in errors during the Warehouse DB upgrade.

 

"If you are performing the initial migration of BMC Decision Support for Server Automation warehouse to TrueSight Server Automation - Data Warehouse, you must run a diagnostic SQL query to verify that the version of BMC Decision Support for Server Automation warehouse is as expected. For more information, see this knowledge article"

 

 

 

B) Creating the TSSR Repository DB/Schema

 

When doing a fresh installation of TSSR-SA in an environment where BDSSA is currently installed, and the same Warehouse and ETL DBs are to be used by TSSR-SA, there can sometimes be confusion around the new TSSR Repository DB which TSSR Platform uses to store information such as metadata, users, and user permissions for reports.

 

Unlike the Warehouse and ETL DBs, this is not a DB which was present or used by BDSSA. This is a net-new DB required by TSSR Platform.

 

Oracle Environments:

For Oracle DB environments, the TSSR Repository user must be created in advance of running the TSSR Platform installer.

The installer is then provided with the DB connection information. See the "Setting up Oracle as the repository database" section of the Setting up the TSSR Repository Database page.

This page contains details on creating the Oracle TSSR Repository user, the tablespace (if a separate tablespace is preferred) and granting the required privileges.

 

 

SQL Server Environments:

For SQL Server environments, the user can choose whether to create the TSSR Repository DB and user in advance of running the TSSR Platform installer or to allow the installer to create the TSSR Repository DB and user.

 

If the option to have the installer create the DB and User is selected, then the installer requires Database Administrator credentials to be provided so that these tasks can be completed.

If the option to create the DB and User manually in advance is selected, then Database Administrator credentials will not be required by the installer.