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.
Upgrade from DLP 12.5 to DLP 14.0 or 15.0
No Specific error message. However, Cube processing did not complete successfully
Corrupted Oracle client on the SQL server and/or incorrect data source account.
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:
Go to the SQL Server where IT Analytics is installed
Under Security>Logins, right-click on logins create a new Login
Give it a notable name, check SQL server authentication, and set its default database to the SEM5 (ITA for SEP) database
Choose Server Roles>Select Public
Choose User Mapping>Choose the SEM5 database, and choose Public and db_datareader
Go to Status, make sure the account is enabled and save changes.
No, go back to the IT Analytics Server and Configure the connection to your SEP database using the credentials just created.
You will have a successful connection.
Subscribing will provide email updates when this Article is updated. Login is required.