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

asked Jul 13 '10 at 03:13 AM in Default

Angeli
23 ● 4 ● 4 ● 4

can you provide the bcp command that you tried so it will be more clear

Jul 13 '10 at 03:27 AM Cyborg

(comments are locked)

4 answers:

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.

answered Jul 13 '10 at 04:10 AM

Matt Whitfield ♦♦
29.2k ● 56 ● 63 ● 87

May be the problem of service packs

Jul 13 '10 at 04:13 AM Cyborg

(comments are locked)

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.

answered Jul 13 '10 at 05:36 AM

Blackhawk-17
10.5k ● 23 ● 29 ● 34

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 '10 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 '10 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 '10 at 02:20 AM Angeli

(comments are locked)

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

answered Jul 13 '10 at 05:21 AM

Angeli
23 ● 4 ● 4 ● 4

(comments are locked)

DTS gives the same error.

answered Jul 13 '10 at 05:55 AM

Angeli
23 ● 4 ● 4 ● 4

Rather than commenting with an answer you probably should use the "add new comment" button.

Jul 13 '10 at 05:59 AM Blackhawk-17

OK. will do so in future

Jul 13 '10 at 05:59 AM Angeli

can i have your source and target Server details?

Jul 13 '10 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 '10 at 06:20 AM Angeli

(comments are locked)