Replication Error

Question

Post reply

Replication Error

Santhosh Kumar

Right there with Babe

Points: 766
More actions
January 5, 2006 at 9:33 am

#166396

I am doing a transaction replication and I am getting the below error
The process could not bulk copy out of table '[dbo].[syncobj_0x3633313839453446]'.
Any insights guys?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Joe Nakanishi-3 SSC Eights! Points: 828 More actions · Answer 1

Was there more to this error message? Did replication ever work?

Did you check out the replication monitor?

Santhosh Kumar Right there with Babe Points: 766 More actions · Answer 2

No Problem I got it fixed. That was a space issue in the distributor. I tried to set up an error output file and now its working.

Justin Smith-296127 Valued Member Points: 58 More actions · Answer 3

I have the exact same error message, when trying to replicate a single table across my network. Would you mind explaining how you fixed it?

Santhosh Kumar Right there with Babe Points: 766 More actions · Answer 4

Justin,

It might happen due to a couple of reason.

1. The disk might be running out of space.

2. The transaction log might have filled.

You can add the error log or redirect the error to a text file as shown below

-Output C:\Temp\OUTPUTFILE.txt -Outputverboselevel [2]

This link will give you more details

http://support.microsoft.com/default.aspx?scid=kb;en-us;312292&sd=tech

on redirecting the output to a file. from that error file you can find out the error easily.

Justin Smith-296127 Valued Member Points: 58 More actions · Answer 5

I had just pulled the output file before I got your reply:

Microsoft SQL Server Snapshot Agent 7.00.623

Microsoft SQL Server Replication Agent: HERSSQL01-summitseq-summitseq-9

Connecting to Distributor 'HERSSQL01'

Connecting to Publisher 'HERSSQL01.summitseq'

HERSSQL01.summitseq: sp_MSgetversion

Initializing the publication 'summitseq'

Fetching the articles from the publisher.

Generating schema script for article 'TWinReg'

Generating snapshots of the articles in the publication.

Bulk copying snapshot data for article 'TWinReg'

select * from [dbo].[syncobj_0x3637463232343831] where 1 = 2

HERSSQL01.summitseq: select * from [dbo].[syncobj_0x3637463232343831] where 1 = 2

This is what i got. Doesn't look to me like the "where 1 = 2" clause should be in there, but I do not know of anywhere that I could have put that in. Any help you can offer would be appreciated.