Synchronization error
in [Replication]
|
From: CrudeOil on 26 May 2006 18:18 Hi, I've added a couple new fields to a table. There are 10 subscriptions on this publication. Only 1 has problems synchronizing since. First error is: The merge process could not clean up the subscription to 'SERVER':'SERVER:'PUB'. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200965) Get help: http://help/MSSQL_REPL-2147200965 New request is not allowed to start because it should come with valid transaction descriptor. (Source: MSSQLServer, Error number: 3989) Get help: http://help/3989 If I reinitialize AND check to upload changes before reinitialize then I get The schema script ' if not exists (select * from syscolumns where name = N'NewCol1' and id = object_id(N'[dbo].[Table1]')) if not exists (select * from syscolumns where name = N'NewCol2' and id = object_id(N'[dbo].[Table1]')) if object_id(N'[dbo].[Table1]') is not null exec('ALTER TABLE [dbo].[Table1] add Col1 varchar(20), Col2 datetime ')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001) Get help: http://help/MSSQL_REPL-2147201001 I've spent quite a bit of time searching for all those errors, codes, etc.. nothing helped Any suggestions would be appreciated
From: Hilary Cotter on 28 May 2006 07:40 This almost looks like a security problem. It looks like you are running the web sync. Is there anything different about the security for this subscriber as opposed to the other ones? -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 "CrudeOil" <bcomeau(a)canada.com> wrote in message news:1148681905.836536.170340(a)i40g2000cwc.googlegroups.com... > Hi, > > I've added a couple new fields to a table. There are 10 subscriptions > on this publication. Only 1 has problems synchronizing since. First > error is: > > The merge process could not clean up the subscription to > 'SERVER':'SERVER:'PUB'. (Source: MSSQL_REPL, Error number: > MSSQL_REPL-2147200965) > Get help: http://help/MSSQL_REPL-2147200965 > New request is not allowed to start because it should come with valid > transaction descriptor. (Source: MSSQLServer, Error number: 3989) > Get help: http://help/3989 > > If I reinitialize AND check to upload changes before reinitialize then > I get > > The schema script ' if not exists (select * from syscolumns where name > = N'NewCol1' and id = object_id(N'[dbo].[Table1]')) if not exists > (select * from syscolumns where name = N'NewCol2' and id = > object_id(N'[dbo].[Table1]')) if object_id(N'[dbo].[Table1]') is not > null exec('ALTER TABLE [dbo].[Table1] add > Col1 varchar(20), > Col2 datetime > ')' could not be propagated to the subscriber. (Source: MSSQL_REPL, > Error number: MSSQL_REPL-2147201001) > Get help: http://help/MSSQL_REPL-2147201001 > > I've spent quite a bit of time searching for all those errors, codes, > etc.. nothing helped > Any suggestions would be appreciated >
From: Mahesh [MSFT] on 23 Jun 2006 17:16 Do you have a lot of data that needs to be propagated? Upload or download? Do not do the reinit with upload. Also try reducing the number of genreations for upload/download by either using the command line parameters -UploadGenerationsPerBatch 10 -DownloadGenerationsPerBatch 10 (10 is an example here) You can also use the Merge agent profiles to do the same thing. Hope that helps --Mahesh [ This posting is provided "as is" with no warranties and confers no rights. ] "CrudeOil" <bcomeau(a)canada.com> wrote in message news:1148681905.836536.170340(a)i40g2000cwc.googlegroups.com... > Hi, > > I've added a couple new fields to a table. There are 10 subscriptions > on this publication. Only 1 has problems synchronizing since. First > error is: > > The merge process could not clean up the subscription to > 'SERVER':'SERVER:'PUB'. (Source: MSSQL_REPL, Error number: > MSSQL_REPL-2147200965) > Get help: http://help/MSSQL_REPL-2147200965 > New request is not allowed to start because it should come with valid > transaction descriptor. (Source: MSSQLServer, Error number: 3989) > Get help: http://help/3989 > > If I reinitialize AND check to upload changes before reinitialize then > I get > > The schema script ' if not exists (select * from syscolumns where name > = N'NewCol1' and id = object_id(N'[dbo].[Table1]')) if not exists > (select * from syscolumns where name = N'NewCol2' and id = > object_id(N'[dbo].[Table1]')) if object_id(N'[dbo].[Table1]') is not > null exec('ALTER TABLE [dbo].[Table1] add > Col1 varchar(20), > Col2 datetime > ')' could not be propagated to the subscriber. (Source: MSSQL_REPL, > Error number: MSSQL_REPL-2147201001) > Get help: http://help/MSSQL_REPL-2147201001 > > I've spent quite a bit of time searching for all those errors, codes, > etc.. nothing helped > Any suggestions would be appreciated >
|
Pages: 1 Prev: Replication/Subscription error Next: Transactional replication synch error |