AUTO DROP OF SUBSCRIPTION

Hi,
I have merge replicated, remote server & local server.
The database has only one table. It was working fine.
More than 15 days, it was isolated without any transaction.
After some days (around 15 days) I found that the subscription is dropped.
What is the reason for this?
Is there any way to avoid this?
Thanks,
Soura.
Soura,
the Expired Subscription Cleanup agent has deleted the subscription.
Disabling this agent won't help, because you need to forcably prevent the
subscription from expiring. If it is transactional, make sure that the
subscription expiration period is sufficiently long eg 3 weeks, and history
retention period also the same length of time. If it was transactional, the
same would apply to the transaction retention period.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I was under the impression that transactional replication needs to be
re-established after 72 hours and that this is the limit as it can not be
changed past this value. Are you primarily discussing the removal of the
subscription or the expiration of the subscription ?
It has been a long held understanding with the DBA's at my organisation that
72 Hours was the maximum time before expiration of a subscription to
transactional replication required a rebuild of the subscritpion .
"Paul Ibison" wrote:

> Soura,
> the Expired Subscription Cleanup agent has deleted the subscription.
> Disabling this agent won't help, because you need to forcably prevent the
> subscription from expiring. If it is transactional, make sure that the
> subscription expiration period is sufficiently long eg 3 weeks, and history
> retention period also the same length of time. If it was transactional, the
> same would apply to the transaction retention period.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Perhaps the quantity of information in your company makes this a practivcal
limit for the size of the distribution database, but there is no such
hardcoded limit in SQL Server - it is entirely configurable.
Rgds,
Paul Ibison

Attempted to read or write protected memory

