Cannot fetch a row from OLE DB provider during processing

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

Ensure SQL Server's Remote query timeout setting is disabled:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric relational database
3. In Object Explorer, right-click the server hostname and select Properties
   The Server Properties window opens
4. Select the Connections page
5. Set the Remote query timeout setting to 0

Set the Oracle Client's ChunkSize and FetchSize values in the Windows registry to 200 and 1000, respectively (HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE > KEY_OraClient<version>Home1 > OLEDB)

Ensure the OraOLEDB.Oracle provider option Allow inprocess is enabled by following this procedure:

1. Open SSMS
2. Connect to the Database Engine hosting the RiskFabric relational database
3. In Object Explorer, navigate to Server Objects > Linked Servers > Providers
4. Right-click the provider OraOLEDB.Oracle and select Properties
   The Provider Options - Oracle Provider for OLE DB window opens
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