Logfile contents. Execution complete at 05:12. The QVW has a modified date of 06:04.
10-04-2014 05:12:01: Execution started.
10-04-2014 05:12:01: QlikView Version:11.00.11154.0
10-04-2014 05:12:01: CPU Target x64
10-04-2014 05:12:01: Operating System Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)
10-04-2014 05:12:01: Wow64 mode Not using Wow64
10-04-2014 05:12:01: MDAC Version 6.1.7601.17514
10-04-2014 05:12:01: MDAC Full Install Version 6.1.7601.17514
10-04-2014 05:12:01: PreferredCompression 2
10-04-2014 05:12:01: EnableParallelReload 1
10-04-2014 05:12:01: ParallelizeQvdLoads 1
10-04-2014 05:12:01: AutoSaveAfterReload 0
10-04-2014 05:12:01: BackupBeforeReload 0
10-04-2014 05:12:01: EnableFlushLog 0
10-04-2014 05:12:01: SaveInfoWhenSavingFile 0
10-04-2014 05:12:01: UserLogfileCharset 0
10-04-2014 05:12:01: OdbcLoginTimeout -1
10-04-2014 05:12:01: OdbcConnectionTimeout -1
10-04-2014 05:12:01: ScriptWantsDbWrite false
10-04-2014 05:12:01: ScriptWantsExe false
10-04-2014 05:12:01: LogFile CodePage Used: 1252
10-04-2014 05:12:01: 0012 SET LanguageCode = 'EN'
10-04-2014 05:12:01: 0015 SWITCH LanguageCode
10-04-2014 05:12:01: 0032 SET DecimalSep = '.'
10-04-2014 05:12:01: 0033 SET MoneyDecimalSep = '.'
10-04-2014 05:12:01: 0034 SET MoneyThousandSep = ','
10-04-2014 05:12:01: 0035 SET ThousandSep = ','
10-04-2014 05:12:01: 0037 SET DateFormat = 'DD-MM-YYYY'
10-04-2014 05:12:01: 0038 SET MoneyFormat='£#,##0.00;-£#,##0.00'
10-04-2014 05:12:01: 0039 SET TimeFormat = 'hh:mm:ss'
10-04-2014 05:12:01: 0040 SET TimestampFormat = 'DD-MM-YYYY hh:mm:ss[.fff]'
10-04-2014 05:12:01: 0042 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
10-04-2014 05:12:01: 0043 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
10-04-2014 05:12:01: 0044 END SWITCH
10-04-2014 05:12:01: 0047 LET ThisExecTime = NOW()
10-04-2014 05:12:01: 0048 LET ThisExecDate = TODAY()
10-04-2014 05:12:01: 0049 LET ThisExecHour = HOUR(ThisExecTime)
10-04-2014 05:12:01: 0061 LET vQVConfigFolder = 'Config'
10-04-2014 05:12:01: 0063 UNQUALIFY *
10-04-2014 05:12:01: 0067 Config:
10-04-2014 05:12:01: 0068 LOAD
10-04-2014 05:12:01: 0069 InitialLoad,
10-04-2014 05:12:01: 0070 DataFolder,
10-04-2014 05:12:01: 0071 BPIDBTNSname,
10-04-2014 05:12:01: 0072 BPIDBUsername,
10-04-2014 05:12:01: 0073 BPIDBPassword
10-04-2014 05:12:01: 0074 FROM
10-04-2014 05:12:01: 0075 Config\BPI_QV_Config.txt (txt, utf8, embedded labels, delimiter is '=', msq, filters(Transpose()))
10-04-2014 05:12:01: 5 fields found: InitialLoad, DataFolder, BPIDBTNSname, BPIDBUsername, BPIDBPassword, 1 lines fetched
10-04-2014 05:12:01: 0080 LET vInitialLoad = FIELDVALUE('InitialLoad',1)
10-04-2014 05:12:01: 0081 LET vQVDataFolder = FIELDVALUE('DataFolder',1)
10-04-2014 05:12:01: 0084 LET vBPIDBTNSname = FIELDVALUE('BPIDBTNSname',1)
10-04-2014 05:12:01: 0085 LET vBPIDBUsername = FIELDVALUE('BPIDBUsername',1)
10-04-2014 05:12:01: 0086 LET vBPIDBPassword = FIELDVALUE('BPIDBPassword',1)
10-04-2014 05:12:01: 0089 IF vInitialLoad = 1 THEN
10-04-2014 05:12:01: 0101 LET vNow = NOW()
10-04-2014 05:12:01: 0102 LET vInitialLoad = 0
10-04-2014 05:12:01: 0117 ENDIF
10-04-2014 05:12:01: 0134 CONNECT*Provider*Password*
10-04-2014 05:12:01: 0153 QUALIFY *
10-04-2014 05:12:01: 0154 UNQUALIFY '*Key'
10-04-2014 05:12:01: 0156 DateTime:
10-04-2014 05:12:01: 0157 LOAD
10-04-2014 05:12:01: 0158 PERIODID AS DateTimeKey,
10-04-2014 05:12:01: 0159 YEAR AS Year,
10-04-2014 05:12:01: 0160 QUARTER AS QuarterYear,
10-04-2014 05:12:01: 0161 MONTH AS Month,
10-04-2014 05:12:01: 0162 MONTH(STARTTS) AS MonthName,
10-04-2014 05:12:01: 0163 WEEKDAY(STARTTS) AS DayOfWeek,
10-04-2014 05:12:01: 0164 WEEKOFYEAR AS WeekOfYear,
10-04-2014 05:12:01: 0165 DAYOFMONTH AS DayOfMonth,
10-04-2014 05:12:01: 0166 SHIFT AS Shift,
10-04-2014 05:12:01: 0167 ROUND(HOUROFDAY) AS HourOfDay,
10-04-2014 05:12:01: 0168 QUARTERHOUR AS QuarterHour,
10-04-2014 05:12:01: 0169 ROUND(MINUTES) AS Minute,
10-04-2014 05:12:01: 0170 YEAR&'-'&WEEKOFYEAR AS Weekly,
10-04-2014 05:12:01: 0171 YEAR&'-'&MONTH AS Monthly,
10-04-2014 05:12:01: 0172 MAKEDATE(YEAR,MONTH,DAYOFMONTH) AS Date,
10-04-2014 05:12:01: 0173 LEFT(TIMESTAMP(FLOOR(STARTTS,1/24),'DD-MM-YYYY hh:mm:ss'),19)
10-04-2014 05:12:01: 0174 AS DateHour,
10-04-2014 05:12:01: 0175 MAKETIME(HOUROFDAY) AS HourTimestamp,
10-04-2014 05:12:01: 0176 MAKETIME(HOUROFDAY,QUARTERHOUR) AS QuarterHourTimestamp,
10-04-2014 05:12:01: 0177 MAKETIME(HOUROFDAY,MINUTES) AS MinuteTimestamp,
10-04-2014 05:12:01: 0178 STARTTS AS StartTimestamp,
10-04-2014 05:12:01: 0179 ENDTS AS EndTimestamp,
10-04-2014 05:12:01: 0180 BUCKET AS Bucket
10-04-2014 05:12:01: 0181
10-04-2014 05:12:01: 0182 SQL SELECT *
10-04-2014 05:12:01: 0183 FROM PERIODS_V
10-04-2014 05:12:01: 0184 WHERE STARTTS >= to_date('07-02-2013 00:24:00','dd-mm-yyyy hh24:mi:ss')
10-04-2014 05:12:01: 0185 ORDER BY STARTTS ASC
10-04-2014 05:12:03: 22 fields found: DateTimeKey, DateTime.Year, DateTime.QuarterYear, DateTime.Month, DateTime.MonthName, DateTime.DayOfWeek, DateTime.WeekOfYear, DateTime.DayOfMonth, DateTime.Shift, DateTime.HourOfDay, DateTime.QuarterHour, DateTime.Minute, DateTime.Weekly, DateTime.Monthly, DateTime.Date, DateTime.DateHour, DateTime.HourTimestamp, DateTime.QuarterHourTimestamp, DateTime.MinuteTimestamp, DateTime.StartTimestamp, DateTime.EndTimestamp, DateTime.Bucket, 539,237 lines fetched
10-04-2014 05:12:16: 0187 UNQUALIFY *
10-04-2014 05:12:16: 0189 IF vInitialLoad = 1 AND (NoOfRows('DateTime') > 0) THEN
10-04-2014 05:12:16: 0193 IF vInitialLoad = 0 AND (QvdNoOfRecords('Data\DateTime.qvd') > 0) THEN
10-04-2014 05:12:16: 0195 CONCATENATE
10-04-2014 05:12:16: 0196 LOAD
10-04-2014 05:12:16: 0197 DateTimeKey,
10-04-2014 05:12:16: 0198 DateTime.Year,
10-04-2014 05:12:16: 0199 DateTime.QuarterYear,
10-04-2014 05:12:16: 0200 DateTime.Month,
10-04-2014 05:12:16: 0201 DateTime.MonthName,
10-04-2014 05:12:16: 0202 DateTime.DayOfWeek,
10-04-2014 05:12:16: 0203 DateTime.WeekOfYear,
10-04-2014 05:12:16: 0204 DateTime.DayOfMonth,
10-04-2014 05:12:16: 0205 DateTime.Shift,
10-04-2014 05:12:16: 0206 DateTime.HourOfDay,
10-04-2014 05:12:16: 0207 DateTime.QuarterHour,
10-04-2014 05:12:16: 0208 DateTime.Minute,
10-04-2014 05:12:16: 0209 DateTime.Weekly,
10-04-2014 05:12:16: 0210 DateTime.Monthly,
10-04-2014 05:12:16: 0211 DateTime.Date,
10-04-2014 05:12:16: 0212 DateTime.DateHour,
10-04-2014 05:12:16: 0213 DateTime.HourTimestamp,
10-04-2014 05:12:16: 0214 DateTime.QuarterHourTimestamp,
10-04-2014 05:12:16: 0215 DateTime.MinuteTimestamp,
10-04-2014 05:12:16: 0216 DateTime.StartTimestamp,
10-04-2014 05:12:16: 0217 DateTime.EndTimestamp,
10-04-2014 05:12:16: 0218 DateTime.Bucket
10-04-2014 05:12:16: 0219 FROM Data\DateTime.qvd (qvd)
10-04-2014 05:12:16: 0220 WHERE NOT EXISTS(DateTimeKey)
10-04-2014 05:12:16: 22 fields found: DateTimeKey, DateTime.Year, DateTime.QuarterYear, DateTime.Month, DateTime.MonthName, DateTime.DayOfWeek, DateTime.WeekOfYear, DateTime.DayOfMonth, DateTime.Shift, DateTime.HourOfDay, DateTime.QuarterHour, DateTime.Minute, DateTime.Weekly, DateTime.Monthly, DateTime.Date, DateTime.DateHour, DateTime.HourTimestamp, DateTime.QuarterHourTimestamp, DateTime.MinuteTimestamp, DateTime.StartTimestamp, DateTime.EndTimestamp, DateTime.Bucket, 942,080 lines fetched
10-04-2014 05:12:17: 0222 END IF
10-04-2014 05:12:17: 0224 IF ScriptErrorCount = 0 THEN
10-04-2014 05:12:17: 0225 STORE DateTime INTO Data\DateTime.qvd (qvd)
10-04-2014 05:12:18: General Script Error
10-04-2014 05:12:18: Execution Failed
10-04-2014 05:12:18: Execution finished.
