search cancel

Cannot fetch a row from OLE DB provider during processing


Article ID: 252878


Updated On:


Information Centric Analytics


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".


Release : 6.x

Component : Oracle Database Client


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