execute vbs doesn't work on QV Server

[#1]

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?

[danielrozental]

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.

[#3]

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/‌