I'm running in to a confusing issue with one of my reports in Reporting
Services. The problem is that I have a subscription tied to a report that
emails it around to users and I'm sporadically getting this message:
"Failure sending mail: Attempted to read or write protected memory. This is
often an indication that other memory is corrupt."
(Full error from logs: Error sending email. System.AccessViolationException:
Attempted to read or write protected memory. This is often an indication that
other memory is corrupt.)
I'm not particularly sure why this report is a problem (or if it is) as it's
not all that complicated. The report itself runs fine and never throws the
error, but for some reason it's unable to send email occasionally. If I
reschedule the subscription, it will usually email it out. But it's not
reliable at all.
Reporting Services is running a web cluster here, we also have a SQL Server
2005 database cluster running the underlying metadata repository, the reports
are sent via the SMTP configuration via the RS config files. Everything else
seems to be working hunky dory except for this issue.
Googling hasn't been much help ... I did look in to a few issues which
pointed to images (which I have in the header of the report) not being the
right MIME type, but mine seem to be okay. I have a couple of .NET assemblies
embedded in the report, but I'm just not real sure where to track down the
problem on this issue.
Any ideas on what I can do to track down the failure?
Here's the error from the log files. You can also see in the logs that other
emails are going out okay.
============= LOG INFORMATION BELOW ============= ReportingServicesService!library!c!10/31/2007-05:53:07:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!b!10/31/2007-05:58:07:: EventPolling
processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!4!10/31/2007-05:58:07:: EventPolling
processing item 29cd0331-4666-422c-80ea-f816472daaf0
ReportingServicesService!dbpolling!c!10/31/2007-05:58:07:: EventPolling
processing item 5ce520dd-ae10-4e6f-b8bd-32070237a266
ReportingServicesService!library!4!10/31/2007-05:58:07:: Schedule
4f87d0bc-1f33-475b-96a6-eafab3c721b6 executed at 10/31/2007 5:58:07 AM.
ReportingServicesService!schedule!4!10/31/2007-05:58:07:: Creating Time
based subscription notification for subscription:
b51d5c44-4e93-4b65-8357-5d7de75cf8f8
ReportingServicesService!library!c!10/31/2007-05:58:07:: Schedule
c28239dc-df46-406c-a1f6-a8e4a22a0a98 executed at 10/31/2007 5:58:07 AM.
ReportingServicesService!schedule!c!10/31/2007-05:58:07:: Creating Time
based subscription notification for subscription:
2aa119ba-312c-49b6-9676-43be2eb0dcef
ReportingServicesService!library!c!10/31/2007-05:58:07:: Schedule
c28239dc-df46-406c-a1f6-a8e4a22a0a98 execution completed at 10/31/2007
5:58:07 AM.
ReportingServicesService!library!4!10/31/2007-05:58:07:: Schedule
4f87d0bc-1f33-475b-96a6-eafab3c721b6 execution completed at 10/31/2007
5:58:07 AM.
ReportingServicesService!dbpolling!c!10/31/2007-05:58:07:: EventPolling
finished processing item 5ce520dd-ae10-4e6f-b8bd-32070237a266
ReportingServicesService!dbpolling!c!10/31/2007-05:58:07::
NotificationPolling processing item 8a39847b-b85e-4594-8e4c-4bae0e83945b
ReportingServicesService!dbpolling!b!10/31/2007-05:58:07::
NotificationPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!a!10/31/2007-05:58:07::
NotificationPolling processing item e03f07d1-eb70-499a-b4bd-774d62f76bcb
ReportingServicesService!dbpolling!4!10/31/2007-05:58:07:: EventPolling
finished processing item 29cd0331-4666-422c-80ea-f816472daaf0
ReportingServicesService!library!c!10/31/2007-05:58:08:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!a!10/31/2007-05:58:08:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!emailextension!a!10/31/2007-05:58:10:: Error
sending email. System.AccessViolationException: Attempted to read or write
protected memory. This is often an indication that other memory is corrupt.
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!a!10/31/2007-05:58:10:: Notification
e03f07d1-eb70-499a-b4bd-774d62f76bcb completed. Success: False, Status:
Failure sending mail: Attempted to read or write protected memory. This is
often an indication that other memory is corrupt., DeliveryExtension: Report
Server Email, Report: DailyCustomerOrders, Attempt 0
ReportingServicesService!dbpolling!a!10/31/2007-05:58:10::
NotificationPolling finished processing item
e03f07d1-eb70-499a-b4bd-774d62f76bcb
ReportingServicesService!library!c!10/31/2007-05:58:11:: i INFO: Call to
RenderFirst( '/Paramount/CustomerShipments' )
ReportingServicesService!library!c!10/31/2007-05:58:13:: i INFO:
Initializing SqlStreamingBufferSize to default value of '64640' Bytes because
it was not specified in Server system properties.
ReportingServicesService!library!c!10/31/2007-05:58:13:: i INFO:
Initializing SnapshotCompression to 'SQL' as specified in Server system
properties.
ReportingServicesService!library!c!10/31/2007-05:58:16:: i INFO:
Initializing ResponseBufferSizeKb to default value of '64' KB because it was
not specified in Server system properties.
ReportingServicesService!library!c!10/31/2007-05:58:17:: i INFO:
Initializing SessionTimeout to '600' second(s) as specified in Server system
properties.
ReportingServicesService!library!c!10/31/2007-05:58:17:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!c!10/31/2007-05:58:17:: Email
successfully sent to "removed" <removed>
ReportingServicesService!notification!c!10/31/2007-05:58:17:: Notification
8a39847b-b85e-4594-8e4c-4bae0e83945b completed. Success: True, Status: Mail
sent to removed, DeliveryExtension: Report Server Email, Report:
CustomerShipments, Attempt 0
ReportingServicesService!dbpolling!c!10/31/2007-05:58:17::
NotificationPolling finished processing item
8a39847b-b85e-4594-8e4c-4bae0e83945b
ReportingServicesService!dbpolling!4!10/31/2007-05:59:07:: EventPolling
processing item fd139fe4-9412-4e96-96ce-3f0aed787b9d
ReportingServicesService!dbpolling!b!10/31/2007-05:59:07:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!4!10/31/2007-05:59:07:: Schedule
29c40f83-6f27-4302-b739-84cea5b1429d executed at 10/31/2007 5:59:07 AM.
ReportingServicesService!schedule!4!10/31/2007-05:59:07:: Creating Time
based subscription notification for subscription:
2cb9b939-535b-46fb-8ff8-11aa2c5c56b7
ReportingServicesService!library!4!10/31/2007-05:59:07:: Schedule
29c40f83-6f27-4302-b739-84cea5b1429d execution completed at 10/31/2007
5:59:07 AM.
ReportingServicesService!dbpolling!4!10/31/2007-05:59:07:: EventPolling
finished processing item fd139fe4-9412-4e96-96ce-3f0aed787b9d
ReportingServicesService!dbpolling!b!10/31/2007-05:59:07::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!4!10/31/2007-05:59:07::
NotificationPolling processing item 7db9f680-501f-4623-988c-efeab0d1dbca
ReportingServicesService!emailextension!4!10/31/2007-05:59:07:: Error
sending email. System.AccessViolationException: Attempted to read or write
protected memory. This is often an indication that other memory is corrupt.
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!4!10/31/2007-05:59:07:: Notification
7db9f680-501f-4623-988c-efeab0d1dbca completed. Success: False, Status:
Failure sending mail: Attempted to read or write protected memory. This is
often an indication that other memory is corrupt., DeliveryExtension: Report
Server Email, Report: WarehouseExceptions, Attempt 0
ReportingServicesService!dbpolling!4!10/31/2007-05:59:07::
NotificationPolling finished processing item
7db9f680-501f-4623-988c-efeab0d1dbca
ReportingServicesService!library!4!10/31/2007-06:03:06:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!c!10/31/2007-06:13:07:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!c!10/31/2007-06:23:07:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!10/31/2007-06:33:07:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!9!10/31/2007-06:33:07:: EventPolling
polling service stopped
ReportingServicesService!dbpolling!e!10/31/2007-06:33:07:: EventPolling
heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!9!10/31/2007-06:33:07::
NotificationPolling polling service stopped
ReportingServicesService!dbpolling!10!10/31/2007-06:33:07::
NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!9!10/31/2007-06:33:07:: SchedulePolling
polling service stopped
ReportingServicesService!dbpolling!9!10/31/2007-06:33:07:: UpgradePolling
polling service stopped
ReportingServicesService!servicecontroller!9!10/31/2007-06:33:11:: Service
controller exiting.Did you find an answer to this?

