Duplicate emails being sent for subscription

Hi folks,
We have a report that is emailed to three users (one "To" and two "Cc")
at 6:45am every weekday.
As of applying SP2 earlier this week, each user is receiving two copies
(generated about 2 seconds apart) in their inbox.
There's one curious difference between the two emails: One comes from
'sqlreports@.ourdomain.com.au' and the other comes from
'SQLReports@.ourdomain.com.au'. The case of the sender name is the only
difference.
Has anyone any clues as to where I can look to resolve this?
Cheers,
Matt HamiltonThat is certainly strange. The from user comes from the config file and
should be unique to the report server. Did you have a web farm set up? Is
it possible there is another Report Server pointed at this DB.
Things you can look at:
Check the subscription tab of the report as a user with Content Manager
permission and see if there are two subscriptions.
How many rows are in the keys table?
Check the ReportServerService<timestamp>.log file and see if the
subscription is being processed more then once.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mabster" <mhamilton@.qafmeats.nospam.com.au> wrote in message
news:eYIb4ZHTFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Hi folks,
> We have a report that is emailed to three users (one "To" and two "Cc") at
> 6:45am every weekday.
> As of applying SP2 earlier this week, each user is receiving two copies
> (generated about 2 seconds apart) in their inbox.
> There's one curious difference between the two emails: One comes from
> 'sqlreports@.ourdomain.com.au' and the other comes from
> 'SQLReports@.ourdomain.com.au'. The case of the sender name is the only
> difference.
> Has anyone any clues as to where I can look to resolve this?
> Cheers,
> Matt Hamilton|||Daniel Reib (MSFT) wrote:
> That is certainly strange. The from user comes from the config file and
> should be unique to the report server. Did you have a web farm set up? Is
> it possible there is another Report Server pointed at this DB.
> Things you can look at:
> Check the subscription tab of the report as a user with Content Manager
> permission and see if there are two subscriptions.
> How many rows are in the keys table?
> Check the ReportServerService<timestamp>.log file and see if the
> subscription is being processed more then once.
>
Thanks for the prompt reply, Daniel.
I'm going to go bitchslap the developer who asked me about this (and I
should have looked harder at it myself before posting, so that's one
more bitchslap).
She'd set the same subscription up on two different servers. Not a web
farm or anything, just duplicate reports each emailing themselves at the
same time.
Thanks again,
Matt|||Well, that's good to hear. Be nice to the developers!!! Occasionally (but
rarely) they do make mistakes. :)
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mabster" <mhamilton@.qafmeats.nospam.com.au> wrote in message
news:%237Qwt$HTFHA.336@.TK2MSFTNGP09.phx.gbl...
> Daniel Reib (MSFT) wrote:
>> That is certainly strange. The from user comes from the config file and
>> should be unique to the report server. Did you have a web farm set up?
>> Is it possible there is another Report Server pointed at this DB.
>> Things you can look at:
>> Check the subscription tab of the report as a user with Content Manager
>> permission and see if there are two subscriptions.
>> How many rows are in the keys table?
>> Check the ReportServerService<timestamp>.log file and see if the
>> subscription is being processed more then once.
>>
> Thanks for the prompt reply, Daniel.
> I'm going to go bitchslap the developer who asked me about this (and I
> should have looked harder at it myself before posting, so that's one more
> bitchslap).
> She'd set the same subscription up on two different servers. Not a web
> farm or anything, just duplicate reports each emailing themselves at the
> same time.
> Thanks again,
> Matt