Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

8 Replies
sebastiandperei
Not applicable

Re: Script reload completes and then fails. What gives?

Try rebooting Qlikview. If not, reboot your PC. This was helpful for me many times.

rajni_batra
Not applicable

Re: Script reload completes and then fails. What gives?

R u creating a QVD to store this??

whiteline
Not applicable

Re: Script reload completes and then fails. What gives?

It often happens when you use Store directive and some error happens during file opperation.

Not applicable

Re: Script reload completes and then fails. What gives?

I'm loading from a QVD, but there is no store operation in this script.  The store operation happens in another QVW file that happens to load the same data.  This QVW is an offshoot of the original larger file that performs the rather compicated task of projecting the weeks of supply of our stock.  I seperated it out from the larger file because it was slowing down the performance of the original file.  I'm loading from the QVD with a where clause to limit the amount of data this file has to work with because it only needs roughly 53 weeks of data (everything from last week to a year from now) and there are roughly 6 years worth of data in the QVD file.  I thought that by limiting the data set, I could improve the performance of this QVW and eliminate the triggered date autoselection.

Not applicable

Re: Script reload completes and then fails. What gives?

I'm loading from a QVD, but there is no store operation in this script.  The store operation happens in another QVW file that happens to load the same data.  This QVW is an offshoot of the original larger file that performs the rather compicated task of projecting the weeks of supply of our stock.  I seperated it out from the larger file because it was slowing down the performance of the original file.  I'm loading from the QVD with a where clause to limit the amount of data this file has to work with because it only needs roughly 53 weeks of data (everything from last week to a year from now) and there are roughly 6 years worth of data in the QVD file.  I thought that by limiting the data set, I could improve the performance of this QVW and eliminate the triggered date autoselection.

Not applicable

Re: Script reload completes and then fails. What gives?

Most often this happens when loading or writing to a QVD file that is locked in some way.

It can also happen when an OleDB och ODBC connection failed and the thread running the connection is locked in the background.

Try closing all QlikView applications and start it up again.

Not applicable

Re: Script reload completes and then fails. What gives?

Turns out that when I upgraded to a newer service pack for QlikView, it solved the problem entirely.  Thanks for the help.

Not applicable

Re: Script reload completes and then fails. What gives?

Since then, I have realized that I placed the InputFields in a table that was joined afterward.  That is a no-no and probably caused my issue.  I likely resolved it without knowing I did when the upgrade happened.