OLE DB error: OLE DB or ODBC error: Cannot initialize the data source object of OLE DB provider

Products

• IT Analytics

Issue/Introduction

IT Analytics (ITA) cube processing jobs fail and return the following error messages in the SQL Server Agent job history:

<Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: Cannot initialize the data source object of OLE DB provider &quot;OraOLEDB.Oracle&quot; for linked server &quot;<linked server name>&quot;.; 42000; The OLE DB provider &quot;OraOLEDB.Oracle&quot; for linked server &quot;<linked server name>&quot; reported an error. The provider did not give any information about the error.; 42000." Source="Microsoft SQL Server 2016 Analysis Services" HelpFile="" />

Environment

Release : 2.9.1

Component : Cubes

Cause

The credentials specified in the linked server definition do not have access to the Symantec DLP database. This can be caused by an incorrect username, password, or locked-out account.

Resolution

Update the linked server definition to use the correct credentials to access the Oracle database:

1. Using SQL Server Management Studio (SSMS), connect to the database engine hosting the ITAnalytics database
2. In Object Explorer, navigate to Server Objects > Linked Servers
3. Right-click the linked server to be updated and select Properties
4. In the Linked Server Properties window, select the Security page
5. On the Security page, select the option Be made using this security context and provide the credentials of a user with confirmed access to the Oracle database
6. Click the OK button to save your changes and close the Linked Server Properties window