"OutOfMemory" exception when listing subscriptions in "Report Manager"

Hi There,
We are having a problem in listing subscriptions in Report manager and
getting "OutOfMemory" exception.
Our Application has an event-based subscription management system, and
every-time an event gets fired on the Application-side, it creates an
one-off subscription on the Reporting Services. So overtime the number of
Subscriptions created on the reporting services has grown, and a particular
report has about 8000+ subscriptions to date now.
So when we try to list the subscriptions (for the purpose of management of
subscriptions) in the RS "Report Manager",
for that particular report, System gives an OutOfMemory exception. I think
Report Manager Calls internally
"ListSubscriptions" method (as explained in 840709) and couldn't cope up
with.
And i looked at MSDN Knowledgebase Article:840709, and increased the
"MemoryLimit" setting in RSReportServer.config, but there was no use.
By the way our Server has 2GB of RAM and we use Custom Authentication on
Reporting Services.
Any Suggestions are appreciated.
Regards
Raj ChidipudiI suggest you remove a number of the subscriptions via SQl Server Enterprise
Manager - remove a number of the relevant entries for the report from the
Subscriptions table.
Not tried it myself so I would backup before trying!!
You could also create an rss script to run at the end of day to remove all
subscriptions for a report, somthing like:
Public Sub Main()
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim subs As Subscription() = rs.ListSubscriptions(report, "")
If Not subs Is Nothing OrElse subs.Length > 0 Then
For Each subscript As Subscription In subs
rs.DeleteSubscription(subscript.SubscriptionID)
Next
End If
End Sub
Run it using the rs util with:
rs -i scriptname.rss -s http://ServerName/reportserver
Alan
"Raj Chidipudi" wrote:
> Hi There,
> We are having a problem in listing subscriptions in Report manager and
> getting "OutOfMemory" exception.
> Our Application has an event-based subscription management system, and
> every-time an event gets fired on the Application-side, it creates an
> one-off subscription on the Reporting Services. So overtime the number of
> Subscriptions created on the reporting services has grown, and a particular
> report has about 8000+ subscriptions to date now.
> So when we try to list the subscriptions (for the purpose of management of
> subscriptions) in the RS "Report Manager",
> for that particular report, System gives an OutOfMemory exception. I think
> Report Manager Calls internally
> "ListSubscriptions" method (as explained in 840709) and couldn't cope up
> with.
> And i looked at MSDN Knowledgebase Article:840709, and increased the
> "MemoryLimit" setting in RSReportServer.config, but there was no use.
> By the way our Server has 2GB of RAM and we use Custom Authentication on
> Reporting Services.
> Any Suggestions are appreciated.
> Regards
> Raj Chidipudi
>
>|||I think rs.DeleteSubscription("") would be the best bet.
We don't want to really mess with Reporting Services Database directly.
Anyway thanks for the suggestion.
Thanks
Raj Chidipudi
"Alan Byrne" <AlanByrne@.discussions.microsoft.com> wrote in message
news:116EB34B-1BD4-4FDC-ADB8-18BE795D3F22@.microsoft.com...
> I suggest you remove a number of the subscriptions via SQl Server
Enterprise
> Manager - remove a number of the relevant entries for the report from the
> Subscriptions table.
> Not tried it myself so I would backup before trying!!
> You could also create an rss script to run at the end of day to remove all
> subscriptions for a report, somthing like:
> Public Sub Main()
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> Dim subs As Subscription() = rs.ListSubscriptions(report, "")
> If Not subs Is Nothing OrElse subs.Length > 0 Then
> For Each subscript As Subscription In subs
> rs.DeleteSubscription(subscript.SubscriptionID)
> Next
> End If
> End Sub
> Run it using the rs util with:
> rs -i scriptname.rss -s http://ServerName/reportserver
> Alan
>
> "Raj Chidipudi" wrote:
> > Hi There,
> >
> > We are having a problem in listing subscriptions in Report manager and
> > getting "OutOfMemory" exception.
> >
> > Our Application has an event-based subscription management system, and
> > every-time an event gets fired on the Application-side, it creates an
> > one-off subscription on the Reporting Services. So overtime the number
of
> > Subscriptions created on the reporting services has grown, and a
particular
> > report has about 8000+ subscriptions to date now.
> >
> > So when we try to list the subscriptions (for the purpose of management
of
> > subscriptions) in the RS "Report Manager",
> > for that particular report, System gives an OutOfMemory exception. I
think
> > Report Manager Calls internally
> > "ListSubscriptions" method (as explained in 840709) and couldn't cope up
> > with.
> >
> > And i looked at MSDN Knowledgebase Article:840709, and increased the
> > "MemoryLimit" setting in RSReportServer.config, but there was no use.
> > By the way our Server has 2GB of RAM and we use Custom Authentication on
> > Reporting Services.
> >
> > Any Suggestions are appreciated.
> >
> > Regards
> > Raj Chidipudi
> >
> >
> >

"Mark for re-initialization" hangs

Hi, I have a problem with a SQL 2000 transactional replication.
It is a replication with subscriptions on several world wide located
servers.
A WAN connection has been disabled for some time and as result one
subscription has been marked inactive.
Message: "The subscription(s) have been marked inactive and must be
reinitialized. NoSync subscriptions will need to be dropped and
recreated."
In the past this problem could been solved by re-initializing the
subscription but in this case
the Enterprise Manager hangs, when I tried to mark the subscription
for re-initialization.
Both SQL servers (publisher and subscriber) have been re-started but
the problem remained.
There are no sessions on the subscriber database which could block the
initialization.
The subscription can not be deleted.
What more can I do?
can you issue this command in qa on the publisher in the publication
database?
sp_reinitsubscription
'publicationname','all','SubscriberName','subscrip tionDatabase'
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"hmb1963" <hmb1963@.gmx-topmail.de> wrote in message
news:1185358724.772454.145180@.k79g2000hse.googlegr oups.com...
> Hi, I have a problem with a SQL 2000 transactional replication.
> It is a replication with subscriptions on several world wide located
> servers.
> A WAN connection has been disabled for some time and as result one
> subscription has been marked inactive.
> Message: "The subscription(s) have been marked inactive and must be
> reinitialized. NoSync subscriptions will need to be dropped and
> recreated."
> In the past this problem could been solved by re-initializing the
> subscription but in this case
> the Enterprise Manager hangs, when I tried to mark the subscription
> for re-initialization.
> Both SQL servers (publisher and subscriber) have been re-started but
> the problem remained.
> There are no sessions on the subscriber database which could block the
> initialization.
> The subscription can not be deleted.
> What more can I do?
>
|||I tried out the stored procedure but the result was a hanging qa
without any status or error message.
|||use sp_who2 to identify locks/deadlocks caused by the replication processes
and selectively kill them,
Then try again.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"hmb1963" <hmb1963@.gmx-topmail.de> wrote in message
news:1185443077.713064.265760@.r34g2000hsd.googlegr oups.com...
>I tried out the stored procedure but the result was a hanging qa
> without any status or error message.
>
|||Success!
I have killed again all sessions both on the publisher and subscriber
databases and
then the stored procedure sp_reinitsubscription worked.
Many thanks for your support.
Martin