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 "         SELECT DISTINCT RESTMESSAGEINFOID           ,RESTMESSAGEINFO.MESSAGEID,NETWORKPROTOCOL,NETWORKDIRECTION,HTTPURL           ,HTTPMETHOD,HTTPUSERAGENT,HTTPCOOKIES,HTTPSITERISKSCORE,COMMONDATATYPE           ,COMMONAPPLICATION,COMMONSHARINGURL,COMMONTAG,COMMONDESCRIPTION,COMMONOWNER,COMMONFOLDER           ,to_date(to_char(COMMONLASTMODIFIED,'YYYY-MM-DD HH24:MI:SS')) AS COMMONLASTMODIFIED           ,to_date(to_char(COMMONLASTACCESSED,'YYYY-MM-DD HH24:MI:SS')) AS COMMONLASTACCESSED           ,to_date(to_char(COMMONCREATED,'YYYY-MM-DD HH24:MI:SS')) AS COMMONCREATED           ,LOCATIONCOORDSLATITUDE           ,LOCATIONCOORDSLONGITUDE,LOCATIONISINSIDEOFFICE,DEVICEOS,DEVICETYPE           ,DEVICEISTRUSTEDDEVICE,REQUESTID,CUSTOM,COMMONAPPLICATIONINSTANCEID,COMMONAPPLICATIONREPORTNAME           ,COMMONDOCACTIVITYCOUNT,COMMONDOCCREATORID,COMMONDOCEXPOSED,COMMONDOCEXPOSURESALLINTERNAL,COMMONDOCEXPOSURESPUBLIC                   ,SUBSTR(COMMONDOCID, 0 , 48) COMMONDOCID,COMMONDOCISINTERNAL,COMMONDOCPARENTFOLDERID,COMMONDOCTYPE,COMMONLOGID           ,COMMONMESSAGESOURCE,COMMONSERVICECLASSIFICATION,COMMONSERVICESCORE,COMMONSHAREPOINT           ,COMMONTRANSACTIONID,COMMONUSERACTIVITYTYPE,COMMONUSERDOCSEXPOSEDCOUNT,COMMONUSERID           ,COMMONUSERISINTERNAL,COMMONUSERNAME,COMMONUSERTHREATSCORE,DEVICEISCOMPLIANT,DEVICEISPERSONAL           ,DEVICEISUNMANAGED,HTTPBROWSER,HTTPSITECLASSIFICATION,LINKDOCEXPOSURE           ,LINKINCIDENT,LINKSERVICEAPPLICATION,LINKSERVICEFILEACTIVITY,LINKUBA           ,LINKUSEREXPOSURES,LINKUSERTHREATTREE,LOCATIONREGION,LOCATIONREGIONCOUNTRY            from PROTECT.RestMessageInfo            INNER JOIN PROTECT.MESSAGE ON RestMessageInfo.MESSAGEID = MESSAGE.MESSAGEID            INNER JOIN PROTECT.INCIDENT ON INCIDENT.MESSAGEID = MESSAGE.MESSAGEID        WHERE 1= 1 AND ISDELETED = 0  AND  INCIDENT.INCIDENTID > 0  AND shouldHideFromReports = 0         AND  CommonDataType = 'DAR'        " 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.