sql server replication: COULD NOT BULK COPY OUT OF TABLE (VERY URGENT) -- sql server replication

COULD NOT BULK COPY OUT OF TABLE (VERY URGENT)

belgiozen NO[at]SPAM yahoo.com
2/20/2004 1:04:35 AM

sql server replication:

Hi,
I use FTP Merge Replication over internet.Two weeks ago,I
created the publication on the development
server .Everything was working fine.
But when I ran the snapshot jobs for the second time, the
jobs failed.I ran them again in order to understand the
exact error with OutputVerbosal 2, I see that the snapshot
agent applies all table,stored proc etc. scripts,

but When it strats to bulk copy from tables,it immediately
gives error, In other word it can not bulk copy when there
is data in MSMERGE_CONTENTS(But when I DELETE ALL RECORDS
FROM MSMERGE_CONTENTS, SNAPSHOT JOB RUNS
SUCCESSFULLY)...The details of this error is given below;

In error log, after the message
"Bulk Copying snapshot data for system table
MsMerge_Contents", an error occurs with a message;

"The process could not bulk copy out of
table 'cont00355CADEDF243C791E95897E0519081'."
Erorr Details
Internal SQL Server error.(Source: Error number: 8624)

Is this a security issue related with bulk copy OR table
rights?

Regards,
Belgi Ozen

(Windows 200O,Microsoft SQL Server 2000 - 8.00.818

Re: COULD NOT BULK COPY OUT OF TABLE (VERY URGENT)

johnston NO[at]SPAM mounet.com
2/20/2004 9:35:49 AM

Have you tried to open cont00355CADEDF243C791E95897E0519081? Open it
up in design mode and see what it is doing. If there are a bunch of
joins on views, then it might qualify for a hotfix from Microsoft. I
had this problem awhile back with creating Dynamic Snapshots and had
to apply a hotfix. Anytime I get an "Internal SQL Error" it's usually
out of my realm to fix!!!!

V/R Jim Johnston
MCSD.NET, MCDBA

[quoted text, click to view]

Re: COULD NOT BULK COPY OUT OF TABLE (VERY URGENT)

belgiozen
2/22/2004 5:56:05 AM

I can not edit cont00355CADEDF243C791E95897E0519081 because it does not exist actually.It is created temporary during the snapshot process. So after the job fails I can not edit it.
Is there a way to create it manually as the agent creates to see what is happenning??
Which hotfix did you apply to solve this issue?
There is astored proc named sp_MsInitDynamicSubscriber to initialize the subscriber without using bulkcopy. Do u know what parameters should I pass so that it runs properly...I tird with some parameters but did not get what I expected...

I use MS SQL SERVER 2000 with Service Pack 3a ..
Regards,

Re: COULD NOT BULK COPY OUT OF TABLE (VERY URGENT)

johnston NO[at]SPAM mounet.com
2/23/2004 12:01:40 PM

The microsoft knowledge base article was 827954, but you will need to
open a support case with Microsoft to verify this. I looked at one of
the cont** views on my Publisher and it contains the same join views
which we had experienced problems with. Good Luck!!

V/R Jim Johnston
MCSD.NET, MCDBA

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.