Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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
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.
Hi Guys,
I am also facing the same issue. Request you to post the solution to it, if this has been resolved.
Thanks