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 - Platform due to some unforeseen circumstances (for example, TrueSight Smart Reporting - Platform is uninstalled) , you can clean the TrueSight Smart Reporting - Platform entries from TrueSight Server Automation - Data Warehouse.
Perform the following steps on TrueSight Server Automation - Data Warehouse database:
- Log in to the TrueSight Server Automation - Data Warehouse database.
Update the ReportingURL property in System_property table by using the following syntax:
update system_property
SET VALUE = 'BLANK'
WHERE NAME = 'ReportingURL'Delete the componentId row from the System_property table by using the following syntax:
DELETE from system_property
WHERE NAME = 'componentId';- Commit the changes.
Restart the TrueSight Server Automation - Data Warehouse service.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*