//ReloadHistory.qvd will keep track of when the last reload occurred for incremental loading purposes. If you need to reload all the data then delete ReloadHistory.qvd from your file structure. STORE * FROM AP_INVOICES_ALL_HISTORY INTO$(RawQVD_Path_Stage1_Data)\AP_INVOICES_ALL_HISTORY.qvd; DROPTABLE AP_INVOICES_ALL_HISTORY; //*****************Add a list of tables to be loaded from your data source below. Keep the first row "TableName". This is the name of the field. //TablesList: //Load * Inline [ //TableName //AP_INVOICES_ALL //]; // //For i = 0 to (NoOfRows('TablesList')-1); //Let varTableName = Peek('TableName',$(i), 'TablesList'); // Load Tables AP_INVOICES_ALL_SQL: LOAD"INVOICE_ID", "INVOICE_DATE"; SQL SELECT "INVOICE_ID", "INVOICE_DATE" FROM APPS."AP_INVOICES_ALL" WHERE INVOICE_DATE >= $(vLastExecTime) and INVOICE_DATE < $(vExecTime); IfNot$(FirstReload)andnotisnull(QvdCreateTime('$(RawQVD_Path_Stage1_Data)\AP_INVOICES_ALL_SQL.qvd')) then CONCATENATE Load * FROM$(RawQVD_Path_Stage1_Data)\AP_INVOICES_ALL_HISTORY.qvd (qvd) WHERENOTEXISTS(INVOICE_ID); // Endif IfNoOfRows(AP_INVOICES_ALL_SQL) > 0 Then STORE AP_INVOICES_ALL_SQL INTO$(RawQVD_Path_Stage1_Data)\AP_INVOICES_ALL_SQL.qvd; DROPTABLE AP_INVOICES_ALL_SQL; Endif DropTable AP_INVOICES_ALL_SQL; EXITSCRIPT;
I am getting this error. So Can you suggest me on the same.