Re: cannot deliver sp_repldropcolum schema change

Hello Paul

Thanks for the Link, which was very useful. I didn't realise, I could enable
such a logging (though I've already read about it before)

So here's the statement:
exec sp_repldropcolumn @source_object = 'c_controldef', @column = 'mandid',
@force_invalidate_snapshot = 1, @force_reinit_subscription = 1
---

and here's the log (in German, sorry):
Microsoft SQL Server-Merge-Agent 8.00.760
Copyright (c) 2000 Microsoft Corporation

Percent Complete: 0
Verbindung mit Abonnent 'winxpsp2\syseca'
Connecting to Abonnent 'winxpsp2\syseca.challenge'

Server: winxpsp2\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288

[16.11.2006 13:55:53]winxpsp2\syseca.challenge: {call sp_MSgetversion }
[16.11.2006 13:55:53]winxpsp2\syseca.challenge: {?=call
sp_helpsubscription_properties (N'vistatestpc\syseca', N'challenge',
N'challenge')}
Distributor security mode: 0, login name: rai_application, password: ********.
Percent Complete: 0
Verbindung mit Verteiler 'vistatestpc\syseca'
Connecting to Verteiler 'vistatestpc\syseca.'

Server: vistatestpc\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: guest
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288

[16.11.2006 13:55:53]vistatestpc\syseca.: {call sp_MSgetversion }
[16.11.2006 13:55:53]vistatestpc\syseca.: {call sp_helpdistpublisher
(N'vistatestpc\syseca') }
[16.11.2006 13:55:53]vistatestpc\syseca.distribution: select datasource,
srvid from master..sysservers where upper(srvname) =
upper(N'vistatestpc\syseca')
[16.11.2006 13:55:53]vistatestpc\syseca.distribution: {call
sp_MSadd_merge_anonymous_agent(N'0', N'challenge', N'challenge',
N'challenge', N'winxpsp2\syseca',?, 667)}
[16.11.2006 13:55:53]vistatestpc\syseca.distribution: {call
sp_MShelp_profile (2, 4, N'')}
Percent Complete: 0
Connecting to Verleger 'vistatestpc\syseca.challenge'
Initialisiert
Percent Complete: 1
Verbindung mit Verleger 'vistatestpc\syseca'

Server: vistatestpc\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288

[16.11.2006 13:55:53]vistatestpc\syseca.challenge: set nocount on declare
@dbname sysname select @dbname = db_name() declare @collation nvarchar(255)
select @collation = convert(nvarchar(255), databasepropertyex(@dbname,
N'COLLATION')) select collationproperty(@collation, N'CODEPAGE') as
'CodePage', collationproperty(@collation, N'LCID') as 'LCID',
collationproperty(@collation, N'COMPARISONSTYLE') as 'ComparisonStyle'
Connecting to Verleger 'vistatestpc\syseca.challenge'

Server: vistatestpc\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288

[16.11.2006 13:55:54]vistatestpc\syseca.challenge: {call sp_MSgetversion }
Percent Complete: 3
Ruft Publikationsinformationen ab
Percent Complete: 4
Ruft Abonnementinformationen ab
Connecting to Abonnent 'winxpsp2\syseca.challenge'

Server: winxpsp2\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288


Server: winxpsp2\syseca
DBMS: Microsoft SQL Server
Version: 08.00.0760
user name: rai_application
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288

[16.11.2006 13:55:54]vistatestpc\syseca.challenge: exec sp_datatype_info 0, 3
Percent Complete: 4
[16.11.2006 13:55:54]winxpsp2\syseca.challenge: exec sp_repldropcolumn
'[dbo].[c_controldef]', 'mandid', 1
Eine Spalte wurde zur replizierten Tabelle hinzugefügt oder aus dieser
gelöscht.
Das Schemaskript 'exec sp_repldropcolumn '[dbo].[c_controldef]', 'mandid',
1' konnte nicht an den Abonnenten weitergegeben werden.
Percent Complete: 0
Das Schemaskript 'exec sp_repldropcolumn '[dbo].[c_controldef]', 'mandid',
1' konnte nicht an den Abonnenten weitergegeben werden.
Percent Complete: 0
Category:NULL
Source: Mergereplikationsprovider
Number: -2147201001
Message: Das Schemaskript 'exec sp_repldropcolumn '[dbo].[c_controldef]',
'mandid', 1' konnte nicht an den Abonnenten weitergegeben werden.
---

at the end it says: The schemascript sp_repldropcolumn
'[dbo].[c_controldef]', 'mandid', 1' couldn't be delivered to the subscriber
Unfortunately it doesn't tell my why.

There are a lot of different changes before which work fine. And afterwards
are also 46 sp_repldropcolumn.
Strangely, if I comment out these 47 sp_repldropcolumn's, update the
publisher, synchronize the subscriber, and then update the publisher with
these 47 47 sp_repldropcolumn's and synch the subscriber, it works...

As the product is install at more than 100 customers, I need something
automatic.

Any further help?

Thanks
Aline

.

Relevant Pages
Loading