Error loading the data source connections page
search cancel

Error loading the data source connections page

book

Article ID: 238289

calendar_today

Updated On:

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