topic Re: Execute script - Running an execute command in QlikView

Execute script - Running an execute command

Thu, 20 Jul 2017 02:15:29 GMT

Hello All,

I am running execute command successfully from qv 12 however the job earlier used to take around 1 minute and now takes around 30 minutes with execute in place.

04:27:31 0195 EXECUTE cmd.exe /C E:\Batchfile\Trigger.bat

2017-07-20 04:27:31 Running an execute command

2017-07-20 04:56:17 0197 exit Script

Any suggestions to fine tune this ? I do not want to block an engine process for so long.

Regards,

Nisha

Re: Execute script - Running an execute command

techvarun — Thu, 20 Jul 2017 03:38:06 GMT

is there any Loops in the script, Or synthetic keys? Please explain about the data model in detail

Re: Execute script - Running an execute command

Thu, 20 Jul 2017 03:59:47 GMT

Hello Varun,

There is absolutely no such data model issue as its a simple extractor job based on its trigger we are running an hourly application.

Extraction takes 1 min max and now on completion of extraction the bat file triggers the application which is taking 30 minutes.

Earlier it was on successful completion of extraction job but then when if timestamp check was failing we had given dummy load a from b script which is exit condition on failure, however we want to avoid any job failures hence on completion executing script.

Regards,

Nisha

Re: Execute script - Running an execute command

techvarun — Thu, 20 Jul 2017 04:13:04 GMT

Can you please check the Close when finished check-box is checked? Some time this simple check box end up showing a huge time in the log file.

Thanks,

Varun

Re: Execute script - Running an execute command

Thu, 20 Jul 2017 04:50:47 GMT

We are running through Publisher.

Re: Execute script - Running an execute command

rwunderlich — Thu, 20 Jul 2017 05:00:29 GMT

What does Trigger.bat do?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Execute script - Running an execute command

Thu, 20 Jul 2017 05:03:46 GMT

Hello Rob,

It triggers a task in publisher, I am using QMSEDX.exe to trigger it.

Regards,

Nisha

Re: Execute script - Running an execute command

rwunderlich — Thu, 20 Jul 2017 05:15:10 GMT

Check the parameters being passed to QMSEDX. There is a "-timeout" value which indicates how many seconds to wait for the task to complete. The default is 1 minute (your old behavior). Perhaps someone set it to 30 minutes or longer?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Execute script - Running an execute command

Thu, 20 Jul 2017 07:25:50 GMT

Hello Rob,

Many thanks, I passed a parameter for timeout and it is working as expected now.

Regards,

Nisha