BusinessObjects Board

BO Schedules sending duplicate emails

Hi,

BO Schedules sending duplicate emails
There are times when BO schedule sends duplicate email to business users may be twice or thrice. There is some time difference between the emails One Ex: Mail1 at 10:56 Mail2 at 11:16 .
Please advise.


its_ranjan (BOB member since 2011-02-16)

What do you see when you look at the history of the report’s schedule?


Bob Junior :uk: (BOB member since 2005-04-23)

Hi Bob,
Sorry for late response.
I heard that this issue is intermittent for last 3 years. The BOBJ version is BO XI R2 FP 3.2 and sits on AIX.
The schedule shows daily once though.


its_ranjan (BOB member since 2011-02-16)

Any pointers to help on this please?


its_ranjan (BOB member since 2011-02-16)

Holy cow that’s an old version. I’d suggest upgrading, if you can.

Do you have failure retries set? It’s possible that the schedule job is failing after the email is sent, then running again and sending another email.


joepeters :us: (BOB member since 2002-08-29)

Hi Joe,
There is no failure instances in the history for this schedule.
But just wondering which all places I need to look at to solve this.


its_ranjan (BOB member since 2011-02-16)

If it failed and then retried and completed successfully, there won’t be a failure instance.


joepeters :us: (BOB member since 2002-08-29)

Hmm… have you considered upgrading one way or the other?


Andreas :de: (BOB member since 2002-06-20)

You mentioned that the emails could be hours apart. How does that line up with the execution time of the schedule? If the schedule itself is running for hours (and includes the time that both of the emails were sent), then that would support my theory of failure retries.

Also, it’s possible that your SMTP server is re-sending the emails. Check out its logs if possible.


joepeters :us: (BOB member since 2002-08-29)

I am not sure how SMTP server is triggering the report schedules.
The schedule is just scheduled once and daily.
No schedule failure at all.
But 2 mails are sent within duration of around 15 minutes.


its_ranjan (BOB member since 2011-02-16)

Are the emails identical other than the time of sending/arrival?


Nick Daniels :uk: (BOB member since 2002-08-15)

The SMTP server is what is sending the email. It’s possible that BO is sending one request to the SMTP server to send the message, but the SMTP server is sending it twice.


joepeters :us: (BOB member since 2002-08-29)

The mails are identical that are sent twice to the mail recipient in duration of 15 minutes


its_ranjan (BOB member since 2011-02-16)

Try deleting the schedule and recreating it from scratch.


Nick Daniels :uk: (BOB member since 2002-08-15)

Hi Nick,

We tried this but still fails


its_ranjan (BOB member since 2011-02-16)

Speak to someone who can look at the logs on the SMTP server, as Joe said.


Nick Daniels :uk: (BOB member since 2002-08-15)