Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
i work with Qlik View 12.10 Desktop edition , i create a qvw file that has only the above edit script :
OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=farmas1;Data Source=farma] (XPassword is ebNYHTFMSLbCWZFGcG);
let vqvdstorepath = 'C:\logistic-i\';
table1_tmp:
SQL SELECT *
FROM FARMAS1.CCCTESTSTATISTICS_TEST where fyeid > 2015;
STORE table1_tmp into $(vqvdstorepath)table1.qvd;
DROP table table1_tmp;
table2_tmp:
sql select *
from ip_customeraddress;
STORE table2_tmp into $(vqvdstorepath)table2.qvd;
DROP Table table2_tmp;
table3_tmp:
SQL SELECT *
FROM FARMAS1."IP_PSIGEIA_QV";
STORE table3_tmp into $(vqvdstorepath)table3.qvd;
DROP Table table3_tmp;
so when i open qlikview an run manual reload the script run and create or update the three qvd files .
but when i run "C:\Program Files\QlikView\qv.exe" /r "c:\logistic-i\QvdFiles\StoreData.qvw" even thru bat file or cmd file i see the panel of the script where counting the records from the sql statements but never the files update, change or create . It seems like never run the store command .
Can anyone help me ?
Thanks
Please look into the below link and hope this helps..
Loannis,
I do not see an: Exit Script; statement in the above script.
Maybe it gets hung in the process. Just a thought...
Take a look at the script document log and see if the path for the store looks correct in the log. Specifically, if you check this statement in the log:
STORE table3_tmp into $(vqvdstorepath)table3.qvd;
Is the full path there?
-Rob
as you can see i run just now ( date time at the bottom ) , script as you can see is completed and the qvd files have the yesterday date time .
It wasn't the progress window I was suggesting, but the script log. Open Settings, Document Properties and ensure that "Generate Logfile" is checked on the general tab. If not, check it and reload. The log will be in the same folder as the qvw, same name with a ".log" extension.
-Rob
when i run reload manual i get this log file :
2017-11-17 17:32:08 Execution started.
2017-11-17 17:32:08 QlikView Desktop Version 12.10.10000+2016-11-28 13:27:05.HEAD.Component.Version
2017-11-17 17:32:08 CPU Target x64
2017-11-17 17:32:08 Operating System Windows 7 Professional Service Pack 1 (64 bit edition)
2017-11-17 17:32:08 Wow64 mode Not using Wow64
2017-11-17 17:32:08 Language 0408 Ελληνικά (Ελλάδας) Greek
2017-11-17 17:32:08 Country 30 Ελλάδα Greece
2017-11-17 17:32:08 MDAC Version 6.1.7601.17514
2017-11-17 17:32:08 MDAC Full Install Version 6.1.7601.17514
2017-11-17 17:32:08 PreferredCompression 2
2017-11-17 17:32:08 EnableParallelReload 1
2017-11-17 17:32:08 ParallelizeQvdLoads 1
2017-11-17 17:32:08 AutoSaveAfterReload 0
2017-11-17 17:32:08 BackupBeforeReload 0
2017-11-17 17:32:08 EnableFlushLog 0
2017-11-17 17:32:08 SaveInfoWhenSavingFile 0
2017-11-17 17:32:08 UserLogfileCharset 65001
2017-11-17 17:32:08 OdbcLoginTimeout -1
2017-11-17 17:32:08 OdbcConnectionTimeout -1
2017-11-17 17:32:08 LongestPossibleLine 1048576
2017-11-17 17:32:08 MaxCoreMask -1
2017-11-17 17:32:08 ScriptWantsDbWrite false
2017-11-17 17:32:08 ScriptWantsExe false
2017-11-17 17:32:08 LogFile CodePage Used: 65001
2017-11-17 17:32:08 UseMemoryFillPattern 1
2017-11-17 17:32:08 ScriptMode Legacy (gives greater system access) (aka qv11 mode)
2017-11-17 17:32:08 SequentialThreadCount 43
2017-11-17 17:32:08 NumberOfCores (effective) 4
2017-11-17 17:32:08 ReloadCodebase Classic
2017-11-17 17:32:09 Reload Executed By QLIKVIEW2\admin
2017-11-17 17:32:09 Process Executing QlikView Desktop
2017-11-17 17:32:09 Process ID 10824
2017-11-17 17:32:09 0002 SET ThousandSep='.'
2017-11-17 17:32:09 0003 SET DecimalSep=','
2017-11-17 17:32:09 0004 SET MoneyThousandSep='.'
2017-11-17 17:32:09 0005 SET MoneyDecimalSep=','
2017-11-17 17:32:09 0006 SET MoneyFormat='#.##0,00 €;-#.##0,00 €'
2017-11-17 17:32:09 0007 SET TimeFormat='h:mm:ss TT'
2017-11-17 17:32:09 0008 SET DateFormat='D/M/YYYY'
2017-11-17 17:32:09 0009 SET TimestampFormat='D/M/YYYY h:mm:ss[.fff] TT'
2017-11-17 17:32:09 0010 SET FirstWeekDay=0
2017-11-17 17:32:09 0011 SET BrokenWeeks=1
2017-11-17 17:32:09 0012 SET ReferenceDay=0
2017-11-17 17:32:09 0013 SET FirstMonthOfYear=1
2017-11-17 17:32:09 0014 SET CollationLocale='el-GR'
2017-11-17 17:32:09 0015 SET MonthNames='Ιαν;Φεβ;Μαρ;Απρ;Μαϊ;Ιουν;Ιουλ;Αυγ;Σεπ;Οκτ;Νοε;Δεκ'
2017-11-17 17:32:09 0016 SET LongMonthNames='Ιανουάριος;Φεβρουάριος;Μάρτιος;Απρίλιος;Μάιος;Ιούνιος;Ιούλιος;Αύγουστος;Σεπτέμβριος;Οκτώβριος;Νοέμβριος;Δεκέμβριος'
2017-11-17 17:32:09 0017 SET DayNames='Δευ;Τρι;Τετ;Πεμ;Παρ;Σαβ;Κυρ'
2017-11-17 17:32:09 0018 SET LongDayNames='Δευτέρα;Τρίτη;Τετάρτη;Πέμπτη;Παρασκευή;Σάββατο;Κυριακή'
2017-11-17 17:32:09 0020 OLEDB CONNECT32 TO *** (XPassword *** ***)
2017-11-17 17:32:09 0022 let vqvdstorepath = 'C:\logistic-i\QvdFiles\'
2017-11-17 17:32:09 0031 table2_tmp:
2017-11-17 17:32:09 0032 sql select *
2017-11-17 17:32:09 0033 from ip_customeraddress
2017-11-17 17:32:09 21 fields found: ID, TRDRCODE, TRDRNAME, ADDRESS, CITY, PHONE, JOBS, TRDBRANCHNAME, SUBADDRESS, SUBCITY, AREA, SUBID, SUBCODE, BUNIT, EMPORIKICAT, MEGALOI_PELATES, PERIOXI_YPOK, AFM, EMPORIKH_KATHG, YPERPERIOXI, NOMOS,
2017-11-17 17:32:09 9.159 lines fetched
2017-11-17 17:32:09 0035 STORE table2_tmp into C:\logistic-i\QvdFiles\table2.qvd
2017-11-17 17:32:10 0036 DROP Table table2_tmp
2017-11-17 17:32:10 0038 table3_tmp:
2017-11-17 17:32:10 0039 SQL SELECT *
2017-11-17 17:32:10 0040 FROM FARMAS1."IP_PSIGEIA_QV"
2017-11-17 17:32:21 7 fields found: TRDRCODE, TRDRNAME, TRDBRANCHCODE, TRDBRANCHNAME, FRIGO, FRIGOSN, POSOTITA,
2017-11-17 17:32:21 778 lines fetched
2017-11-17 17:32:21 0042 STORE table3_tmp into C:\logistic-i\QvdFiles\table3.qvd
2017-11-17 17:32:21 0043 DROP Table table3_tmp
2017-11-17 17:32:21 0045 EXIT SCRIPT
2017-11-17 17:32:22 Execution finished.
but when i open the qvw file thru command batch file then no log file created !!