replication problem

[xiao]

I have spent two days trying to figure out how to fix this replication problem, following are steps to recreate the error:

1)create a table T1 with columns: a, b, c, d, e
2)publish it with default settings (no filter...)
3)replicate table T1 to table T1_rep
3.1) take snap shot
3.2) let it replicates to table T1_rep
4)check table T1_rep, it should have all five columns and data
---
5)stop replication, drop all subscribers in that publication
6)drop table T1 from publicaion
7)drop column b, and column d from table T1
8)put it back in publicaiton
9)replicate it to table T1_rep
10)check table T1_rep, it now has column a and c ONLY! Missing column e !
11)insert a row into table T1, replication agent will give you an error, saying parameters not match with column number. because there are three
columns in table T1, and only two columns in table T1_rep.

does anyone know how to fix this problem other than recreating the whole table? Thanks a million!

xiao

[xiao]

I forgot to mention, I am runing SQL 7.0 with sp2.


------------
xiao at 3/13/01 2:18:09 PM

I have spent two days trying to figure out how to fix this replication problem, following are steps to recreate the error:

1)create a table T1 with columns: a, b, c, d, e
2)publish it with default settings (no filter...)
3)replicate table T1 to table T1_rep
3.1) take snap shot
3.2) let it replicates to table T1_rep
4)check table T1_rep, it should have all five columns and data
---
5)stop replication, drop all subscribers in that publication
6)drop table T1 from publicaion
7)drop column b, and column d from table T1
8)put it back in publicaiton
9)replicate it to table T1_rep
10)check table T1_rep, it now has column a and c ONLY! Missing column e !
11)insert a row into table T1, replication agent will give you an error, saying parameters not match with column number. because there are three
columns in table T1, and only two columns in table T1_rep.

does anyone know how to fix this problem other than recreating the whole table? Thanks a million!

xiao

[rajesh]

R U doing Snapshot after step 8 ? if not then this is the reason
Rajesh


------------
xiao at 3/13/01 2:18:09 PM

I have spent two days trying to figure out how to fix this replication problem, following are steps to recreate the error:

1)create a table T1 with columns: a, b, c, d, e
2)publish it with default settings (no filter...)
3)replicate table T1 to table T1_rep
3.1) take snap shot
3.2) let it replicates to table T1_rep
4)check table T1_rep, it should have all five columns and data
---
5)stop replication, drop all subscribers in that publication
6)drop table T1 from publicaion
7)drop column b, and column d from table T1
8)put it back in publicaiton
9)replicate it to table T1_rep
10)check table T1_rep, it now has column a and c ONLY! Missing column e !
11)insert a row into table T1, replication agent will give you an error, saying parameters not match with column number. because there are three
columns in table T1, and only two columns in table T1_rep.

does anyone know how to fix this problem other than recreating the whole table? Thanks a million!

xiao

[xiaod]

yeah, I take snapshot after step 8, that's why
table T1_rep got trimed to 2 columns.
there are three columns in table T1: a, c, e
after i take the snapshot and apply to table T1_rep,
T1_rep only has TWO columns: a, c (missing e).....


------------
rajesh at 3/13/01 3:38:29 PM

R U doing Snapshot after step 8 ? if not then this is the reason
Rajesh


------------
xiao at 3/13/01 2:18:09 PM

I have spent two days trying to figure out how to fix this replication problem, following are steps to recreate the error:

1)create a table T1 with columns: a, b, c, d, e
2)publish it with default settings (no filter...)
3)replicate table T1 to table T1_rep
3.1) take snap shot
3.2) let it replicates to table T1_rep
4)check table T1_rep, it should have all five columns and data
---
5)stop replication, drop all subscribers in that publication
6)drop table T1 from publicaion
7)drop column b, and column d from table T1
8)put it back in publicaiton
9)replicate it to table T1_rep
10)check table T1_rep, it now has column a and c ONLY! Missing column e !
11)insert a row into table T1, replication agent will give you an error, saying parameters not match with column number. because there are three
columns in table T1, and only two columns in table T1_rep.

does anyone know how to fix this problem other than recreating the whole table? Thanks a million!

xiao