topic Re: Auto Loading Not work in QlikView

Auto Loading Not work

logistici — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Auto Loading Not work

trdandamudi — Fri, 17 Nov 2017 00:08:10 GMT

Please look into the below link and hope this helps..

Reload and save using command line

Re: Auto Loading Not work

mgavidia — Fri, 17 Nov 2017 00:52:00 GMT

Loannis,

I do not see an: Exit Script; statement in the above script.

Maybe it gets hung in the process. Just a thought...

Re: Auto Loading Not work

rwunderlich — Fri, 17 Nov 2017 01:58:00 GMT

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

Re: Auto Loading Not work

logistici — Fri, 17 Nov 2017 08:34:22 GMT

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 .

Re: Auto Loading Not work

rwunderlich — Fri, 17 Nov 2017 16:22:22 GMT

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

Re: Auto Loading Not work

logistici — Fri, 17 Nov 2017 17:22:40 GMT

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 !!