search cancel

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

book

Article ID: 229430

calendar_today

Updated On:

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="" />

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.

Environment

Release : 2.9.1

Component : Cubes

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