OraOLEDB.Oracle DB provider catastrophic failure during processing
search cancel

OraOLEDB.Oracle DB provider catastrophic failure during processing

book

Article ID: 253807

calendar_today

Updated On:

Products

Information Centric Analytics

Issue/Introduction

The following error is logged during the Run Staging Procedures step of the RiskFabric Processing job:

Error Msg: Cannot execute the query "<query statement>" against OLE DB provider "OraOLEDB.Oracle" for linked server "RISK... Line  Number: 1

Environment

Release : 6.x

Cause

The Oracle provider's FetchSize value or ChunkSize value generates an excessively large data set for retrieval and caching by the Oracle client.

Resolution

Set the OraOLEDB.Oracle provider's fetch and chunk settings to their recommended values per this section of the Information Centric Analytics Administrator Guide.