Error loading the data source connections page

Products

• IT Analytics

Issue/Introduction

The following error is displayed when trying to access the Data Sources settings page in the IT Analytics (ITA) console:

Exception: Index was outside the bounds of the array.

Environment

Release : 2.9.1

Component : Symantec DLP Content Pack

Cause

This is caused by the use of a DLP database server's TNS name in lieu of its server hostname in the EZCONNECT string compiled by the ITA data source connection wizard. Per the IT Analytics Symantec Data Loss Prevention Connection Wizard:

This wizard creates a connection between IT Analytics and a Symantec Data Loss Prevention database to be used as the source for cube data. Verify the EZCONNECT name for the Symantec Data Loss Prevention Database, and press Next to begin configuration of the connection.

Emphasis added.

Resolution

To correct this error, delete the DLP linked server in SQL Server Management Studio (SSMS), then re-run the IT Analytics Symantec Data Loss Prevention Connection Wizard. Do not provide the TNS name for the Oracle Host Name. Instead, provide the server's hostname or IP address.

Additional Information

Oracle Net Services Administrator's Guide: Configuring the Easy Connect Naming Method