The process could not bulk copy into table "dbo"."MSmerge_contents". Field size too large.
- From: JDS <admin@xxxxxxxxxxxxxx>
- Date: Tue, 18 Dec 2007 12:09:39 -0800 (PST)
I am getting the following error when trying a merge replication:
The process could not bulk copy into table "dbo"."MSmerge_contents".
Field size too large.
I assume that the "field size too large" is significant but I do not
know what it is referring to and it seems completely out of my
control.
All the snapshot files download fine, it applies the .sch and .cft
files, bulk copies data into the main database tables and then says
that "the merge process was unable to deliver the snapshot to the
subscriber" and follows on with the error message above.
Some details:
publisher/distributor: SQL Server 2005 (workgroup edition)
subscriber: SQL Server 2005 Express
merge replication with web synchronisation
parameterised row filters used with (potentially) overlapping
partitions
The whole thing was working fine but I have been working on producing
a deployment package so I detached the database on the subscriber and
used the mdf file as the basis for the deployment (I have a feeling
that is the root cause of my problems). As part of the deployment I
copy in this mdf file (not the log file), attach using CREATE DATABASE
with the FOR ATTACH_REBUILD_LOG option. I also have various scripts in
the deployment to configure everything.
I have tried re-inititialising at the publisher and recreating the
snapshot but still the same error.
Any help greatly appreciated on this and any better way of setting up
the initial database before first synchronisation.
.
- Follow-Ups:
- Prev by Date: Re: Drop replication question
- Next by Date: Re: The process could not bulk copy into table "dbo"."MSmerge_contents". Field size too large.
- Previous by thread: When i add a new table SQL2005 recreate the snapshot?
- Next by thread: Re: The process could not bulk copy into table "dbo"."MSmerge_contents". Field size too large.
- Index(es):
Relevant Pages
|
Loading
