Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Document Failed to load

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

1 Solution

Accepted Solutions
jerrysvensson
Partner - Specialist II
Partner - Specialist II

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

View solution in original post

4 Replies
jerrysvensson
Partner - Specialist II
Partner - Specialist II

Add your logfile contents here

Not applicable
Author

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.

jerrysvensson
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

Thanks a million. I owe you a pint.