Prev: Table Filters and Empty Records
Next: Microsoft Responds to the Evolution of Online Communities
From: AlexW on 4 May 2010 20:26
Hi

SQL Server 2008 Standard Reporting Services running in Sharepoint integrated
mode. (Build 3790)
1 report with 2 subscriptions,
1st Subscription sends report once no CC
2nd Subscription sends report twice, looks identical except for
@ExecutionTime difference, 1 person CC on subscription.

Subscription UI shows start time: 1:22 pm

This is an inherited server and I have heard that the reports/subscriptions
etc were scripted from an old server.

Any ideas why this may be happening? How do I fix this?
This is happening for more than 1 report than just this example.

Log file:
library!WindowsService_37!3084!05/02/2010-13:22:19:: i INFO: Schedule
226816de-a4ec-4aba-9031-c214e1c002bf executed at 05/02/2010 13:22:19.
schedule!WindowsService_37!3084!05/02/2010-13:22:19:: Creating Time based
subscription notification for subscription:
d5203c1c-a49d-4bf1-a6f3-b90ca3893eee
library!WindowsService_37!3084!05/02/2010-13:22:19:: i INFO: Schedule
226816de-a4ec-4aba-9031-c214e1c002bf execution completed at 05/02/2010
13:22:19.
library!WindowsService_37!4bf4!05/02/2010-13:22:20:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system properties.
library!WindowsService_37!4bf4!05/02/2010-13:22:21:: i INFO: Initializing
SqlStreamingBufferSize to default value of '64640' Bytes because it was not
specified in Server system properties.
library!WindowsService_37!840!05/02/2010-13:22:22:: i INFO: Schedule
226816de-a4ec-4aba-9031-c214e1c002bf executed at 05/02/2010 13:22:22.
schedule!WindowsService_37!840!05/02/2010-13:22:22:: Creating Time based
subscription notification for subscription:
d5203c1c-a49d-4bf1-a6f3-b90ca3893eee
library!WindowsService_37!840!05/02/2010-13:22:22:: i INFO: Schedule
226816de-a4ec-4aba-9031-c214e1c002bf execution completed at 05/02/2010
13:22:22.

From: "Charles Wang [MSFT]" on 5 May 2010 07:03
Hi Alex,
Did your 2nd subscription send report twice at the same time or different
time?
For further diagnosing this issue, I need your help on collecting the
following information:
1. A backup of your ReportServer database
2. A backup of your msdb database

Please compress the files into a .zip file before send it to me. If the
.zip file is larger than 2MB, please first send
me(changliw_at_microsoft_dot_com) an email. Then I will let you know how to
upload large files to us via email.

Best regards,
Charles Wang

From: AlexW on 5 May 2010 16:25
Hi Charles

The 2nd subscription sent the report twice at the same time (3 seconds
different).

Thanks

""Charles Wang [MSFT]"" wrote:

> Hi Alex,
> Did your 2nd subscription send report twice at the same time or different
> time?
> For further diagnosing this issue, I need your help on collecting the
> following information:
> 1. A backup of your ReportServer database
> 2. A backup of your msdb database
>
> Please compress the files into a .zip file before send it to me. If the
> .zip file is larger than 2MB, please first send
> me(changliw_at_microsoft_dot_com) an email. Then I will let you know how to
> upload large files to us via email.
>
> Best regards,
> Charles Wang
>
> .
>
From: AlexW on 27 May 2010 17:59
So it seems that the nodes in the sharepoint web farm may both be processing
the subscriptions.

Does any one know how to stop this?

"AlexW" wrote:

> Hi Charles
>
> The 2nd subscription sent the report twice at the same time (3 seconds
> different).
>
> Thanks
>
> ""Charles Wang [MSFT]"" wrote:
>
> > Hi Alex,
> > Did your 2nd subscription send report twice at the same time or different
> > time?
> > For further diagnosing this issue, I need your help on collecting the
> > following information:
> > 1. A backup of your ReportServer database
> > 2. A backup of your msdb database
> >
> > Please compress the files into a .zip file before send it to me. If the
> > .zip file is larger than 2MB, please first send
> > me(changliw_at_microsoft_dot_com) an email. Then I will let you know how to
> > upload large files to us via email.
> >
> > Best regards,
> > Charles Wang
> >
> > .
> >
 | 
Pages: 1
Prev: Table Filters and Empty Records
Next: Microsoft Responds to the Evolution of Online Communities