ITA - Unable to Connect to Data Source After DLP Upgrade or Install

Products

• IT Analytics

Issue/Introduction

After upgrading a standalone DLP environment from 12.5 to 14.0 and 15.0, IT Analytics was not able to connect to the DLP Oracle database.

No Specific error message.  However, Cube processing did not complete successfully

Environment

Upgrade from DLP 12.5 to DLP 14.0 or 15.0

Cause

Corrupted Oracle client on the SQL server and/or incorrect data source account.

Resolution

Solution 1: Re-installing the Oracle agent and tools on the SQL server resolved the issue.

Solution 2:  Creating a new SQL account to access the data source solved the issue.  In the below example, we were connecting to SEP, but the CMDB, or Processmanager for Servicedesk, or others could be used.  To do this:

1. Go to the SQL Server where IT Analytics is installed
2. Under Security>Logins, right-click on logins create a new Login
3. Give it a notable name, check SQL server authentication, and set its default database to the SEM5 (ITA for SEP) database
4. Choose Server Roles>Select Public
5. Choose User Mapping>Choose the SEM5 database, and choose Public and db_datareader
6. Go to Status, make sure the account is enabled and save changes.
7. No, go back to the IT Analytics Server and Configure the connection to your SEP database using the credentials just created.
8. You will have a  successful connection.