all groups > sql server replication > december 2005 >
You're in the

sql server replication

group:

Error - Building Replication


Error - Building Replication Shiv
12/27/2005 2:00:02 AM
sql server replication: Hi,I am building the Transactional Replication.It thro's Error Like below.

The process could not bulk copy out of table
'[dbo].[syncobj_0x3435344541393145]'.

I/O error while writing BCP data-file

Category : ODBC
Source : ODBC SQL Server Driver

But I have Checked the Space in Both OLTP and Replication Server it has
enough space.

Is prob in ODBC Driver???? pls guide me to rectify this Prob.

Regards
Sivaraman Latchapathi
Re: Error - Building Replication Shiv
12/27/2005 6:32:03 AM
Hi, As u said syncobj_0x3435344541393145 is View ... i can able to see the
record
in that view also i can able to query physical table which is related to
that view.

[quoted text, click to view]
Re: Error - Building Replication Hilary Cotter
12/27/2005 8:01:40 AM
Do a select * from syncobj_0x3435344541393145 to see if there aren't
physical problems with this table. Also do a sp_helptext
syncobj_0x3435344541393145 to see if this view can't benefit from indexes on
the base tables.

Now check the event log to see if you can't see disk error problems.

These errors tend to be transitory.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Re: Error - Building Replication Hilary Cotter
12/27/2005 10:11:02 AM
ok, now try to bcp out of this view into the file system to see if you can
do this successfully.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

AddThis Social Bookmark Button