APPCRASH after running a macro

[#1]

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

[vardhancse]

Hi,

How you are running the batch file.?

[#3]

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

[vardhancse]

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

[#5]

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...

[marcus_sommer]

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