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

avatar image

Angeli
23 4 5 6

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

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

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

avatar image

Blackhawk-17
12k 30 35 42

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

avatar image

Angeli
23 4 5 6

(comments are locked)
10|1200 characters needed characters left

DTS gives the same error.

more ▼

answered Jul 13, 2010 at 05:55 AM

avatar image

Angeli
23 4 5 6

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.

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:

x75
x49
x48
x1

asked: Jul 13, 2010 at 03:13 AM

Seen: 2428 times

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

Copyright 2016 Redgate Software. Privacy Policy