Execution of script failed. Reload old data ??

raghuvr33 — Fri, 22 Aug 2014 19:43:20 GMT

Get this error when trying to load multiple years data from QVD. Have ensured only one column unique between tables and it creates Syn Keys.

Script is

LOAD %AccountKey,
     Account_Active_,
     Account_Code,
     [Account Description]
FROM

(qvd);

LOAD %CCKey,
     CostCenter_Active_,
     Cost_Center,
     [Cost Center Description]
FROM

(qvd);

LOAD %CustomerKey,
     Customer,
     Bill_TO,
     [customer class],
     [Credit Hold],
     [Credit Limit],
     [Credit Terms],
     [Customer Region],
     [Customer Remarks],
     Cust_Site,
     Sales_person,
     Taxable,
     [Customer Type]
FROM

(qvd);

LOAD %EntityKey,
Entity_,
Entity_Description
FROM

(qvd);

LOAD [Location Name],
     [GL Account Code],
     %AccountKey,
     [Transaction Amount],
     %CCKey,
     [Transaction Description],
     [GL Document],
     [GL Document Type],
     [GL Effective Date],
     [Invoice Month],
     [Invoice Year],
     %EntityKey,
     [GL Transaction Line],
     [GL Project Code],
     [GL Reference],
     %SubAccountKey,
     [GL Transaction Type]
FROM

(qvd);

LOAD [Location Name],
     %AccountKey,
     %CCKey,
     [Invoice Comment Index],
     [Invoice Comment],
     [Invoice Discount Percentage],
     [Invoice Discount Account],
     [Invoice Discount Project],
     [Invoice Discount SubAccount],
     [Invoice Due Date],
     Invoice_Number,
     [Invoice Line],
     [Invoice Sales Order],
     %ItemKey,
     [Invoice Partial OK],
     [Invoice Performance Date],
     [Invoice Pick Date],
     [Invoice Unit Price],
     [Invoice Product Line],
     %ProdLineKey,
     [Invoice Project Code],
     [Invoice Promise Date],
     [Invoice Quantity Invoiced],
     [Invoice Quantity Ordered],
     [Invoice Quantity Pending],
     [Invoice Performance Qty],
     [Invoice Quantity Pick],
     [Invoice Quantity Quoted],
     [Invoice Quantity Shipped],
     [Invoice Request Date],
     [Invoice Serial Number],
     [Invoice Ship To],
     %SiteKey,
     %SalespersonKey,
     [Invoice Status],
     %SubAccountKey,
     [Invoice Line Taxable],
     [Invoice Line Type],
     [Invoice Line Unit Of Measure]
FROM

(qvd);

LOAD [Location Name],
     [Invoice Bill To],
     [Invoice Header Channel],
     [Invoice Header Comment Index],
     [Invoice Header Credit Terms],
     %CustomerKey,
     [Invoice Header Due Date],
     [Invoice Date],
     [Invoice Month],
     [Invoice Year],
     Invoice_Number,
     [Invoice Header Sales Order],
     [Invoice Header Ordered Date],
     [Invoice Header Partial OK],
     [Invoice Header Purchase Order],
     [Invoice Header Project Code],
     [Invoice Header Sales Quote],
     [Invoice Header Request Date],
     [Invoice Header Remarks],
     [Invoice Header Ship Date],
     %SiteKey,
     %SalespersonKey,
     [Invoice Taxable],
     [Invoice Trailer1 Amount],
     [Invoice Trailer1],
     [Invoice Trailer2 Amount],
     [Invoice Trailer2],
     [Invoice Trailer3 Amount],
     [Invoice Trailer3],
     [Invoice Type]
FROM

(qvd);

LOAD %ItemKey,
     [ABC Code],
     [BOM Code],
     [Item Description1],
     [Item Description2],
     [Item Group],
     Item_,
     [Item Type],
     [Item Price],
     Item_Product_Line,
     [Item Site_],
     [Item Status],
     [Item Unit Of Measure]
FROM

(qvd);

LOAD %ProdLineKey,
Product_Line,
[ProductLine Description]
FROM

(qvd);

LOAD [Location Name],
     %AccountKey,
     %CCKey,
     [Sales Detail Comment Index],
     [Sales Detail Comment],
     [Sales Detail Confirmed],
     [Sales Detail Item Description],
     [Sales Detail Discount Account],
     [Sales Detail Discount CostCenter],
     [Sales Detail Discount Project],
     [Sales Detail Discount SubAccount],
     [Sales Detail Due Date],
     [Sales Detail Expire Date],
     [Sales Detail Invoice Number],
     [Sales Detail Order Line],
     [Sales Detail List Price],
     [Sales Detail Modified Date],
     Sales_Order,
     %ItemKey,
     [Sales Detail Partial],
     [Sales Detail Performance Date],
     [Sales Detail Pick date],
     [SOD Price List],
     [Sales Detail Unit Price],
     [Sales Detail Product_Line],
     %ProdLineKey,
     [Sales Detail Project_Code],
     [Sales Detail Promise Date],
     [Sales Detail Qty Allocated],
     [Sales Detail Qty To Ship],
     [Sales Detail Qty Invoiced],
     [Sales Detail Qty Ordered],
     [Sales Detail Qty Shipped],
     [Sales Detail Ship To],
     %SiteKey,
     %SalesPersonKey,
     [Sales Detail Cost],
     %SubAccountKey,
     [Sales Detail Ship Type],
     [Sales Unit Of Measure],
     [Sales Detail Ext Price]
FROM

(qvd);

LOAD [Location Name],
     [Sales Order Bill TO],
     [Sales Order Channel],
     [Sales Head Comment Index],
     %CustomerKey,
     [Sales Order Due Date],
     [Sales Order Invoice Date],
     [Sales Order Invoice Number],
     [Sales Order Invoiced],
     Sales_Order,
     [Sales Order Order date],
     [Order Year],
     [Order Month],
     [Sales Order Partial OK],
     [SO Purchase Order],
     [SO Price List],
     [Sales Order Project],
     [Sales Quote],
     [Sales Order Request Date],
     [Sales Order Revision],
     [Sales Order Remarks],
     [Sales Header Ship To],
     [Sales Order Ship Date],
     %SiteKey,
     %SalesPersonKey,
     [Sales Trailer 1],
     [Sales Trailer 1 Amount],
     [Sales Trailer 2 Amount],
     [Sales Trailer 2],
     [Sales Trailer 3 Amount],
     [Sales Trailer 3],
     Type
FROM

(qvd);

LOAD %SalesPersonKey,
Sales_Person,
[Sales Person Name]
FROM

(qvd);

LOAD %SiteKey,
[Site Description],
Site_
FROM

(qvd);

LOAD %SubAccountKey,
[Sub_Account Description],
Sub_Account
FROM

(qvd);

Appreciate any input on what is wrong with the above script

topic Execution of script failed. Reload old data ?? in QlikView

Execution of script failed. Reload old data ??