Troubleshooting common issues

This topic contains information about troubleshooting the issues encountered while using TrueSight Network Automation Reporting.

Unable to log in to the TrueSight Network Automation - Data Warehouse console even if the credentials are correct

Issue

You cannot log in to the TrueSight Network Automation - Data Warehouse console even if the credentials are correct. This issue occurs in the following conditions:

1. If all the required TrueSight Network Automation sites are not running.
2. If you move the TrueSight Network Automation database from one server to another, in which case the Site URL system parameter becomes invalid.

Workaround

Do the following:

1. Ensure that all the Network Automation sites are running.
2. Log on to the Network Automation application server for the site.
3. Go to Admin > System Parameters.
4. Modify the Site URL parameter as required.
5. Run ETL for the required sites.

TrueSight Network Automation - Data Warehouse cannot be added as a component if deleted forcefully

Issue

If you delete the TrueSight Network Automation - Data Warehouse component from TrueSight Smart Reporting - Platform forcefully when the Network Automation - Data Warehouse service is not running, you cannot add the component again.

Workaround

Do the following:

1. Connect to the data warehouse database.

2. Run the following commands to delete the component-related entries.

   delete from system_property where name = 'componentId';
   delete from system_property where name = 'Reporting_URL'; 

A site does not get added, once deleted

Issue

If you delete a site using the Site Manager utility and then try to add it again, the utility displays the following error message:

site with same GUID already exist and addition of site with same GUID not allowed.

Workaround

Do the following:

1. Access the database server, and then connect to the data warehouse.
2. In the Sites table, set the value of the site_deleted column to 0 for the site that you want to add again by using the following command:
   UPDATE sites SET SITE_DELETED = 0 WHERE site_id = <siteID>;
3. Run ETL.

ETL lock file does not get deleted in case of system failure

Issue

If ETL is running and the system fails, the etl.lck file does not get deleted automatically from the <TSNADW_INSTALL_DIR>\bin\bna\dwh\xml directory. As a result, you cannot run the ETL again.

Workaround

Delete the etl.lck file manually before running the ETL again.

Duplicate data in reports

Issue

You see duplicate data in reports after you move from TrueSight Network Automation - Data Warehouse to TrueSight Network Automation Reporting. This issue can occur if you are running ETL both for Network Automation - Data Warehouse and BMC Decision Support – Network Automation.

Workaround

Disable the ETL for BMC Decision Support – Network Automation.