Tuesday, March 20, 2012

problems with merge replicaton.

Hi, I have installed sql server 2000 sp 3 on a publisher/distributor. I
have about 6 merge replication configured whith pull subscription. Four
of them are ok but one give me this error.
The process could not deliver the snapshot to the Subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
---
The process could not bulk copy into table
'"dbo"."sysmergesubsetfilters"'.
(Source: SCENALMSQL (Agent); Error number: 20037)
---
Unable to open BCP host data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: 0)
---
and the other one give me this error:
You must rerun snapshot because current snapshot files are obsolete.
(Source: Merge Replication Provider (Agent); Error number: -2147201021)
Both are configured on the same subscriptor.
I guess that could be the versions of sql server, i execute the select
@.@.version sentence on both servers and this are the results:
publisher/distributor: Microsoft SQL Server 2000 - 8.00.760
Subscriptor. Microsoft SQL Server 2000 - 8.00.818
However, I have configured the same scenario of replication in servers
whith the same configuration.
How could i resolve this problem?
thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
For the 1st error, you may be running into the issue described in KB
article: FIX: Compressed Snapshot CAB Does Not Contain All Necessary Files
- ID: 318075 (available at http://support.microsoft.com)
For the second (snapshot obsolete message) this means we are trying to
apply a snapshot whose files are obsolete (older than the retention
period), you need to rerun the snapshot agent to create up to date snapshot
files.
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

No comments:

Post a Comment