x

bcp gives EXCEPTION_ACCESS_VIOLATION error

Hello, I am trying to move data from one SQL server 2000 database into another by using bcp out and bcp in. The data is in Unicode so I have used -w in the bcp command. While it works with most tables, for some tables the import fails and following error is displayed SQLState = HY000, NativeError = 0 Error = [Microsoft][SQL Native Client][SQL Server]SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. SQLState = 08S01, NativeError = 4 Error = [Microsoft][SQL Native Client]Shared Memory Provider: I/O Error detected in read/write operation [4]. SQLState = 08S01, NativeError = 4 Error = [Microsoft][SQL Native Client]Communication link failure SQLState = 08S01, NativeError = 0 Error = [Microsoft][SQL Native Client]Communication link failure

any help on this will be much appreciated. thanks ASK
more ▼

asked Jul 13, 2010 at 03:13 AM in Default

Angeli gravatar image

Angeli
23 4 4 4

can you provide the bcp command that you tried so it will be more clear
Jul 13, 2010 at 03:27 AM Cyborg
(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first
It's pretty likely that the hardware on the machine is faulty. Use a decent memory checking application to validate it, would be my first point of call.
more ▼

answered Jul 13, 2010 at 04:10 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

May be the problem of service packs
Jul 13, 2010 at 04:13 AM Cyborg
(comments are locked)
10|1200 characters needed characters left

While not the answer to your issue per se try and create a DTS package to perform the same transfer and see if it fails as well.


-- EDIT -- (Response to user's answer to this question)


Since DTS fails as well we have ruled out a few scenarios - such as the process space of the executable for instance.

The error points towards the shared memory provider and network connectivity. You may have an issue with RAM, a faulty NIC, a memory leak or some other such issue.

As loathe as I am to suggest it - try rebooting the server and see if the error clears. In addition you may need to run a full hardware diagnostic on the box.
more ▼

answered Jul 13, 2010 at 05:36 AM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 37

well, I have already tried rebooting the machine and that doesn't work. The database is a test database running on a desktop PC. What hardware diagnostics do you suggest?
Jul 13, 2010 at 06:13 AM Angeli
Workstation huh? Check your vendor's website for diag tools.
As a workaround you can try to:
1) BCP out the table to a local text file.
2) Manually copy the file to the server.
2) BCP in the text file.
Jul 13, 2010 at 08:14 AM Blackhawk-17
it seems the error was appearing because I was using MSDE. It works fine on SQL 2000 server Thank you all for your help
Jul 14, 2010 at 02:20 AM Angeli
(comments are locked)
10|1200 characters needed characters left

Thanks you for your quick responses...

The commands used were for creating data file: bcp dbname1.dbo.tablename out tablename -Ssvrname -Usa -Ppwd -w for loading it: bcp dbname2.dbo.tablename out tablename -Ssvrname -Usa -Ppwd -w

Other tables with longer record lengths and more number of records were successfully copied but this one and a few others failed on every attempt

more ▼

answered Jul 13, 2010 at 05:21 AM

Angeli gravatar image

Angeli
23 4 4 4

(comments are locked)
10|1200 characters needed characters left
DTS gives the same error.
more ▼

answered Jul 13, 2010 at 05:55 AM

Angeli gravatar image

Angeli
23 4 4 4

Rather than commenting with an answer you probably should use the "add new comment" button.
Jul 13, 2010 at 05:59 AM Blackhawk-17
OK. will do so in future
Jul 13, 2010 at 05:59 AM Angeli
can i have your source and target Server details?
Jul 13, 2010 at 06:02 AM Cyborg
Source and target databases are on the same machine which is a desktop m/c , Duo core, 3B ram being used for development. The table is not large, just about 9000 records
Jul 13, 2010 at 06:20 AM Angeli
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x57
x42
x29
x1

asked: Jul 13, 2010 at 03:13 AM

Seen: 2099 times

Last Updated: Jul 13, 2010 at 03:13 AM