Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to pull data from a csv in a URL. I am able to do so with no issues on QV Desktop. However, when I try to post on the access point, I am getting an unknown load statement error. The log file is below. (I removed the URL but I have no issues opening from a web browser or QV Desktop)
By the way, the URL is calculated by below expression:
i = week(today()-7);
i = Num(i, '00');
j = year(today()-7);
vURL = 'http://XXXX/7-day_trends_for_' & $(j) & '_week_' & $(i) & '.XXXX.csv';
OnlineData:
//Load last week data
CrossTable(Source, Value)
LOAD Date.Time,
//[4E_Diesel_Gen],
[18G_Diesel_Regen],
[10K_Diesel_Regen]//,
//[18E_Cell_3_Diesel_Gen]
FROM
$(vURL)
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
2019-10-01 07:55:11 Execution started.
2019-10-01 07:55:11 QlikView Desktop Version 12.20.20600+2018-05-02 14:59:34+8646aa8
2019-10-01 07:55:11 CPU Target x64
2019-10-01 07:55:11 Operating System Windows Server 2012 R2 Standard (64 bit edition)
2019-10-01 07:55:11 Wow64 mode Not using Wow64
2019-10-01 07:55:11 Language 0409 English (United States) English
2019-10-01 07:55:11 Country 1 United States United States
2019-10-01 07:55:11 MDAC Version 6.3.9600.16384
2019-10-01 07:55:11 MDAC Full Install Version 6.3.9600.16384
2019-10-01 07:55:11 PreferredCompression 2
2019-10-01 07:55:11 EnableParallelReload 1
2019-10-01 07:55:11 ParallelizeQvdLoads 1
2019-10-01 07:55:11 AutoSaveAfterReload 0
2019-10-01 07:55:11 BackupBeforeReload 0
2019-10-01 07:55:11 EnableFlushLog 0
2019-10-01 07:55:11 SaveInfoWhenSavingFile 0
2019-10-01 07:55:11 UserLogfileCharset 65001
2019-10-01 07:55:11 OdbcLoginTimeout -1
2019-10-01 07:55:11 OdbcConnectionTimeout -1
2019-10-01 07:55:11 LongestPossibleLine 1048576
2019-10-01 07:55:11 MaxCoreMask -1
2019-10-01 07:55:11 ScriptWantsDbWrite false
2019-10-01 07:55:11 ScriptWantsExe false
2019-10-01 07:55:11 LogFile CodePage Used: 65001
2019-10-01 07:55:11 UseMemoryFillPattern 1
2019-10-01 07:55:11 ScriptMode Legacy (gives greater system access) (aka qv11 mode)
2019-10-01 07:55:11 SequentialThreadCount 103
2019-10-01 07:55:11 NumberOfCores (effective) 32
2019-10-01 07:55:11 ReloadCodebase Bnf
2019-10-01 07:55:11 Reload Executed By XXXX
2019-10-01 07:55:11 Process Executing QlikView Desktop
2019-10-01 07:55:11 Process ID 3160
2019-10-01 07:55:11 0002 SET ThousandSep=','
2019-10-01 07:55:11 0003 SET DecimalSep='.'
2019-10-01 07:55:11 0004 SET MoneyThousandSep=','
2019-10-01 07:55:11 0005 SET MoneyDecimalSep='.'
2019-10-01 07:55:11 0006 SET MoneyFormat='$#,##0.00;-$#,##0.00'
2019-10-01 07:55:11 0007 SET TimeFormat='h:mm:ss TT'
2019-10-01 07:55:11 0008 SET DateFormat='M/D/YYYY'
2019-10-01 07:55:11 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
2019-10-01 07:55:11 0010 SET FirstWeekDay=0
2019-10-01 07:55:11 0011 SET BrokenWeeks=1
2019-10-01 07:55:11 0012 SET ReferenceDay=0
2019-10-01 07:55:11 0013 SET FirstMonthOfYear=1
2019-10-01 07:55:11 0014 SET CollationLocale='en-US'
2019-10-01 07:55:11 0015 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
2019-10-01 07:55:11 0016 SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'
2019-10-01 07:55:11 0017 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
2019-10-01 07:55:11 0018 SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'
2019-10-01 07:55:11 0020 LOAD * FROM Files\EnergyCurtailmentData.qvd (qvd)
2019-10-01 07:55:11 0021 where (WeekNumber & Year) <> (week(today()-7) & year(today()-7)) and
2019-10-01 07:55:11 0022 (WeekNumber & Year) <> (week(today()) & year(today()))
2019-10-01 07:55:11 9 fields found: Source, Value, Date, Time, DateOnly, Date.Time, WeekNumber, DayName, Year,
2019-10-01 07:55:11 50,872 lines fetched
2019-10-01 07:55:11 0024 i = week(today()-7)
2019-10-01 07:55:11 0025 i = Num(i, '00')
2019-10-01 07:55:11 0026 j = year(today()-7)
2019-10-01 07:55:11 0028 OnlineData:
2019-10-01 07:55:11 0029
2019-10-01 07:55:11 0030 CrossTable(Source, Value)
2019-10-01 07:55:11 0031 LOAD [Date.Time],
2019-10-01 07:55:11 0032
2019-10-01 07:55:11 0033 [18G_Diesel_Regen],
2019-10-01 07:55:11 0034 [10K_Diesel_Regen]
2019-10-01 07:55:11 0035
2019-10-01 07:55:11 0036 FROM
2019-10-01 07:55:11 0037 [http://XXXX/7-day_trends_for_2019_week_39.dir/XXXX.csv]
2019-10-01 07:55:11 0038 (txt, codepage is 28591, embedded labels, delimiter is ',', msq)
2019-10-01 07:55:33 Error: Unknown LOAD statment error
2019-10-01 07:56:07 Unknown LOAD statment error
2019-10-01 07:56:07 Execution Failed
2019-10-01 07:56:07 Execution finished.
Where is dir coming from?
Can anyone help me with this? Is there a setting that needs changed on QMC to allow pulling data from the web?
Matthew, I cannot recall what version you are running? There might be something, but I think that is for images, not just a URL, so my hunch would be this has to do with either the service account not having access to that location, or something not likely the access request coming from a service versus a logged on user, there is a difference. Shout back and let us know about the above, and that may give us some further ideas. One other thing occurred to me, are you guys running a Proxy server on the server by chance? That could be the other issue, the service/service account may be getting caught by that potentially as well if that is configured.
Regards,
Brett