Unable to delete TrueSight Smart Reporting entries

If you receive the TSR-SA30005 (The component is already registered.) error message, and you cannot delete the component from TrueSight Smart Reporting due to some unforeseen circumstances (for example, TrueSight Smart Reporting is uninstalled) , you can clean the TrueSight Smart Reporting entries from TrueSight Server Automation - Data Warehouse.

Perform the following steps on TrueSight Server Automation - Data Warehouse database:

1. Log in to the TrueSight Server Automation - Data Warehouse database.

2. Update the ReportingURL property in System_property table by using the following syntax:

   update system_property
   SET VALUE = 'BLANK'
   WHERE NAME = 'ReportingURL'

3. Delete the componentId row from the System_property table by using the following syntax:

   DELETE from system_property
   WHERE NAME = 'componentId';
4. Commit the changes.

5. Restart the TrueSight Server Automation - Data Warehouse service.

   Perform the following steps to restart TrueSight Server Automation - Data Warehouse service.

   For Unix operating system, perform the following steps:

   1. Navigate to the <TSSA-DWInstallationDirectory>/tomcat/bin directory.

   2. Type the following commands:

      ./daemon.sh --java-home $BDS_HOME/jre --tomcat-user root stop
      ./daemon.sh --java-home $BDS_HOME/jre --tomcat-user root start
      

   For Windows operating system, perform the following steps:

   1. From a command prompt, type the following command:

      services.msc
   2. In the Services window, select TrueSight Server Automation - Data Warehouse Web Server and click Restart.