Help! - My subscriptions are being deleted !?

Problem: My subscriptions are being deleted, I guess when i re-deploy the
reports?
It has happend twice, but I do not know the reason, It just seems to happen!
As of today, we use 6 different subscriptions, 3 of which produce 6000
reports to be distributed to email recipients, and 3 producing reports to a
shared disk.
As you can see, to reproduce the subscriptions tak some time!
Anyone with the same experience ?
Further info:
There are two devlopers developing in the same .NET 2003 report project, and
deploing to the same reporting services server. A C# application is developed
to add/delete subscriptions, but the deleted once is not reachable from the
application.
Greatful for any reply on this !Although I haven't tried to duplicate your problem,,, Is it possible that
sometimes you are deleting the report, then re-deploying it?
That will cause permissions, default parameters, subscriptions to go away,
even if you redeploy the report with the same name.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"frankiebody" <frankiebody@.discussions.microsoft.com> wrote in message
news:BF1285A1-5DB8-433E-A961-9791C3E77555@.microsoft.com...
> Problem: My subscriptions are being deleted, I guess when i re-deploy the
> reports?
> It has happend twice, but I do not know the reason, It just seems to
> happen!
> As of today, we use 6 different subscriptions, 3 of which produce 6000
> reports to be distributed to email recipients, and 3 producing reports to
> a
> shared disk.
> As you can see, to reproduce the subscriptions tak some time!
> Anyone with the same experience ?
> Further info:
> There are two devlopers developing in the same .NET 2003 report project,
> and
> deploing to the same reporting services server. A C# application is
> developed
> to add/delete subscriptions, but the deleted once is not reachable from
> the
> application.
> Greatful for any reply on this !
>
>|||Thanks for response !
I think i found the problem (I hope). The cleanup agent in SQL server is
running a session every 336 = 14 days. Cleaning/deleting all "expired"
subscriptions!
I've just alterede the procedure, removing the line actually performing the
deletion, from the procedyre "CleanExpiredSubscriptions"
I suppose I could sett a property to "0" somewhere to achieve the same
result, but I'm not sure where...
Frank Gryte
"Wayne Snyder" wrote:
> Although I haven't tried to duplicate your problem,,, Is it possible that
> sometimes you are deleting the report, then re-deploying it?
> That will cause permissions, default parameters, subscriptions to go away,
> even if you redeploy the report with the same name.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "frankiebody" <frankiebody@.discussions.microsoft.com> wrote in message
> news:BF1285A1-5DB8-433E-A961-9791C3E77555@.microsoft.com...
> > Problem: My subscriptions are being deleted, I guess when i re-deploy the
> > reports?
> > It has happend twice, but I do not know the reason, It just seems to
> > happen!
> > As of today, we use 6 different subscriptions, 3 of which produce 6000
> > reports to be distributed to email recipients, and 3 producing reports to
> > a
> > shared disk.
> >
> > As you can see, to reproduce the subscriptions tak some time!
> > Anyone with the same experience ?
> >
> > Further info:
> > There are two devlopers developing in the same .NET 2003 report project,
> > and
> > deploing to the same reporting services server. A C# application is
> > developed
> > to add/delete subscriptions, but the deleted once is not reachable from
> > the
> > application.
> >
> > Greatful for any reply on this !
> >
> >
> >
> >
>
>