BusinessObjects Board

BCA sending multiple emails, without a reason

Hi All,

I searched in BOB and could not get an answer.

I have a FC report which was scheduled to refresh daily in BCA around 6 months ago.
It has a macro which sends an email.

All of a sudden, it is now sending out around 6-8 emails every day and the Users are complaining that they are being bombarded with too many mails.

We are using BCA 5.5.6 and BO FC 5.1.6

Thanks,
Vijay


Vijayp :india: (BOB member since 2003-02-13)

Ran into this problem too!
There might be a problem with an Action step after the email macro step which causes the report to fail (but not until after sending the email). The BCA retries (to the defaulted 5x) and that might be the reason why it sends out multiple times.

Hope this helps.

Tom


tomattm :canada: (BOB member since 2003-07-31)

Could you share the code for sending email in the macro after the report refresh ?

Thanks


neelutauh (BOB member since 2002-08-16)

Actually, I’d put it in the BeforeClose event and not AfterRefresh.


dirmiger :us: (BOB member since 2002-08-28)

Have you looked through the downloads available ?
This might be what you are looking for:
https://bobj-board.org/t/15915


Michele Pinti (BOB member since 2002-06-17)