Qlikview OnPostReload Trigger not working with Windows Task Scheduler
Hello. I am new to Qlikview and this is my first time asking a question. We have a qlikview application that gets reloaded each morning around 4am. We had created a macro sub to export certain exhibits to an excel file. This macro works perfectly when we physically perform a reload using the OnPostReload Trigger and also when using a button to call this macro. However, when scheduling a task on a virtual machine to run daily overnight, this does not occur. We have tried to build it into the reload script, but have found many entries in the community about how only a function macro can be called, not a sub macro. Any thoughts?
Hello, macro has a security configuration by user, and exporting data to a system file needs the user to allow access to file system.
Maybe the user that executes the reload doesn't has that permision. Have you tried to log as the user that executes the task and try the execution with that user?... or change the user that executes the ask to one that has configuared module access.
If you have Qlik opened you can access the module security configuration pression CTRL+SHIFT+M, you need to allow access to the system.
The issue you are going to have with an OnPostReload trigger in this case is a conflict between the trigger and the -r option of QV.exe call, as the -r wants to close the QV.exe process as soon as the Reload completes, this is by design, so OnPostReload triggers will not work consistently, if at all in this scenario. You would need to convert this to another trigger that will not conflict such as OnOpen or some other mechanism.
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
