topic Re: execute vbs doesn't work on QV Server in QlikView

execute vbs doesn't work on QV Server

Fri, 30 Aug 2013 16:15:12 GMT

Hi all!

I need .dbf to convert to .xlsx for my developing.

I had created vbscritp as converter (attached) and i tried to execute this file ( .vbs) in my script.

If i do it via QV Desctop - my .dbf will convert to .xlsx and everything is fine.

But if i try to reload this task on QV Server - my scrtipt will hang and do nothing. I generate a log. There is nothing in log : my script execute all function before function "EXECUTE cmd.exe /C "C:\QV_documents\Convert dbf\ConvertToExcel.vbs";". It isn't failed, it happens nothing.

Also i execute another app like .exe for load dbf from source on disc C and it works fine.

Could any help me?

Re: execute vbs doesn't work on QV Server

danielrozental — Fri, 30 Aug 2013 16:24:15 GMT

Do you have excel installed on the server?

Can you try loggin in with the user running the qlikview services and using the QV Desktop to run the QVW and see if it works fine? You're probably getting some security pop up confirmation or something.

Re: execute vbs doesn't work on QV Server

Thu, 08 Dec 2016 13:04:41 GMT

Hi, Ksenia Babikhina

I had the same issue and I solved modifying the Settings.ini file. see step below:

1- Go to the directory: C:\ProgramData\QlikTech\QlikViewServer

1- Open file Settings.ini

2- Add next command: AllowExecuteCommand=1

3- On each QlikView document, inside to the script block, go to Settings tab (below) and select

Can Execute External Programs

Here you are the references: http://qlikviewcookbook.com/2016/01/authorizing-the-script-execute-statement/‌