Clever Geek Handbook

Subscription Schedule by Deadline in SSRS Send Duplicate Emails

I created a one-time subscription in SSRS 2008 Report Manager. However, I keep getting duplicate subscription emails. The interval between each letter is about 30 minutes.

I checked the SQL Agent job and saw that the SQL Agent job was created correctly. It runs only once, after which the next runtime is cleared.

I also checked the SMTP service on my local machine by checking the code. SMTP works fine for test email without duplication. So there is probably something wrong with SSRS. Any tips on where I can look?

0


source to share


2 answers


Updating this issue.

When I enable the reporting service log, the problem never recurs.

The following is added to the config file.



<system.diagnostics>
    <switches>
      <add name="DefaultTraceSwitch" value="3" />
    </switches>   </system.diagnostics>



<RStrace>
                  <add name="FileName" value="ReportServerService_" />
                  <add name="FileSizeLimitMb" value="32" />
                  <add name="KeepFilesForDays" value="5" />
                  <add name="Prefix" value="tid, time" />
                  <add name="TraceListeners" value="debugwindow, file" />
                  <add name="TraceFileMode" value="unique" />
                  <add name="HttpTraceFileName" value="ReportServerService_HTTP_" />
                  <add name="HttpTraceSwitches" value="date,time, clientip,username,serverip,serverport,host,method,uristem,uriquery,protocolstatus,bytesreceived,timetaken,protocolversion,useragent,cookiereceived,cookiesent,referrer" />
                  <add name="Components" value="all:3,http:4" />
  </RStrace>

However, we're not sure if the problem goes away if we delete the configuration section. We don't want to keep the log as it grows pretty fast.

+2


source


I would try to make sure no additional work was created. Maybe woven around the report server database and see if there are any back up scheduling entries - but it's hard to see how this won't show up in the UI.



Did you delete the subscription and recreate it?

0


source






More articles:


All Articles