Incremental Load Failed Problem

Wed, 16 Oct 2013 06:47:17 GMT

Hi Guys,

I am performing an Incremental Load for FAGLFLEXA .Following is my script:

(FullReload = 0) THEN

$(QVDTempTableName):

LOAD    // For 0 Inserting New Record

$(Preceed),0 AS InsertUpdateDelete

;

SQL SELECT $(SQL) FROM $(SAPTableName) WHERE TIMESTAMP >= $(LastExecTimeFlexa) AND TIMESTAMP < $(ThisExecTimeFlexa) AND RLDNR = '0L'

;

// CONCATENATE

// LOAD    // For Inserting Update Record

// $(Preceed),1 AS InsertUpdateDelete

// ;

// SQL SELECT $(SQL) FROM $(SAPTableName)

// WHERE $(Enterdate)>= '$(LastExecTime) 000000' AND $(Enterdate) < '$(LastExecTime) 000000' AND RLDNR = '0L';

//

     Concatenate

     LOAD

$(QVD),2 AS InsertUpdateDelete

FROM $(QVDFileDir)$(QVDTableName).QVD (qvd)

WHERE NOT EXISTS($(PrimaryKey));

ELSE

$(QVDTempTableName):

LOAD    // For 0 Inserting New Record

$(Preceed),0 AS InsertUpdateDelete

;

SQL SELECT $(SQL) FROM $(SAPTableName) WHERE RLDNR = '0L'

;

END IF

but I am getting this error in my log file:

QVX_UNEXPECTED_END_OF_DATA: Fetch aborted after 241 retries. Key = TIMEOUT_READ_MEMORY (ID:00 Type:E Number:001 Timeout when trying to read shared buffer)

15-10-2013 9:49:05 PM: Error: Custom read failed

15-10-2013 9:49:05 PM: General Script Error

15-10-2013 9:49:05 PM: Execution Failed

15-10-2013 9:49:05 PM: Execution finished

Which means its running out of Shared buffer memory for incremental load.

This is a load for the Finance Dashboard that we have,and the reload has failed due to this reason.

Can someone suggest what to do.

As this is Finance,the requirement is very critical,please suggest some quick fixes as soon as possible.

Thanks a lot...

Rochelle

Re: Incremental Load Failed Problem

Wed, 16 Oct 2013 08:19:00 GMT

Please suggest something guys....

topic Incremental Load Failed Problem in QlikView

Incremental Load Failed Problem

Re: Incremental Load Failed Problem