Book - Qlikview 11 for developers - Error: Execution of script failed

[#1]

In chapter 7/scripting, I have to load some csv files into the script editor. When I try to reload the script, some rows are transferred and then I get an error - Execution of Script Failed. Reload Old data. This error has been posted many times before. I tried some solutions, but they did not work. How do I troubleshoot this in a systematic way, instead of trying random things ?

Things I tried -

1 - Enable log file. Could not find its location on my computer.

2 - Create a copy of the .qvw and then replace it with the copy.

3 - Restart my computer. Lame, but it is very powerful in windows

The script in the relevant tab -

[Aircraft Types]:

LOAD AC_TYPEID as [%Aircraft Type ID],

     AC_GROUP as [%Aircraft Group Type],

     SSD_NAME as [Aircraft Name],

     MANUFACTURER as [Aircraft Manufacturer],

     LONG_NAME as [Aircraft Name Full],

     SHORT_NAME as [Aircraft Name Abbreviated],

     BEGIN_DATE as [Aircraft Begin Date],

     END_DATE as [Aircraft End Date]

FROM

[..\Data Files\CSVs\Aircraft_Base_File.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[Aircraft Groups]:

LOAD [Aircraft Group ID] as [%Aircraft Group Type],

     [Aircraft Engine Type],

     [Aircraft Number Of Engines]

FROM

[..\Data Files\CSVs\Aircraft_Group.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[barryharmsen]

Hi John,

The log file should be in the same place as your QVW. This should be the first place to check as it will tell you exactly where the reload has failed (which may not be on that particular script statement). These seemingly random 'Execution of Script Failed' errors often happen when files that you are trying to load into QlikView (or trying to write from QlikView, such as QVD's) are in use by another process.

Kind regards,

Barry

[#3]

Thanks. I am posting the log here -

3/21/2014 08:30:33 AM:      Execution started.

3/21/2014 08:30:33 AM:      QlikView Version:11.X

3/21/2014 08:30:33 AM:      CPU Target                    x64

3/21/2014 08:30:33 AM:      Operating System              Windows 7 Home Premium Service Pack 1 (64 bit edition)

3/21/2014 08:30:33 AM:      Wow64 mode                    Not using Wow64

3/21/2014 08:30:33 AM:      MDAC Version                  6.1.7601.17514

3/21/2014 08:30:33 AM:      MDAC Full Install Version     6.1.7601.17514

3/21/2014 08:30:33 AM:      PreferredCompression          2

3/21/2014 08:30:33 AM:      EnableParallelReload          1

3/21/2014 08:30:33 AM:      ParallelizeQvdLoads           1

3/21/2014 08:30:33 AM:      AutoSaveAfterReload           0

3/21/2014 08:30:33 AM:      BackupBeforeReload            0

3/21/2014 08:30:33 AM:      EnableFlushLog                0

3/21/2014 08:30:33 AM:      SaveInfoWhenSavingFile        0

3/21/2014 08:30:33 AM:      UserLogfileCharset            1200

3/21/2014 08:30:33 AM:      OdbcLoginTimeout              -1

3/21/2014 08:30:33 AM:      OdbcConnectionTimeout         -1

3/21/2014 08:30:33 AM:      ScriptWantsDbWrite            false

3/21/2014 08:30:33 AM:      ScriptWantsExe                false

3/21/2014 08:30:33 AM:      LogFile CodePage Used:        1200

3/21/2014 08:30:33 AM:       Reload Executed By myPc\myUser

3/21/2014 08:30:33 AM:       Process Executing: QlikView Desktop

3/21/2014 08:30:33 AM:       Process ID: 2688

3/21/2014 08:30:33 AM: 0002  SET ThousandSep=','

3/21/2014 08:30:33 AM: 0003  SET DecimalSep='.'

3/21/2014 08:30:33 AM: 0004  SET MoneyThousandSep=','

3/21/2014 08:30:33 AM: 0005  SET MoneyDecimalSep='.'

3/21/2014 08:30:33 AM: 0006  SET MoneyFormat='$#,##0.00;($#,##0.00)'

3/21/2014 08:30:33 AM: 0007  SET TimeFormat='h:mm:ss TT'

3/21/2014 08:30:33 AM: 0008  SET DateFormat='M/D/YYYY'

3/21/2014 08:30:33 AM: 0009  SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

3/21/2014 08:30:33 AM: 0010  SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

3/21/2014 08:30:33 AM: 0011  SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

3/21/2014 08:30:33 AM: 0014  [Main Data]:

3/21/2014 08:30:33 AM: 0015  LOAD [%Airline ID],

3/21/2014 08:30:33 AM: 0016       [%Carrier Group ID],

3/21/2014 08:30:33 AM: 0017       [%Unique Carrier Code],

3/21/2014 08:30:33 AM: 0018       [%Unique Carrier Entity Code],

3/21/2014 08:30:33 AM: 0019       [%Region Code],

3/21/2014 08:30:33 AM: 0020       [%Origin Airport ID],

3/21/2014 08:30:33 AM: 0021       [%Origin Airport Sequence ID],

3/21/2014 08:30:33 AM: 0022       [%Origin Airport Market ID],

3/21/2014 08:30:33 AM: 0023       [%Origin World Area Code],

3/21/2014 08:30:33 AM: 0024       [%Destination Airport ID],

3/21/2014 08:30:33 AM: 0025       [%Destination Airport Sequence ID],

3/21/2014 08:30:33 AM: 0026       [%Destination Airport Market ID],

3/21/2014 08:30:33 AM: 0027       [%Destination World Area Code],

3/21/2014 08:30:33 AM: 0028       [%Aircraft Group ID],

3/21/2014 08:30:33 AM: 0029       [%Aircraft Type ID],

3/21/2014 08:30:33 AM: 0030       [%Aircraft Configuration ID],

3/21/2014 08:30:33 AM: 0031       [%Distance Group ID],

3/21/2014 08:30:33 AM: 0032       [%Service Class ID],

3/21/2014 08:30:33 AM: 0033       [%Datasource ID],

3/21/2014 08:30:33 AM: 0034       [# Departures Scheduled],

3/21/2014 08:30:33 AM: 0035       [# Departures Performed],

3/21/2014 08:30:33 AM: 0036       [# Payload],

3/21/2014 08:30:33 AM: 0037       Distance,

3/21/2014 08:30:33 AM: 0038       [# Available Seats],

3/21/2014 08:30:33 AM: 0039       [# Transported Passengers],

3/21/2014 08:30:33 AM: 0040       [# Transported Freight],

3/21/2014 08:30:33 AM: 0041       [# Transported Mail],

3/21/2014 08:30:33 AM: 0042       [# Ramp-To-Ramp Time],

3/21/2014 08:30:33 AM: 0043       [# Air Time],

3/21/2014 08:30:33 AM: 0044       [Unique Carrier],

3/21/2014 08:30:33 AM: 0045       [Carrier Code],

3/21/2014 08:30:33 AM: 0046       [Carrier Name],

3/21/2014 08:30:33 AM: 0047       [Origin Airport Code],

3/21/2014 08:30:33 AM: 0048       [Origin City],

3/21/2014 08:30:33 AM: 0049       [Origin State Code],

3/21/2014 08:30:33 AM: 0050       [Origin State FIPS],

3/21/2014 08:30:33 AM: 0051       [Origin State],

3/21/2014 08:30:33 AM: 0052       [Origin Country Code],

3/21/2014 08:30:33 AM: 0053       [Origin Country],

3/21/2014 08:30:33 AM: 0054       [Destination Airport Code],

3/21/2014 08:30:33 AM: 0055       [Destination City],

3/21/2014 08:30:33 AM: 0056       [Destination State Code],

3/21/2014 08:30:33 AM: 0057       [Destination State FIPS],

3/21/2014 08:30:33 AM: 0058       [Destination State],

3/21/2014 08:30:33 AM: 0059       [Destination Country Code],

3/21/2014 08:30:33 AM: 0060       [Destination Country],

3/21/2014 08:30:33 AM: 0061       Year,

3/21/2014 08:30:33 AM: 0062       Period,

3/21/2014 08:30:33 AM: 0063       Quarter,

3/21/2014 08:30:33 AM: 0064       [Month (#)],

3/21/2014 08:30:33 AM: 0065       Month,

3/21/2014 08:30:33 AM: 0066       [From - To Airport Code],

3/21/2014 08:30:33 AM: 0067       [From - To Airport ID],

3/21/2014 08:30:33 AM: 0068       [From - To City],

3/21/2014 08:30:33 AM: 0069       [From - To State Code],

3/21/2014 08:30:33 AM: 0070       [From - To State]

3/21/2014 08:30:33 AM: 0071  FROM

3/21/2014 08:30:33 AM: 0072  [..\Data Files\QVDs\Flight Data.qvd]

3/21/2014 08:30:33 AM: 0073  (qvd)

3/21/2014 08:30:33 AM:       56 fields found: %Airline ID, %Carrier Group ID, %Unique Carrier Code, %Unique Carrier Entity Code, %Region Code, %Origin Airport ID, %Origin Airport Sequence ID, %Origin Airport Market ID, %Origin World Area Code, %Destination Airport ID, %Destination Airport Sequence ID, %Destination Airport Market ID, %Destination World Area Code, %Aircraft Group ID, %Aircraft Type ID, %Aircraft Configuration ID, %Distance Group ID, %Service Class ID, %Datasource ID, # Departures Scheduled, # Departures Performed, # Payload, Distance, # Available Seats, # Transported Passengers, # Transported Freight, # Transported Mail, # Ramp-To-Ramp Time, # Air Time, Unique Carrier, Carrier Code, Carrier Name, Origin Airport Code, Origin City, Origin State Code, Origin State FIPS, Origin State, Origin Country Code, Origin Country, Destination Airport Code, Destination City, Destination State Code, Destination State FIPS, Destination State, Destination Country Code, Destination Country, Year, Period, Quarter, Month (#), Month, From - To Airport Code, From - To Airport ID, From - To City, From - To State Code, From - To State, 1,256,075 lines fetched

3/21/2014 08:30:35 AM: 0076  [Carrier Groups]:

3/21/2014 08:30:35 AM: 0077  LOAD [%Carrier Group ID],

3/21/2014 08:30:35 AM: 0078       [Carrier Group]

3/21/2014 08:30:35 AM: 0079  FROM

3/21/2014 08:30:35 AM: 0080  [..\Data Files\QVDs\Carrier Groups.qvd]

3/21/2014 08:30:35 AM: 0081  (qvd)

3/21/2014 08:30:35 AM:       2 fields found: %Carrier Group ID, Carrier Group, 8 lines fetched

3/21/2014 08:30:35 AM: 0083  Directory

3/21/2014 08:30:35 AM: 0084  LOAD [%Airline ID],

3/21/2014 08:30:35 AM: 0085       Airline

3/21/2014 08:30:35 AM: 0086  FROM

3/21/2014 08:30:35 AM: 0087  [..\Data Files\QVDs\Airlines.qvd]

3/21/2014 08:30:35 AM: 0088  (qvd)

3/21/2014 08:30:35 AM:       2 fields found: %Airline ID, Airline, 1,548 lines fetched

3/21/2014 08:30:35 AM: 0090  LOAD [%Region Code],

3/21/2014 08:30:35 AM: 0091       [Carrier's Operating Region]

3/21/2014 08:30:35 AM: 0092  FROM

3/21/2014 08:30:35 AM: 0093  [..\Data Files\QVDs\Carrier Operating Region.qvd]

3/21/2014 08:30:35 AM: 0094  (qvd)

3/21/2014 08:30:35 AM:       2 fields found: %Region Code, Carrier's Operating Region, 6 lines fetched

3/21/2014 08:30:35 AM: 0096  LOAD [%Datasource ID],

3/21/2014 08:30:35 AM: 0097       [Flight Type]

3/21/2014 08:30:35 AM: 0098  FROM

3/21/2014 08:30:35 AM: 0099  [..\Data Files\QVDs\Flight Types.qvd]

3/21/2014 08:30:35 AM: 0100  (qvd)

3/21/2014 08:30:35 AM:       2 fields found: %Datasource ID, Flight Type, 4 lines fetched

3/21/2014 08:30:35 AM: 0103  [Aircraft Types]:

3/21/2014 08:30:35 AM: 0104  LOAD AC_TYPEID as [%Aircraft Type ID],

3/21/2014 08:30:35 AM: 0105       AC_GROUP as [%Aircraft Group Type],

3/21/2014 08:30:35 AM: 0106       SSD_NAME as [Aircraft Name],

3/21/2014 08:30:35 AM: 0107       MANUFACTURER as [Aircraft Manufacturer],

3/21/2014 08:30:35 AM: 0108       LONG_NAME as [Aircraft Name Full],

3/21/2014 08:30:35 AM: 0109       SHORT_NAME as [Aircraft Name Abbreviated],

3/21/2014 08:30:35 AM: 0110       BEGIN_DATE as [Aircraft Begin Date],

3/21/2014 08:30:35 AM: 0111       END_DATE as [Aircraft End Date]

3/21/2014 08:30:35 AM: 0112  FROM

3/21/2014 08:30:35 AM: 0113  [..\Data Files\CSVs\Aircraft_Base_File.csv]

3/21/2014 08:30:35 AM: 0114  (txt, codepage is 1252, embedded labels, delimiter is ';', msq)

3/21/2014 08:30:35 AM:       8 fields found: %Aircraft Type ID, %Aircraft Group Type, Aircraft Name, Aircraft Manufacturer, Aircraft Name Full, Aircraft Name Abbreviated, Aircraft Begin Date, Aircraft End Date, 369 lines fetched

3/21/2014 08:30:35 AM: 0117  [Aircraft Groups]:

3/21/2014 08:30:35 AM: 0118  LOAD [Aircraft Group ID] as [%Aircraft Group Type],

3/21/2014 08:30:35 AM: 0119       [Aircraft Engine Type],

3/21/2014 08:30:35 AM: 0120       [Aircraft Number Of Engines]

3/21/2014 08:30:35 AM: 0121  FROM

3/21/2014 08:30:35 AM: 0122  [..\Data Files\CSVs\Aircraft_Group.csv]

3/21/2014 08:30:35 AM: 0123  (txt, codepage is 1252, embedded labels, delimiter is ';', msq)

3/21/2014 08:30:35 AM:       3 fields found: %Aircraft Group Type, Aircraft Engine Type, Aircraft Number Of Engines, 9 lines fetched

3/21/2014 08:30:35 AM: 0127  Directory

3/21/2014 08:30:35 AM: 0128  LOAD [%Distance Group ID],

3/21/2014 08:30:35 AM: 0129       [Distance Interval]

3/21/2014 08:30:35 AM: 0130  FROM

3/21/2014 08:30:35 AM: 0131  [..\Data Files\QVDs\Distance Groups.qvd]

3/21/2014 08:30:35 AM: 0132  (qvd)

3/21/2014 08:30:35 AM:       2 fields found: %Distance Group ID, Distance Interval, 25 lines fetched

3/21/2014 08:30:35 AM: 0134  OLEDB CONNECT32*Provider*Password*Password*

3/21/2014 08:30:36 AM: 0137  LOAD `%Origin Airport ID`,

3/21/2014 08:30:36 AM: 0138      `Origin Airport`

3/21/2014 08:30:36 AM: 0139  SQL SELECT `%Origin Airport ID`,

3/21/2014 08:30:36 AM: 0140      `Origin Airport`

3/21/2014 08:30:36 AM: 0141  FROM `Origin Airports`

3/21/2014 08:30:36 AM:       2 fields found: %Origin Airport ID, Origin Airport, 6,209 lines fetched

3/21/2014 08:30:36 AM: 0143  LOAD `%Destination Airport ID`,

3/21/2014 08:30:36 AM: 0144      `Destination Airport`

3/21/2014 08:30:36 AM: 0145  SQL SELECT `%Destination Airport ID`,

3/21/2014 08:30:36 AM: 0146      `Destination Airport`

3/21/2014 08:30:36 AM: 0147  FROM `Destination Airports`

3/21/2014 08:30:36 AM:       2 fields found: %Destination Airport ID, Destination Airport, 6,209 lines fetched

3/21/2014 08:30:36 AM: 0149  Directory

3/21/2014 08:30:36 AM: 0150  LOAD [%Origin Airport Market ID],

3/21/2014 08:30:36 AM: 0151       [Origin Market]

3/21/2014 08:30:36 AM: 0152  FROM

3/21/2014 08:30:36 AM: 0153  [..\Data Files\CSVs\Origin Markets.csv]

3/21/2014 08:30:36 AM: 0154  (txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

3/21/2014 08:30:36 AM:       2 fields found: %Origin Airport Market ID, Origin Market, 1,841 lines fetched

3/21/2014 08:30:36 AM: 0156  Directory

3/21/2014 08:30:36 AM: 0157  LOAD [%Destination Airport Market ID],

3/21/2014 08:30:36 AM: 0158       [Destination Market]

3/21/2014 08:30:36 AM: 0159  FROM

3/21/2014 08:30:36 AM: 0160  [..\Data Files\CSVs\Destination Markets.csv]

3/21/2014 08:30:36 AM: 0161  (txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

3/21/2014 08:30:36 AM:       2 fields found: %Destination Airport Market ID, Destination Market, 1,903 lines fetched

3/21/2014 08:30:37 AM:      Execution finished.

[#4]

Hi Guys,

I am also facing the same issue. Request you to post the solution to it, if this has been resolved.

Thanks