topic Re: APPCRASH after running a macro in QlikView

APPCRASH after running a macro

Wed, 01 Jul 2015 23:58:04 GMT

Hello Community,

I have a batch file that opens a QlikView application, that has a series of instructions happening 'On Open', such as exporting a pivot chart and filtering data in a certain way. The last triggered event of the series, is quitting the application via a macro.

Here's the macro:

Sub QuitApplication

Set QvDoc = ActiveDocument

QvDoc.GetApplication.Quit

End sub

The end result is as expected (charts exported etc.) BUT QlikView seems to crash 8 times out of 10..

My QV version is 11.20.12664.0

See below printscreen of the error.

Any idea?

Thanks in advance,

Cristina

Re: APPCRASH after running a macro

vardhancse — Thu, 02 Jul 2015 02:34:25 GMT

Hi,

How you are running the batch file.?

Re: APPCRASH after running a macro

Thu, 02 Jul 2015 02:42:54 GMT

I set up a task on the server that runs the batch file...

Re: APPCRASH after running a macro

vardhancse — Thu, 02 Jul 2015 03:16:59 GMT

If you are reloading the dashboard, and there are any joins in the table once check that there is a common field between the table or not.

If we write join in script and there is no common field then also our app will be crashed/unresponsive

Re: APPCRASH after running a macro

Thu, 02 Jul 2015 04:28:06 GMT

Hello and thanks for the feedback.

I don't believe there is a problem with the joins. The script runs fine, it creates the right charts and associates fields appropriately.

If I wanted to leave QlikView open, I don't think I'd have an issue. It seems to be the close file and exit application instructions...

Re: APPCRASH after running a macro

marcus_sommer — Thu, 02 Jul 2015 04:46:22 GMT

Maybe some routines aren't ended when the next statement will be executed. I would try to put some WaitForIdle or Sleep statements between the routines. Also helpful could be to use a logging for the routines to see when which routines hangs and when it happens (set timestamps) and which variables has which value, see here what is meant:

Re: Error in a macro

- Marcus