topic Re: Macro not sending PDF email in QlikView

Macro not sending PDF email

Anonymous — Tue, 20 Feb 2018 07:45:16 GMT

Hello Friends

We have a Dashboard wherein I have a VB Script macro which exports a report to PDF and emails to the users.

It works find when run manually.

When we trigger the application reload with the help of a Batch file (.bat file) it reloads the application successfully and also generates the PDF report in desired folder. However it does not sends the Email. (Have used OnPostReload --> Run Macro)

Batch File -----> Reload the Application --> OnPostReload -- > RunMacro ---> Send PDF report email.

The above scenario runs well when we manually reload the dashboard. The email is sent successfully once macro is triggered after reload.

However the email is not sent when we reload the dashboard with batch file. Only the PDF is generated in given path.

Is there something we are missing to get the emails sent while relaoding the dashboard with batch file?

Kindly help to resolve above issue. Let me know if you need any further details.

Thanks & Regards

Chintan Gala

Re: Macro not sending PDF email

marcus_sommer — Tue, 20 Feb 2018 14:24:01 GMT

The reasons are issues with the access rights of the user and/or the process and/or settings of the user. I hope the following postings are helpful for you:

Re: Sending mails macro vbs

Re: 'Execute' statement in QVW file under QMC

- Marcus

Re: Macro not sending PDF email

Anonymous — Wed, 21 Feb 2018 06:57:31 GMT

Dear Marcus

Thanks for your reply.

Reading your links, we replaced /r with /I in the batch file. However the dashboard did not get reload with this.

Are we missing some trick?

Thanks & Regards

Chintan Gala

Re: Macro not sending PDF email

marcus_sommer — Wed, 21 Feb 2018 07:48:34 GMT

Normally it should work whereby the obvious difference is that with /l the applications remains open when the reload is finished. But maybe there are more differences ... maybe in way how this process is handled. With /r it's a kind of background-process and with /l it's like a normal GUI process and there might be differences which dll's are loaded respectively could be accessed and/or in which user-context the process happens.

Therefore with which user did you try to execute this batch and which rights and user-settings are set for him? Depending on how this batch is triggerred there might be none user which meant the windows default-user with his settings is taken.

- Marcus

Re: Macro not sending PDF email

Anonymous — Wed, 21 Feb 2018 08:10:45 GMT

Dear Marcus

Have logged in to the server with Admin ID and executed the batch. How can we check the rights for the batch file/ windows?

Thanks & Regards

Chintan Gala

Re: Macro not sending PDF email

marcus_sommer — Wed, 21 Feb 2018 08:29:47 GMT

Could you with the admin-user open the application and do a manually reload?

- Marcus

Re: Macro not sending PDF email

Anonymous — Wed, 21 Feb 2018 09:41:41 GMT

Yes we can do a manual reload.

Post manual reload it triggers the macro (OnPostReload ---> Run Macro) and it successfully sends the email

as well. Only when the application is reloaded through batch file , the email is not sent. Only the file is generated in the folder.

Thanks & Regards

Chintan Gala

Re: Macro not sending PDF email

marcus_sommer — Wed, 21 Feb 2018 10:08:07 GMT

How is the batch triggerred - manually, per EXECUTE statement, windows tasks, another way?

- Marcus

Re: Macro not sending PDF email

Anonymous — Wed, 21 Feb 2018 10:36:02 GMT

The batch is scheduled in Windows Task Scheduler.

Re: Macro not sending PDF email

marcus_sommer — Wed, 21 Feb 2018 10:50:52 GMT

In which user-context runs this task? Is there none specified the task will run with the windows default-user.

- Marcus

Re: Macro not sending PDF email

Anonymous — Wed, 21 Feb 2018 11:05:26 GMT

It may be running as default user, not aware how to set the context for the task scheduler.

Kindly help how can we set the same.

Re: Macro not sending PDF email

marcus_sommer — Wed, 21 Feb 2018 12:05:43 GMT

I mean these settings within the task-planner:

- Marcus

Re: Macro not sending PDF email

Anonymous — Wed, 21 Feb 2018 12:44:09 GMT

Hello Marcus

The Windows Task scheduler is running with admin privileges.

Kindly find atatched screenshot -- task_scheduler.

Thanks & Regards

Chintan Gala

Re: Macro not sending PDF email

marcus_sommer — Wed, 21 Feb 2018 14:30:33 GMT

Unfortunately for me it never worked without a user-login and therefore I use the first option like in my screenshot. Pure logically it should also work with the other options but I think there are some essential settings or configurations missing and I'm not admin enough to find the real cause (and my workaround with the login works well since years). Maybe pcammaert could shed some light.

- Marcus

Re: Macro not sending PDF email

Anonymous — Wed, 21 Feb 2018 14:51:23 GMT

Thanks Marcus. I will also try with the same settings as in your screenshot .

Meanwhile could you route this thread to others who may provide necessary settings required to resolve this.

Thank you again for your time and insights provided.

Re: Macro not sending PDF email

Peter_Cammaert — Thu, 22 Feb 2018 08:36:58 GMT

I'm not really sure how I can be of help. I should note that I switched to using/promoting/supporting NPrinting a while ago, mostly for reasons of reliability and easy of deployment.

Chintan, is the macro reponsible for generating the PDF and sending the email?

Re: Macro not sending PDF email

marcus_sommer — Thu, 22 Feb 2018 09:07:01 GMT

I agree that using NPrinting will be in many cases a more reliable and cost-effective solution as to fiddle with all the macro-stuff and how to execute it properly.

I hoped you could give a hint why (at least in my case) it only worked when I'm logged in - all other options failed and I think the reasons are some missing configurations / rights but I have no idea which one it could be.

- Marcus

Re: Macro not sending PDF email

Anonymous — Thu, 22 Feb 2018 09:37:06 GMT

Dear Peter

Yes, the macro is responsible for PDF generation and emailing the same.

The PDF gets generated but email is not being sent.

If we reload the application manually it also sends the email successfully.

But if we schedule batch file to reload the application, it only generates the PDF in folder but does not send email.

Thanks & Regards

Chintan Gala

Re: Macro not sending PDF email

Peter_Cammaert — Thu, 22 Feb 2018 11:28:47 GMT

Then you will be able to capture failure information in your macro. If your system isn't able to forward your email for any reason whatsoever, it should indicate this by returning an error code or some kind of failure response. That will be helpful for figuring out where exactly we need to look for missing configuration information, or insufficient privileges or whatever.

Without this kind of information, it will be like shooting in the dark.

Re: Macro not sending PDF email

Anonymous — Thu, 22 Feb 2018 12:30:55 GMT

Hello Peter

Okay you mean we need to capture the logs by putting some script in the macro?

currently we are not using anything in the script to capture the logs.

Thanks & Regards

Chintan Gala