| Author |
Lost of table in meger replication
|
|
| Maverick06 2006-11-24, 7:13 pm |
| I have set up a two level merge replication with a publisher and a
subscriber and had modified the structure of a table in the publisher
with sp_repladdcolumn. During the day all was fine I continuously
tested it by adding more columns, droping columns and testing the
replication itself with data entry all was fine, but when I got back
the next morning my test table and all other table I presume had lost
its data and structure. The conflict table for the corresponding test
table had kept it's structure but no data were present since no
conflict had occured. This is a recuring problem that some colleagues
had.
Does anyone have any idea what might cause this problem and why it
happenned.
Thanx
| |
| Paul Ibison 2006-11-24, 7:13 pm |
| Just to get some more info: when you refer to the test table is this on the
subscriber only or on the publisher and subscriber? Were any errors
registered? Is it the case that there are some remaining changes that
haven't been applied to the subscriber? In that case has the merge agent
been run?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
| |
| Maverick06 2006-11-24, 7:13 pm |
| Paul
It is both at the publisher and subscriber. There were errors and the
merge agent had been drop, I don't believe there was any pending
changes.... the merge agent has failed with an error that I can't
recall I know it is very vague....
Thanks
| |
| Maverick06 2006-11-24, 7:13 pm |
|
Paul
I also have an other problem..
Hi I am creating a three level merge replication. I mean I have a main
publisher with its distributor, a subscriber/publisher and also with
it's own distributor and lastly a subscriber.
I start by creating the relation between subscriber/Publisher and the
subscriber and than i move up to the main Publisher and
Subscriber\Publisher
relation. After this second merge I get the
following errors and the articles in my Subscriber\Publisher
are
lost...
The merge process could not retrieve article information for
publication 'I-Test-Publisher'.
(Source: Merge Replication Provider (Agent); Error number: -2147201017)
---------------------------------------------------------------------------=
=AD------------------------------------
Cannot insert the value NULL into column 'tablename', table
'@tmp_table'; column does not allow nulls. INSERT fails.
(Source: DEVSERVER3\MSDE (Data source); Error number: 515)
---------------------------------------------------------------------------=
=AD------------------------------------
Failed to allocate new identity range.
(Source: DEVSERVER3\MSDE (Data source); Error number: 21197)
---------------------------------------------------------------------------=
=AD------------------------------------
| |
| Paul Ibison 2006-11-27, 7:17 pm |
| OK - you are using merge republishing. I'd like to know exactly how did you
set it up.
Please take a look at this guide and check that you've followed this
methodology, or can you explain where you've deviated.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
| |
| Maverick06 2006-11-27, 7:17 pm |
|
Paul Ibison wrote:
> OK - you are using merge republishing. I'd like to know exactly how did you
> set it up.
> Please take a look at this guide and check that you've followed this
> methodology, or can you explain where you've deviated.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
I have have fix the second question the three level publication but I
still haven't figured what went wrong with the other replication I have
hit a block wall. I have recreated the replication in the same manner I
have the previous time and all is well it hasn't occured again.....
Which I find fairly odd and I am preoccupied that this will occur at
the client's sites...
|
|
|
|