Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merge Replication fails

Status
Not open for further replies.
Di0genes

Di0genes

IS-IT--Management
Nov 28, 2002
23
DE
Hello,

I replicate per merge replication a database on 2 MS-SQL Server 2000. Without changing anything on both servers the replication fails since 2 days. The error message is:

Error:
Der Prozess konnte das Vorhandensein der Generierung auf 'Subscriber' nicht überprüfen.
Translation: The process could not check the presence of the generation on 'subscriber'

Error details:
Der Prozess konnte das Vorhandensein der Generierung auf 'Subscriber' nicht überprüfen.
(Quelle: Mergereplikationsprovider (Agent); Fehlernummer: -2147201003)

I can fully administrate the subscriber per enterprice manager an access the databases per query analyzer. Only the replication fails. I dont have any idea what the problem is.

Regards
Di0gens

PS:

Maybe this part of the logfile can help to find the reason:

[22.11.05 08:34:51]KAUFPL_SQL.Expansion_Polen: {call sp_MSgetlastsentrecgens (?)}
[22.11.05 08:34:51]RAID_MASTER.EXPANSION: {call sp_MSgetlastsentrecgens (?)}
[22.11.05 08:34:51]KAUFPL_SQL.Expansion_Polen: {call sp_MSgetmakegenerationapplock(?)}
Percent Complete: 4
Uploadet Datenänderungen zum Verleger
Repl Agent Status: 3
[22.11.05 08:34:51]KAUFPL_SQL.Expansion_Polen: {call sp_MSmakegeneration (?)}
[22.11.05 08:34:51]KAUFPL_SQL.Expansion_Polen: {call sp_MSreleasemakegenerationapplock}
[22.11.05 08:34:52]KAUFPL_SQL.Expansion_Polen: {call sp_MSenumgenerations (2554903, ?, 1) }
[22.11.05 08:34:52]RAID_MASTER.EXPANSION: {call sp_MScheckexistsgeneration (?, ?) }
[22.11.05 08:34:52]RAID_MASTER.EXPANSION:
[22.11.05 08:34:52]KAUFPL_SQL.Expansion_Polen: {call sp_MSsetlastsentgen (?, ?, ?)}
[22.11.05 08:34:52]RAID_MASTER.EXPANSION: {call sp_MSsetlastrecgen (?, ?, ?)}
[22.11.05 08:34:52]RAID_MASTER.EXPANSION: {call sp_MSgetmakegenerationapplock(?)}
Percent Complete: 4
[22.11.05 08:34:52]RAID_MASTER.EXPANSION: {call sp_MSmakegeneration (?)}
Es mussten keine Daten zusammengeführt werden.
Repl Agent Status: 3
Percent Complete: 4
Downloadet Datenänderungen zum Abonnenten
Repl Agent Status: 3
[22.11.05 08:34:53]RAID_MASTER.EXPANSION: {call sp_MSreleasemakegenerationapplock}
[22.11.05 08:34:53]RAID_MASTER.EXPANSION: {call sp_MSenumgenerations (41543, ?, 1) }
[22.11.05 08:34:53]KAUFPL_SQL.Expansion_Polen: {call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneration (?, ?) }{call sp_MScheckexistsgeneratiDer Prozess konnte das Vorhandensein der Generierung auf 'Subscriber' nicht überprüfen.
Percent Complete: 0
Der Prozess konnte das Vorhandensein der Generierung auf 'Subscriber' nicht überprüfen.
Repl Agent Status: 5
Percent Complete: 0
Category:NULL
Source: Mergereplikationsprovider
Number: -2147201003
Message: Der Prozess konnte das Vorhandensein der Generierung auf 'Subscriber' nicht überprüfen.
Repl Agent Status: 3
 
Status
Not open for further replies.

Similar threads

carolx
  • Locked
  • Question
SQLEXEC statement fails 1
Replies
4
Views
133
Olaf Doschke
Olaf Doschke
Herdrich
  • Locked
  • Question
SQL Query Merge Records 1
Replies
2
Views
118
Herdrich
Herdrich
craigward
  • Locked
  • Question
SQL Merge Into Help 1
Replies
2
Views
111
craigward
craigward
peac3
  • Locked
  • Question
Merge two historical tables, please help...
Replies
4
Views
104
fredericofonseca
fredericofonseca
peac3
  • Locked
  • Question
Merge records to get sequence in TIME with condition, Please help...
Replies
2
Views
91
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top