Unable to delete TrueSight Smart Reporting entries

You cannot delete the component from TrueSight Smart Reporting - Platform and you get the following error message:

To resolve this issue, clean the TrueSight Smart Reporting - Platform entries from TrueSight Server Automation - Data Warehouse.

Do the following 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.

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

   For Linux operating system, perform the following steps:

   1. Navigate to the /etc/init.d directory.

   2. Type the following commands:

      ./bltomcat stop
      ./bltomcat 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.