i am getting the error in multiple subscrptions at a time.My report was not capturing the seconds transactions data?

Question

question

limitha asked Mar 5, '13

i am getting the error in multiple subscrptions at a time.My report was not capturing the seconds transactions data?

I have scheduled the multiple subscriptions at every one hour. My problem is report was not capturing the seconds data? Ex: 10.00 AM subscribed. Means data captured 9 am to 10 AM but 9.00.04 Data was not captured.

sql-server-2005 ssrs-2005 ssrs-subscription

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-03-05T09:49:13Z

raadee answered Mar 5, '13

Any delays? You can check your jobstatus with (against reporting database, change database name if your reporting database has a non default name):

4

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raadee commented · Mar 05, 2013 at 09:49 AM

select 'SubnDesc' = s.Description, 'SubnOwner' = us.UserName, 'LastStatus' = s.LastStatus, 'LastRun' = s.LastRunTime, 'ReportPath' = c.Path, 'ReportModifiedBy' = uc.UserName, 'ScheduleId' = rs.ScheduleId, -- This is what you need 'SubscriptionId' = s.SubscriptionID from ReportServer.dbo.Subscriptions s join ReportServer.dbo.Catalog c on c.ItemID = s.Report_OID join ReportServer.dbo.ReportSchedule rs on rs.SubscriptionID = s.SubscriptionID join ReportServer.dbo.Users uc on uc.UserID = c.ModifiedByID join ReportServer.dbo.Users us on us.UserID = s.OwnerId

0 ·

limitha commented · Mar 05, 2013 at 10:06 AM

No delay. Some times it takes the 10 to 15 mins for file generation.

0 ·

raadee commented · Mar 05, 2013 at 10:13 AM

If you run the t-sql from the report manually in SMSS, do you encounter the same problem?

0 ·

limitha commented · Mar 05, 2013 at 10:38 AM

No. If i run the SP from the report manually in SSMS it takes only 4 to 5 sec only.

0 ·

question