Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Auto Loading Not work

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

6 Replies
Highlighted
Master II
Master II

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

Reload and save using command line

Highlighted
Creator
Creator

Loannis,

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

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Contributor II
Contributor II

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 .

qlik.jpg

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Contributor II
Contributor II

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