topic Re: VB Script Issue in QlikView

VB Script Issue

svenkita — Sun, 12 Jul 2015 13:09:00 GMT

I have written a qlikview report and have a VB script to run the report and generate the pdf. The same runs fine on my laptop which is running window 8.1

when I deploy it on the clients server that is running windows 2008 R2 it gives me an error.. (Attached is the error).

I following is scaled down version of the script script which I currently have on my vbs script and all I expect it to do is open the document sleep for 2000 mili seconds close and quit, but it is giving me an error

Current script in my vbs

Set MyApp = CreateObject("QlikTech.QlikView")

Set MyDoc = MyApp.OpenDoc ("D:\TestQlikview\ReverseEng.qvw")

MyDoc.GetApplication.Sleep 2000

MyDoc.CloseDoc

MyApp.Quit

Re: VB Script Issue

swuehl — Sun, 12 Jul 2015 13:14:11 GMT

Is there a desktop client installed on that server?

Re: VB Script Issue

svenkita — Sun, 12 Jul 2015 13:17:15 GMT

I remote on to the server & run the script at the dos prompt of the server ...

I also tried the cscript command. but gives the same error.

Re: VB Script Issue

swuehl — Sun, 12 Jul 2015 15:19:34 GMT

No, I was asking if there is a desktop QV client installed on that server.

I believe you need a QV desktop client to make above object call work.

I also assume that the QVW exists in the folder path you've stated in second line's argument and you are giving a full absolute path, not a relative path.

Other than that, I don't have an idea why it's failing. It's working on my side on a 2008R2 server.

Re: VB Script Issue

svenkita — Sun, 12 Jul 2015 19:09:24 GMT

Yes the qlikview desktop client is installed

i changed to absolute path just to ensure that i am considering the right file from right place

Re: VB Script Issue

swuehl — Sun, 12 Jul 2015 19:13:24 GMT

And it' still failing?

I do get the error message with an relative path, but it works fine with an absolute.

You see the QV application opening and an 'Opening failed' error?

Re: VB Script Issue

svenkita — Sun, 12 Jul 2015 23:31:01 GMT

I have converted the vb script to a macro

executing the same onOpen trigger

and have written a batch file to call the file

This is currently working.

Absolutely no idea why the VBScript is not working on that server. Will schedule a restart for the server and check later

Re: VB Script Issue

jagan — Mon, 13 Jul 2015 03:18:48 GMT

Hi,

Instead of writing this in VB script, it is always suggestible to write it as a macro and call that after the document is reloaded. You will have better control on this.

Hope this helps you.

Regards,

Jagan.