attaching subscription database woes

I'm trying to get to a point where I can implement structural changes to a
merge replication system. My plan is to ship copies of a subscription
database to enduser outside the corp firewall and write some code to load
the new subscription database. I've done the following:
1. create a subscription db on the same server as the publisher
2. use the 'copy a subscription database' menu choice to create a copy of
it.
3. move the copy to target server.
4. in the replication folder on the target server select: 'attach
subscription database', select the msf file, specify a name for the db.
5. run sp_addMergeSubscription on the publication server as follows:
exec sp_addmergesubscription
@.publication = 'rep_test_hub',
@.subscriber = 'k-server',
@.subscriber_db = 'rep_test_sub2',
@.subscription_type = 'pull',
@.sync_type = 'none'
6. on the publisher - drill down to the publisher list, refresh it and note
the addition of 'rep_test_sub2'. At this point the status is 'deactivated'
7. synch with the publisher on subscriber
The above works fine when both pub and sub are on the same box. When I try
this on another pc in a peer-peer network I get the following error:
Event Type: Information
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 203
Date: 1/20/2006
Time: 1:20:32 PM
User: N/A
Computer: k-HOME
Description:
SubSystem Message - Job
'K-SERVER-rep_test_hub-rep_test_hub-K-HOME-rep_test_sub6- 0'
(0x826C45BA92AD5F4E9B37842A22DB6F0B), step 1 - The process could not connect
to Distributor 'K-SERVER'. Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.
Why is the synch attempt using an 'anonymous logon'?
I've checked my SQL-Agent properties and it is setup for 'SQL-Server
Authentication' in the connection tab on both systems. Both server have
identical 'sa' passwords. The startup account is 'system account' on the
sub PC and a domain admin account on the hub PC. The sub PC is not part of
the domain.
Any suggestions?
Thanks.
Run SQL Server agent under a local admin account on the subscriber.
Hilary Cotter
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
"astro" <astro@.bcmn.com> wrote in message
news:U2bAf.38900$7S.35782@.tornado.rdc-kc.rr.com...
> I'm trying to get to a point where I can implement structural changes to a
> merge replication system. My plan is to ship copies of a subscription
> database to enduser outside the corp firewall and write some code to load
> the new subscription database. I've done the following:
> 1. create a subscription db on the same server as the publisher
> 2. use the 'copy a subscription database' menu choice to create a copy of
> it.
> 3. move the copy to target server.
> 4. in the replication folder on the target server select: 'attach
> subscription database', select the msf file, specify a name for the db.
> 5. run sp_addMergeSubscription on the publication server as follows:
> exec sp_addmergesubscription
> @.publication = 'rep_test_hub',
> @.subscriber = 'k-server',
> @.subscriber_db = 'rep_test_sub2',
> @.subscription_type = 'pull',
> @.sync_type = 'none'
> 6. on the publisher - drill down to the publisher list, refresh it and
> note the addition of 'rep_test_sub2'. At this point the status is
> 'deactivated'
> 7. synch with the publisher on subscriber
> The above works fine when both pub and sub are on the same box. When I
> try this on another pc in a peer-peer network I get the following error:
> Event Type: Information
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 203
> Date: 1/20/2006
> Time: 1:20:32 PM
> User: N/A
> Computer: k-HOME
> Description:
> SubSystem Message - Job
> 'K-SERVER-rep_test_hub-rep_test_hub-K-HOME-rep_test_sub6- 0'
> (0x826C45BA92AD5F4E9B37842A22DB6F0B), step 1 - The process could not
> connect to Distributor 'K-SERVER'. Login failed for user 'NT
> AUTHORITY\ANONYMOUS LOGON'.
> Why is the synch attempt using an 'anonymous logon'?
> I've checked my SQL-Agent properties and it is setup for 'SQL-Server
> Authentication' in the connection tab on both systems. Both server have
> identical 'sa' passwords. The startup account is 'system account' on the
> sub PC and a domain admin account on the hub PC. The sub PC is not part
> of the domain.
>
> Any suggestions?
> Thanks.
>
>

