Document Failed to load

Fri, 04 Jul 2014 11:57:49 GMT

Dear Community,

I have a qvw that fails to load. I've tried loading without data (Open .qvw without data). I've also tried loading the file with ApplicationRescue and ScriptRescue set to 1 (Document Fail to load). Binary imports don't work. And we've no PRJ folder. There are no recent back-ups (which has already changed as a result of this mess up!).

Are there any other ideas that I can try before starting from zero again? It's a 22 Mb which I can share if that would help.

Thanks in advance.

Liam

Re: Document Failed to load

jerrysvensson — Fri, 04 Jul 2014 13:08:07 GMT

Add your logfile contents here

Re: Document Failed to load

Fri, 04 Jul 2014 13:25:50 GMT

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.

Re: Document Failed to load

jerrysvensson — Fri, 04 Jul 2014 13:36:53 GMT

Your DateTime.qvd is probably being locked by QlikView. Try saving it to another name.

Re: Document Failed to load

Fri, 04 Jul 2014 14:15:53 GMT

Thanks a million. I owe you a pint.

topic Re: Document Failed to load in QlikView

Document Failed to load

Re: Document Failed to load

Re: Document Failed to load

Re: Document Failed to load

Re: Document Failed to load