Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 subscription has expired.

Author  Topic 

leeravi
Starting Member

1 Post

Posted - 2008-12-22 : 17:08:32
My replication is configured as one publication (SQL Server 2005) with nearly 165 sql server compact edition subscribers on it. Most of them are working fine with out any problem. On some of the devices, I have been getting the following error message during synchronization.

Error messages:
The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011)
Get help: http://help/MSSQL_REPL-2147201011
The subscription could not be found. (Source: MSSQLServer, Error number: 20021)
Get help: http://help/20021
The subscription has expired. Mark the subscription for reinitialization and restart the Merge Agent to reinitialize the subscription. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200980)
Get help: http://help/MSSQL_REPL-2147200980

I was not sure why the subscriptions are deleting / expiring. Any thoughts on this is highly appreciated?

thanks
ravi.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-22 : 19:39:37
http://msdn.microsoft.com/en-us/library/ms151778.aspx
Go to Top of Page
   

- Advertisement -