November 24, 2010 at 12:48 pm
I am in an environment where I inherited a number of legacy reports which means people no longer with the company set up the Reporting Services environment.
Whenever I create a NEW Subscription on a legacy report or one that I create, the report will sit for over an hour and then fail.
I discovered if I created a new Subscription that was scheduled to run in the past, the Subscription would be created but never actually run. I then change the OwnerID field in the Subscriptions table to the person previous to me and the report will run with no problems.
So... apparently there is a Rights issue with me being the creator of a Subscription. I've been unable to find any solution to this.
I appeal to all ye Sages, Gurus, and Brainiacs: Any ideas on how I can create a new Subscription so that it will like me as the owner?
Thanks
December 13, 2010 at 9:55 am
I had a similar issue, we removed one of the subscription report owners from Active Directory and the subscriptions failed.
I thought a Update of the subscription would do it but the subscriptions still failed.
I had to to a select-insert based on the failure message. Substituting my id.
Something like this if it helps anyone
INSERT INTO [LiveReportServer].[dbo].[Subscriptions]
([SubscriptionID]
,[OwnerID]
,[Report_OID]
,[Locale]
,[InactiveFlags]
,[ExtensionSettings]
,[ModifiedByID]
,[ModifiedDate]
,[Description]
,[LastStatus]
,[EventType]
,[MatchData]
,[LastRunTime]
,[Parameters]
,[DataSettings]
,[DeliveryExtension]
,[Version])
SELECT newid()
,'B2A76AE5-7270-4DA6-A8D2-433F4270C523'
,[Report_OID]
,[Locale]
,[InactiveFlags]
,[ExtensionSettings]
,'B2A76AE5-7270-4DA6-A8D2-433F4270C523'
,getdate()
,[Subscriptions].[Description]
,null
,[EventType]
,[MatchData]
,null
,[Parameters]
,[DataSettings]
,[DeliveryExtension]
,[Version]
-- ,[Path]
-- ,[Name]
FROM [LiveReportServer].[dbo].[Subscriptions]
inner join Catalog on [LiveReportServer].[dbo].[Subscriptions].Report_OID = Catalog.ItemID
where LastStatus like '%failure%'
order by 1
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply