Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please suggest something guys....