topic Execute powershell command in qv script and reload using distribution service in QlikView

Execute powershell command in qv script and reload using distribution service

rafalcqlik — Thu, 08 Jun 2017 15:47:54 GMT

Hi, I created script in qv to download file from Web page using powershell + BITS. Everything is working fine when I reload document manually but when I run it through management control or just wait for scheduled start, it's not working. There is no error or anything but it just won't download file. I'm log file I can see the script and it looks like there is no issue but I don't get any file. I checked allow to execute external program in document properties. What can be wrong here?

My script:

Let vCOMMAND = 'Import-Module BitsTransfer

Start-BitsTransfer -Source http://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?file=table_of_contents.xml -Destination D:\QLIKVIEW\Dane\WEB\EUROSTAT\table_of_contents.xml';

Execute powershell -command $(vCOMMAND);

Thanks in advance

Re: Execute powershell command in qv script and reload using distribution service

Lech_Miszkiewicz — Fri, 09 Jun 2017 05:16:59 GMT

does the user running your QlikView service has an access to this file/rights to execute command statement. Remember, that running it localy you are running it with your credentials, when triggering from server you are using service account credentials.

pozdr.

Lech

Re: Execute powershell command in qv script and reload using distribution service

rafalcqlik — Fri, 09 Jun 2017 06:05:18 GMT

Yes, it has access to that file. It's the same user. QlikView Service is running on the same user I'm using to develop documents. It has full admin rights.

Re: Execute powershell command in qv script and reload using distribution service

Lech_Miszkiewicz — Sat, 10 Jun 2017 02:03:55 GMT

check this topic and see whether you are missing something:

https://qlikviewcookbook.com/2016/01/authorizing-the-script-execute-statement/

cheers

Lech

Re: Execute powershell command in qv script and reload using distribution service

rafalcqlik — Wed, 14 Jun 2017 19:58:33 GMT

I also found this topic and tried that before I created new discussion. Nothing works...

Re: Execute powershell command in qv script and reload using distribution service

rafalcqlik — Wed, 14 Jun 2017 22:28:57 GMT

Ok, I found the problem. For some reason powershell command:

Import-Module BitsTransfer

Start-BitsTransfer -Source http://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?file=table_of_contents.xml -Destination D:\QLIKVIEW\Dane\WEB\EUROSTAT\table_of_contents.xml

was not working when reloading with distribution service.

But this one works:

Invoke-WebRequest -Uri http://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?file=table_of_contents.xml -OutFile D:\QLIKVIEW\Dane\WEB\EUROSTAT\table_of_contents.xml

Both commands work fine when reloading manually in QlikView desktop.

Re: Execute powershell command in qv script and reload using distribution service

Lech_Miszkiewicz — Wed, 14 Jun 2017 23:49:58 GMT

Good kn you mate!