search cancel

Cannot fetch a row from OLE DB provider during processing

book

Article ID: 252878

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

The Information Centric Analytics (ICA) job RiskFabric Processing records a failure on step 4 (Run Staging Procedures) and the following error is logged by the SQL Server Agent:

LogGroupID=n;LogGroupID=n;LogGroupDescription = Staging procedure for SymantecDLP;ErrorDesc=Error Msg: Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "RISKFABRIC_DLP_RISKFABRIC_<host>_PROTECT".

Environment

Release : 6.x

Component : Oracle Database Client

Resolution

To resolve this error, follow this procedure:

  1. Open SQL Server Management Studio (SSMS)
  2. Connect to the Database Engine hosting the RiskFabric database
  3. In Object Explorer, navigate to Server Objects > Linked Servers > Providers
  4. Right-click the provider OraOLEDB.Oracle and select Properties
  5. In the Provider Options window, enable the setting Allow inprocess
  6. Click the OK button to close the Provider Options window
  7. In Object Explorer, right-click the SQL Server hostname and select Restart