attaching a link to an email subscription

Our report manager and reports are accessed over a secure conection but the link uses http:// by default. where can i change that to https://?

You can change default report serwer url address in configuration files of your report server (rsreportserver.config or something like that)

Attach subscription MDF

Hi,
Our subscriber crashed and they had a quite a bit of work captured after the
last synch up to the publisher. We salvaged the MDF and LDF.
I have tried attaching this subscriber to a new machine which worked fine,
now I want to synch that data with publisher. Is this possible? I cant
seem to get this to work.
Any ideas?
Thanks in advance
Warren Patterson.
it should work. As long as the agents are in place you should be able to
start them up again. I'd take a backup before you do anything however.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Warren Patterson" <des@.newsgroups.nospam> wrote in message
news:e9jzmMJ9EHA.3756@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Our subscriber crashed and they had a quite a bit of work captured after
the
> last synch up to the publisher. We salvaged the MDF and LDF.
> I have tried attaching this subscriber to a new machine which worked fine,
> now I want to synch that data with publisher. Is this possible? I cant
> seem to get this to work.
> Any ideas?
> Thanks in advance
> Warren Patterson.
>
>
|||Thanks Hilary.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uFh%23UUL9EHA.2452@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> it should work. As long as the agents are in place you should be able to
> start them up again. I'd take a backup before you do anything however.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Warren Patterson" <des@.newsgroups.nospam> wrote in message
> news:e9jzmMJ9EHA.3756@.TK2MSFTNGP14.phx.gbl...
> the
fine,
>