topic Re: Macro running does not end in QlikView

Macro running does not end

Anonymous — Sun, 14 Feb 2016 15:10:31 GMT

I have a macro in a QV which does not stop running and the QV document freezes. How do i end the running of the macro and what could be causing this?

Re: Macro running does not end

swuehl — Sun, 14 Feb 2016 15:19:33 GMT

You can kill the QV.exe process, this should stop everything.

Hard to tell what causes the macro not to stop, without knowing the code, but maybe a loop in your code with a missing / incorrect exit?

Re: Macro running does not end

Chanty4u — Sun, 14 Feb 2016 15:39:40 GMT

go to task manager and do end task of qvw.

Re: Macro running does not end

Anonymous — Sun, 14 Feb 2016 16:48:03 GMT

Swuehl many thanks, this is what i have been doing, stopping the QV.exe. Attached is the qv app

Re: Macro running does not end

Anonymous — Sun, 14 Feb 2016 16:49:31 GMT

Thank you for that

Re: Macro running does not end

sfatoux72 — Sun, 14 Feb 2016 16:55:13 GMT

There is not debug mode in macro editor, bur you could add msgbox('xxx') if VBscript or alert('xxx') if Jscript to identify loop without end (invalid exit condition, ...) or instruction waiting something, ...

Re: Macro running does not end

swuehl — Sun, 14 Feb 2016 23:20:22 GMT

I wasn't able to spot an easy candidate causing the freeze.

But since you are calling R COM object methods, I would try to check if these method calls could be problematic.

Also there are some FOR .. NEXT loops that depend on returned values from the R object.

So, as suggested before, try to add more e.g. msgbox() statements to get an idea where in the script the freeze occurs, and maybe also to get an idea of the state of your macro code (i.e. the values of variables, return codes, etc.)

You should be able to use similar code (at least for debugging the R calls) in Visual Studio for debugging, if necessary.

Re: Macro running does not end

HirisH_V7 — Mon, 15 Feb 2016 04:51:49 GMT

Hi ,

I cant Open Your App,

Can you post the macro you are using !!

Re: Macro running does not end

Anonymous — Mon, 15 Feb 2016 10:08:20 GMT

Many thanks Swuehl

Re: Macro running does not end

Anonymous — Mon, 15 Feb 2016 10:21:57 GMT

Herewith macro