topic Re: OnOpen Trigger - macro not working in QlikView

OnOpen Trigger - macro not working

gerhardl — Tue, 12 Feb 2013 14:29:29 GMT

Hi There,

I have a document with OnOpen triggers.

There are a few triggers, 3 that run macros to create excel reports, and 3 that run macro reloads, saves and quits the document.

The first excel report macros run perfectly, then when the 3rd one runs it opens the Edit Module and then just hangs there. There is no error message. If I click on Okay it then skips that macro and go on with the others (saves and quits).

I can run this macro from a button with no problems.

Any ideas on why this would happen?

I also have another document that should Open, Reload, Save and Quit. It works 95% of the time - but occasionally it just opens and triggers nothing.

I open both these files from a windows batch file.

I feel like the OnOpen triggers are very unreliable... I have no other explantion for why it would only work sometimes..

Any ideas?

Re: OnOpen Trigger - macro not working

marcus_sommer — Tue, 12 Feb 2013 14:53:07 GMT

It could have several causes, the network is sometimes too slow and a save-statement is not finish before the next step will exceute - try a sleep or wait statement between the macro parts. Also other windows server activities like windows shadow copies could break the execution without an error message - check the event logging on correlation.

- Marcus

Re: OnOpen Trigger - macro not working

gerhardl — Tue, 12 Feb 2013 15:02:21 GMT

Sorry, I should have mentioned that this is not on a server - it happens on QlikView Desktop, on a PC I use specifically for scripts and reporting purposes.

I do have a sleep between the reports - but I (for some reason) have them as separate macros. I'm going to add the sleep at the end or start of the report macros themselves, this way there are less macros to execute. Maybe that will help.

Thanks for the feedback.

Any other opinions/comments would be highly appreciated.

Re: OnOpen Trigger - macro not working

marcus_sommer — Wed, 13 Feb 2013 07:36:05 GMT

Another reason could be the start batch-parameter - try changing from /r to /l

http://community.qlik.com/message/296673#296673

- Marcus

Re: OnOpen Trigger - macro not working

gerhardl — Wed, 13 Feb 2013 07:44:01 GMT

I keep giving you half-detail, because I don't know what is relevant and what not. Apologies for that.

My Windows batch file looks like this:

PowerShell -file "C:\Documents and Settings\GERHARDL\My Documents\TENACITY\Scripts\QLIKVIEW_FILES_COPY.ps1"

So it actually calls a Powershell script, and fromthis PS script I Open the QV file.

This script is now actually busy executing as part of my morning scripts - I have moved around a few things and added additional sleep before the macro that was failing.

Will see if it works today.

Re: OnOpen Trigger - macro not working

gerhardl — Wed, 13 Feb 2013 07:50:40 GMT

Failed again.

Re: OnOpen Trigger - macro not working

marcus_sommer — Wed, 13 Feb 2013 08:00:26 GMT

Then change the PowerShell script from:

"D:\QlikView_Client\QV.exe" /r "D:\YOURFILE.qvw"

"D:\QlikView_Client\QV.exe" /l "D:\YOURFILE.qvw"

Some activities requires run with priority and not as background process.

- Marcus

Re: OnOpen Trigger - macro not working

gerhardl — Wed, 13 Feb 2013 08:23:06 GMT

The powershell script opens a file like this:

Invoke-Item "C:\Users\tenba1\Documents\QlikView\DAILY QV REPORTS.qvw"

I tried changing the priority here but have not figured out how yet. New to PowerShell.

Teh Scheduled Task (which launches the windows batch file) is set to run on the highest priority.

Thanks for the help - I'll keep playing around and hopefully I can figure it out.

Re: OnOpen Trigger - macro not working

Wed, 13 Feb 2013 08:26:09 GMT

Hey Gerhard,

Are you using On PostReload Trigger anywhere .. beacuse they are very unreliable as mentioned in QlikView Refrence Manual.

Also Please try giving system access to Macro module...CTRL+M opens the macro window.

On the left side you will see two drop downs, Try giving system access via that.

One more thing u can try is in documnet properties there is a security tab,

Select Appropriate options from that which might help you, For Eh: Allow Exoprt

Regards,

Utsav

Re: OnOpen Trigger - macro not working

gerhardl — Wed, 13 Feb 2013 08:33:44 GMT

Hi Utsav,

No, I only use OnOpen triggers.

System access was already given in the Module.

I did notice in the document security tab that the "Macro Override Security" box was not ticked. I have now ticked this. Not sure if this will make a difference since I can run the macro fine from a button?

What I also now did, was to not run the problem macro on its own anymore, but rather to add this macro's code to another macro that currently runs without problems. So I now have one macro that does two completely different things... which I don't like doing, but now I have one less trigger.

It works when I kick it off manually (but it always does) - so I'll see what happens tomorrow morning.

Thanks.

Re: OnOpen Trigger - macro not working

marcus_sommer — Wed, 13 Feb 2013 08:33:55 GMT

I work not with PowerShell and have thought the syntax is the same as batch, but perhaps a start-parameter is set as default and another parameter can added.

Otherwise Utsav had right, the security settings from module must allow extern access.

- Marcus

Re: OnOpen Trigger - macro not working

Thu, 03 Jul 2014 09:11:31 GMT

Hi, i too faced same kind of situation what you explained while using multiple macro calls in OnOpen trigger.

I had just added extra line in macro i.e; ActiveDocument.GetApplication.WaitForIdle then it got resolved my problem.

So in your case just add the macro line "ActiveDocument.GetApplication.WaitForIdle" above your "Reload" line in 3rd macro.

I hope it will helps you. Plz let me know if that works for you.

Regards,

Satish.A

Re: OnOpen Trigger - macro not working

Thu, 03 Jul 2014 09:14:47 GMT

What client are you using, when open? AJAX or plugin?

Re: OnOpen Trigger - macro not working

vardhancse — Thu, 03 Jul 2014 10:34:19 GMT

Ajax or else IE plugIn.

Because only in IE plugin mode the macros will work.