Trigger and Scheduled Load via Management Console

carolin01 — Tue, 02 Feb 2016 09:27:51 GMT

Hi,

I´ve set some triggers in my application that should change some variables and tried both cases: "On Opening" and "OnPostRelaod". The issue is that I can see in the log file that after the scheduled relaod via the Management Console the variable hasn´t been changed to the new value. Example:

I set the following trigger to set the value for the variable "vDocumentType":

=if(SubStringCount(DocumentName(),'Test')='1', 'Test',if(SubStringCount(DocumentName(),'Live')='1', 'Live', if(SubStringCount(DocumentName(),'Development')='1', 'Development', 'Invalid File Name - Check vDocumentType')))

Then I use the variable in my binary load in my script:

Binary [$(vScriptPath)\scripting financial sales application $(vDocumentType) security.qvw];

Next my document gets a new name and includes the word "Live". Because of this my trigger should set the value of the variable "vDocumentType" to "Live" instead of "Test". The trigger is working if I manually reopen the document. I expected this to be working also automatically without having to open the document once more by hand, because I thought that in the background the management console also opens the document and then this would activate the trigger. But this is what happens:

Extraction of the log file after the scheduled reload via the Management Console:

02.02.2016 09:36:34: Execution started.
02.02.2016 09:36:34: QlikView Version:11.20.12664.0
02.02.2016 09:36:34: CPU Target x64
02.02.2016 09:36:34: Operating System Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)
02.02.2016 09:36:34: Wow64 mode Not using Wow64
02.02.2016 09:36:34: MDAC Version 6.1.7601.17514
02.02.2016 09:36:34: MDAC Full Install Version 6.1.7601.17514
02.02.2016 09:36:34: PreferredCompression 2
02.02.2016 09:36:34: EnableParallelReload 1
02.02.2016 09:36:34: ParallelizeQvdLoads 1
02.02.2016 09:36:34: AutoSaveAfterReload 0
02.02.2016 09:36:34: BackupBeforeReload 0
02.02.2016 09:36:34: EnableFlushLog 0
02.02.2016 09:36:34: SaveInfoWhenSavingFile 0
02.02.2016 09:36:34: UserLogfileCharset 1200
02.02.2016 09:36:34: OdbcLoginTimeout -1
02.02.2016 09:36:34: OdbcConnectionTimeout -1
02.02.2016 09:36:34: ScriptWantsDbWrite false
02.02.2016 09:36:34: ScriptWantsExe false
02.02.2016 09:36:34: LogFile CodePage Used: 1200
02.02.2016 09:36:34: Reload Executed By EU\qlikviewservice
02.02.2016 09:36:34: Process Executing: QVB
02.02.2016 09:36:34: Process ID: 14696
02.02.2016 09:36:34: 0002 Binary [..\02 Skript-Files\scripting financial sales application Test security.qvw]

As you can see the name is still "Test" instead of "Live". I would like to use such a function in many different ways so that the solution should include that this works automatically. Reopening of the document is not a solution because the document needs 20 Minutes to open. Any idea?

Many thanks in advance

Re: Trigger and Scheduled Load via Management Console

jonathandienst — Tue, 02 Feb 2016 09:38:34 GMT

The OnOpen and OnPostReload triggers are not fired when the document is hosted and reloaded in QV server.

I would suggest setting the variables in the script, but you cannot do that before a binary load. Have you invertstigated passing the variable as a parameter. In a batch load from QV desktop. you would use the /v switch. I think you can set a a parameter in server as well, but I don't have one available to check.

Example in desktop: qv.exe /r /vvDocumentType=Live abc.qvw

Re: Trigger and Scheduled Load via Management Console

carolin01 — Tue, 02 Feb 2016 13:18:07 GMT

Thank you!

topic Re: Trigger and Scheduled Load via Management Console in QlikView

Trigger and Scheduled Load via Management Console

Re: Trigger and Scheduled Load via Management Console

Re: Trigger and Scheduled Load via Management Console