8 Replies Latest reply: Sep 26, 2012 8:25 AM by gr8scott RSS

    Script reload completes and then fails.  What gives?

      8/29/2012 4:19:40 PM:      Execution started.

      8/29/2012 4:19:40 PM:      QlikView Version:10.00.8935.7

      8/29/2012 4:19:40 PM: 0002  SET ThousandSep=','

      8/29/2012 4:19:40 PM: 0003  SET DecimalSep='.'

      8/29/2012 4:19:40 PM: 0004  SET MoneyThousandSep=','

      8/29/2012 4:19:40 PM: 0005  SET MoneyDecimalSep='.'

      8/29/2012 4:19:40 PM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

      8/29/2012 4:19:40 PM: 0007  SET TimeFormat='h:mm:ss TT'

      8/29/2012 4:19:40 PM: 0008  SET DateFormat='M/D/YYYY'

      8/29/2012 4:19:40 PM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

      8/29/2012 4:19:40 PM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

      8/29/2012 4:19:40 PM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

      8/29/2012 4:19:40 PM: 0013  Directory \\BUSINTEL\QlikView Data\Published\Production\

      8/29/2012 4:19:40 PM: 0014  Forecast:

      8/29/2012 4:19:40 PM: 0015  Load [Customer SKU],

      8/29/2012 4:19:40 PM: 0016   [Customer Number],

      8/29/2012 4:19:40 PM: 0017   [Customer Style],

      8/29/2012 4:19:40 PM: 0018   [Customer Size],

      8/29/2012 4:19:40 PM: 0019   [Customer Color],

      8/29/2012 4:19:40 PM: 0020   Concat,

      8/29/2012 4:19:40 PM: 0021   Key_CancelDate,

      8/29/2012 4:19:40 PM: 0022   [Week End Date],

      8/29/2012 4:19:40 PM: 0023   [Calendar Year],

      8/29/2012 4:19:40 PM: 0024   [Calendar Month],

      8/29/2012 4:19:40 PM: 0025   [Calendar Day],

      8/29/2012 4:19:40 PM: 0026   [Standard Date],

      8/29/2012 4:19:40 PM: 0027   [Standard Date Number],

      8/29/2012 4:19:40 PM: 0028   [Production Date],

      8/29/2012 4:19:40 PM: 0029   [CST_DATE],

      8/29/2012 4:19:40 PM: 0030   [Week Number],

      8/29/2012 4:19:40 PM: 0031   [Corporation],

      8/29/2012 4:19:40 PM: 0032   [Division],

      8/29/2012 4:19:40 PM: 0033   [Location],

      8/29/2012 4:19:40 PM: 0034   [Company],

      8/29/2012 4:19:40 PM: 0035   [Business Unit],

      8/29/2012 4:19:40 PM: 0036   [Sales Group],

      8/29/2012 4:19:40 PM: 0037   Channel,

      8/29/2012 4:19:40 PM: 0038   [Corp Account],

      8/29/2012 4:19:40 PM: 0039   [Sales Rep],

      8/29/2012 4:19:40 PM: 0040   Intercompany,

      8/29/2012 4:19:40 PM: 0041   Product,

      8/29/2012 4:19:40 PM: 0042   [Product Type],

      8/29/2012 4:19:40 PM: 0043   [Family Group],

      8/29/2012 4:19:40 PM: 0044   [Mill Style],

      8/29/2012 4:19:40 PM: 0045   [Mill Size],

      8/29/2012 4:19:40 PM: 0046   Market,

      8/29/2012 4:19:40 PM: 0047   Brand,

      8/29/2012 4:19:40 PM: 0048   [Brand Subcode],

      8/29/2012 4:19:40 PM: 0049   [Group],

      8/29/2012 4:19:40 PM: 0050   [NAHM NR],

      8/29/2012 4:19:40 PM: 0051   [Quality Code],

      8/29/2012 4:19:40 PM: 0052   Category,

      8/29/2012 4:19:40 PM: 0053   [SD Type],

      8/29/2012 4:19:40 PM: 0054   [Type of Sock],

      8/29/2012 4:19:40 PM: 0055   [Knit Type],

      8/29/2012 4:19:40 PM: 0056   Construction,

      8/29/2012 4:19:40 PM: 0057   [Other],

      8/29/2012 4:19:40 PM: 0058   [Sales Style],

      8/29/2012 4:19:40 PM: 0059   [Cust Department],

      8/29/2012 4:19:40 PM: 0060   [Department],

      8/29/2012 4:19:40 PM: 0061   [Pairs per Package],

      8/29/2012 4:19:40 PM: 0062   [Inventory Pairs],

      8/29/2012 4:19:40 PM: 0063   [Forecast Pairs],

      8/29/2012 4:19:40 PM: 0064   [Unconsumed Pairs],

      8/29/2012 4:19:40 PM: 0065   [Abnormal Demand Pairs],

      8/29/2012 4:19:40 PM: 0066   [Order Demand Pairs],

      8/29/2012 4:19:40 PM: 0067   [Consume Demand Pairs],

      8/29/2012 4:19:40 PM: 0068   [Customer Forecast Pairs],

      8/29/2012 4:19:40 PM: 0069   [Ret Inventory Pairs],

      8/29/2012 4:19:40 PM: 0070   [Ship Pairs],

      8/29/2012 4:19:40 PM: 0071   [Open Order Pairs],

      8/29/2012 4:19:40 PM: 0072   [To Box Pairs],

      8/29/2012 4:19:40 PM: 0073   [Sourced Pairs],

      8/29/2012 4:19:40 PM: 0074   [Open PO Pairs],

      8/29/2012 4:19:40 PM: 0075   [Ordered Pairs],

      8/29/2012 4:19:40 PM: 0076   [Cancel Pairs],

      8/29/2012 4:19:40 PM: 0077   [OTW Inventory Pairs],

      8/29/2012 4:19:40 PM: 0078   [On Hand],

      8/29/2012 4:19:40 PM: 0079   [Accounting Date],

      8/29/2012 4:19:40 PM: 0080   [Accounting Year],

      8/29/2012 4:19:40 PM: 0081   [Accounting Month],

      8/29/2012 4:19:40 PM: 0082   [Customer Item Number],

      8/29/2012 4:19:40 PM: 0083   Obsolete_Inv,

      8/29/2012 4:19:40 PM: 0084   [UPC or GTIN],

      8/29/2012 4:19:40 PM: 0085   [On Hold Pairs],

      8/29/2012 4:19:40 PM: 0086   [Reserved Pairs],

      8/29/2012 4:19:40 PM: 0087   [Safety Stock]

      8/29/2012 4:19:40 PM: 0088  FROM [\\Busintel\qlikview data\Published\Production\Forecast.qvd] (qvd)

      8/29/2012 4:19:40 PM: 0089  Where [Production Date]>Date(Today(),'YYYY/MM/DD')

      8/29/2012 4:19:40 PM:        73 fields found: Customer SKU, Customer Number, Customer Style, Customer Size, Customer Color, Concat, Key_CancelDate, Week End Date, Calendar Year, Calendar Month, Calendar Day, Standard Date, Standard Date Number, Production Date, CST_DATE, Week Number, Corporation, Division, Location, Company, Business Unit, Sales Group, Channel, Corp Account, Sales Rep, Intercompany, Product, Product Type, Family Group, Mill Style, Mill Size, Market, Brand, Brand Subcode, Group, NAHM NR, Quality Code, Category, SD Type, Type of Sock, Knit Type, Construction, Other, Sales Style, Cust Department, Department, Pairs per Package, Inventory Pairs, Forecast Pairs, Unconsumed Pairs, Abnormal Demand Pairs, Order Demand Pairs, Consume Demand Pairs, Customer Forecast Pairs, Ret Inventory Pairs, Ship Pairs, Open Order Pairs, To Box Pairs, Sourced Pairs, Open PO Pairs, Ordered Pairs, Cancel Pairs, OTW Inventory Pairs, On Hand, Accounting Date, Accounting Year, Accounting Month, Customer Item Number, Obsolete_Inv, UPC or GTIN, On Hold Pairs, Reserved Pairs, Safety Stock, 404,057 lines fetched

      8/29/2012 4:20:02 PM: 0091  INPUTFIELD [PO Dozens_Input]

      8/29/2012 4:20:02 PM: 0093  Directory \\main_office\Demand_Planning\Shared\MyName\

      8/29/2012 4:20:02 PM: 0094  Outer Join

      8/29/2012 4:20:02 PM: 0095  LOAD

      8/29/2012 4:20:02 PM: 0096    Text ([Customer Number] & [Customer Style]&repeat(chr(32),16-len([Customer Style])) & [Customer Size]&repeat(chr(32),6-len([Customer Size])) & LEFT([Customer Color],5)) as [Customer SKU],

      8/29/2012 4:20:02 PM: 0097    DATE([Production Date],'YYYY/MM/DD') as [Production Date],

      8/29/2012 4:20:02 PM: 0098        NUM([Unconsumed Pairs],'#,##0') as [Unconsumed Pairs],

      8/29/2012 4:20:02 PM: 0099        Text([Sales Group]) as [Sales Group],

      8/29/2012 4:20:02 PM: 0100        TEXT([Customer Style]&repeat(chr(32),16-len([Customer Style]))) as [Customer Style],

      8/29/2012 4:20:02 PM: 0101        TEXT([Customer Size]&repeat(chr(32),6-len([Customer Size]))) as [Customer Size],

      8/29/2012 4:20:02 PM: 0102    TEXT([Customer Color]) as [Customer Color],

      8/29/2012 4:20:02 PM: 0103        TEXT([Customer Number]) as [Customer Number]

      8/29/2012 4:20:02 PM: 0104  FROM

      8/29/2012 4:20:02 PM: 0105  [\\main_office\Demand_Planning\Shared\MyName\DummyForecast.xlsx]

      8/29/2012 4:20:02 PM: 0106  (ooxml, embedded labels, table is Sheet1)

      8/29/2012 4:20:02 PM:        8 fields found: Customer SKU, Production Date, Unconsumed Pairs, Sales Group, Customer Style, Customer Size, Customer Color, Customer Number, 402 lines fetched

      8/29/2012 4:20:02 PM:       Joining/Keeping

      8/29/2012 4:20:02 PM: 0109  DIRECTORY \\Busintel\qlikview data\Published\Production\

      8/29/2012 4:20:02 PM: 0110  outer join

      8/29/2012 4:20:02 PM: 0111  LOAD

      8/29/2012 4:20:02 PM: 0112     TRIM([Customer Number]) as [Customer Number],

      8/29/2012 4:20:02 PM: 0113       [Customer SKU],

      8/29/2012 4:20:02 PM: 0114       TRIM([Customer Style])&TRIM([Customer Size])&TRIM([Customer Color]) as Concat,

      8/29/2012 4:20:02 PM: 0115       TRIM([Customer Style]) as [Customer Style],

      8/29/2012 4:20:02 PM: 0116       TRIM([Customer Size]) as [Customer Size],

      8/29/2012 4:20:02 PM: 0117       TRIM([Customer Color]) as [Customer Color],

      8/29/2012 4:20:02 PM: 0118       [Production Date],

      8/29/2012 4:20:02 PM: 0119       [PO Pairs]/12 as [PO Dozens],

      8/29/2012 4:20:02 PM: 0120       [PO Pairs]/12 As [PO Dozens_Input],

      8/29/2012 4:20:02 PM: 0121       [PO Pairs Unadjusted],

      8/29/2012 4:20:02 PM: 0122       [Sales Group]

      8/29/2012 4:20:02 PM: 0123  FROM

      8/29/2012 4:20:02 PM: 0124  [\\Busintel\qlikview data\Published\Production\PO_Data.qvd]

      8/29/2012 4:20:02 PM: 0125  (qvd)

      8/29/2012 4:20:02 PM:        11 fields found: Customer Number, Customer SKU, Concat, Customer Style, Customer Size, Customer Color, Production Date, PO Dozens, PO Dozens_Input, PO Pairs Unadjusted, Sales Group, 20,766 lines fetched

      8/29/2012 4:20:03 PM:       Joining/Keeping

      8/29/2012 4:20:04 PM: 0132  Directory \\main_office\Demand_Planning\Shared\MyName\

      8/29/2012 4:20:04 PM: 0133  Master_SKU_Data:

      8/29/2012 4:20:04 PM: 0134  Replace Load DISTINCT

      8/29/2012 4:20:04 PM: 0135     [Style Status],

      8/29/2012 4:20:04 PM: 0136       Line,

      8/29/2012 4:20:04 PM: 0137       Vendor,

      8/29/2012 4:20:04 PM: 0138       Class,

      8/29/2012 4:20:04 PM: 0139 

      8/29/2012 4:20:04 PM: 0140       Concat,

      8/29/2012 4:20:04 PM: 0141 

      8/29/2012 4:20:04 PM: 0142 

      8/29/2012 4:20:04 PM: 0143       [Xref Style],

      8/29/2012 4:20:04 PM: 0144       Text([Xref Size]) as [Xref Size],

      8/29/2012 4:20:04 PM: 0145       [Xref Color],

      8/29/2012 4:20:04 PM: 0146       [WOS Goal],

      8/29/2012 4:20:04 PM: 0147       [Roll Up Cust #],

      8/29/2012 4:20:04 PM: 0148       [Vendor MOQ]

      8/29/2012 4:20:04 PM: 0149  FROM

      8/29/2012 4:20:04 PM: 0150  [\\main_office\Demand_Planning\Shared\MyName\MASTER STYLE LIST.xlsx]

      8/29/2012 4:20:04 PM: 0151  (ooxml, embedded labels, table is [MASTER LIST])

      8/29/2012 4:20:04 PM:        11 fields found: Style Status, Line, Vendor, Class, Concat, Xref Style, Xref Size, Xref Color, WOS Goal, Roll Up Cust #, Vendor MOQ, 8,030 lines fetched

      8/29/2012 4:20:09 PM:      Execution finished.

       

       

      After the above, I get a message that the script failed to reload and then I get the option to reload my old data.  Why would the reload fail after the script completed execution? 

       

      I cannot share the file itself because it contains sensitive data that I'm not allowed to distribute according to company policy.  There are some rediculously complicated pivot tables in this file, so I'm afraid that their complexity is causing the issue preventing the reload.  Also this file is