The process could not bulk copy into table '"dbo"."MSmerge_genhistory"' - Urgent
Venketash (Pat) Ramadass
We are running Merge Replication for SSL between SQL Server 2005 Standard
Edition SP2 Server and SQL Server 2005 Express Edition SP2 (With Advanced
Services) Subscribers. We actually have 3 publications per SUBSCRIBER, one
for tables, one for SPs and one for Views. The application that uses this is
a Recruitment Solution and we have had numerous issues with having to
re-initiliase subscribers either when changes have been made to the
publication or just with other various errors, so the multiple publications
seemed a good way to go in terms of limiting risk.
Out of the blue when releasing an update yesterday we had to make some
changes to the Views publication and it required a re-init. Now every time
we synchronise from ANY subscriber we are getting...
2008-02-22 09:12:36.954 Bulk copied data into table 'MSmerge_contents' (0
rows)
2008-02-22 09:12:36.954 OLE DB Subscriber *****************': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2008-02-22 09:12:36.969 Percent Complete: 0
2008-02-22 09:12:36.969 Bulk copied data into table 'sysmergesubsetfilters'
(0 rows)
2008-02-22 09:12:36.969 Disconnecting from OLE DB Subscriber
*****************'
2008-02-22 09:12:36.969 Disconnecting from OLE DB Subscriber
*****************'
2008-02-22 09:12:36.969 Disconnecting from OLE DB Subscriber
*****************'
2008-02-22 09:12:36.969 The merge process was unable to deliver the snapshot
to the Subscriber. If using Web synchronization, the merge process may have
been unable to create or write to the message file. When troubleshooting,
restart the synchronization with verbose history logging and specify an
output file to which to write.
2008-02-22 09:12:36.969 OLE DB Subscriber '*****************': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2008-02-22 09:12:37.016 Percent Complete: 0
2008-02-22 09:12:37.016 The merge process was unable to deliver the snapshot
to the Subscriber. If using Web synchronization, the merge process may have
been unable to create or write to the message file. When troubleshooting,
restart the synchronization with verbose history logging and specify an
output file to which to write.
2008-02-22 09:12:37.079 Percent Complete: 0
2008-02-22 09:12:37.079 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The merge process was unable to deliver the snapshot to the
Subscriber. If using Web synchronization, the merge process may have been
unable to create or write to the message file. When troubleshooting, restart
the synchronization with verbose history logging and specify an output file
to which to write.
2008-02-22 09:12:37.079 Percent Complete: 0
2008-02-22 09:12:37.079 Category:AGENT
Source: NEIL-PC\PeopleSource
Number: 20037
Message: The process could not bulk copy into table
'"dbo"."MSmerge_genhistory"'.
2008-02-22 09:12:37.079 Percent Complete: 0
2008-02-22 09:12:37.079 Category:NULL
Source: Microsoft SQL Native Client
Number: 4861
Message: Cannot bulk load because the file
"C:\DOCUME~1\neil\LOCALS~1\Temp\*****************\MSmerge_genhistory90.bcp"
could not be opened. Operating system error code 5(error not found).
2008-02-22 09:12:37.079 Percent Complete: 0
2008-02-22 09:12:37.079 Category:NULL
Source:
Number: 20253
Message: To obtain an error file with details on the errors encountered when
initializing the subscribing table, execute the bcp command that appears
below. Consult the BOL for more information on the bcp utility and its
supported options.
2008-02-22 09:12:37.079 Percent Complete: 0
2008-02-22 09:12:37.079 Category:NULL
Source:
Number: 20253
Message: bcp "PSRecruitment"."dbo"."MSmerge_genhistory" in
"C:\DOCUME~1\*****************\MSmerge_genhistory90.bcp" -e
"errorfile" -t"\n<x$3>\n" -r"\n<,@g>\n" -m10000 -SNEIL-PC\PeopleSource -T -w
...on ever database on which we have run the update! I have tried
re-initialising the subscribers, removing and re-adding the articles,
rebuilding the snapshot and nothinhg is making a difference? Any help much
appreciated.
Thanks,
Venkeash (Pat) Ramadass
emediaIT
Venketash (Pat) Ramadass
Removing -UseInProcLoader has fixed this problem.
Thanks,
Venketash (Pat) Ramadass
emediaIT
"Venketash (Pat) Ramadass" <pat.ra...@emediait.com> wrote in message
news:83028B7A-238F-4464...@microsoft.com...
hab...@gmail.com
<pat.ramad...@emediait.com> wrote:
> Hi again,
>
> Removing -UseInProcLoader has fixed this problem.
>
> Thanks,
>
> Venketash (Pat) Ramadass
> emediaIT
>
Hi,
May be I have the same problem with below error:
The merge process was unable to deliver the snapshot to the
Subscriber. If using Web synchronization, the merge process may have
been unable to create or write to the message file. When
troubleshooting, restart the synchronization with verbose history
logging and specify an output file to which to write. (Source:
MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
The process could not bulk copy into table '"dbo"."Account"'. (Source:
MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
Field size too large (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
To obtain an error file with details on the errors encountered when
initializing the subscribing table, execute the bcp command that
appears below. Consult the BOL for more information on the bcp
utility and its supported options. (Source: MSSQLServer, Error number:
20253)
Get help: http://help/20253
bcp "MISA_HeadOffice"."dbo"."Account" in "\\nvxo\ReplicationData\unc
\_MISA_SG_SG\20080320152790\Account_2.bcp" -e "errorfile" -t"\n<x$3>
\n" -r"\n<,@g>\n" -m10000 -Snvxo\sql2005 -T -w (Source: MSSQLServer,
Error number: 20253)
Get help: http://help/20253
How could I resolve this ?
what you mean Removing -UseInProcLoader ?
Thank so much