Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem with BCP

2 posts in ,  Performance and TuningGeneral DiscussionWindows NT Administration Last posting was on 1998-05-20 13:51:43.0Z
Richard R. Klemmer Posted on 1998-04-02 11:52:18.0Z
From: "Richard R. Klemmer" <richard.klemmer@NOSPAM.usda.com>
Subject: Problem with BCP
Organization: USDA-FSIS
Message-ID: <01bd5e36$d3da83c0$663b80c7@rklemmer.fsis.usda.gov>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.general,sybase.public.sqlserver.nt,sybase.public.sqlserver.performance+tuning
Date: Thu, 02 Apr 1998 06:52:18 -0500
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.administration:3314 sybase.public.sqlserver.general:769 sybase.public.sqlserver.nt:379 sybase.public.sqlserver.performance+tuning:241
Article PK: 1065477

For the past couple of Months, I have been using BCP on an almost daily
basis to import data into SQL Server System 11 from a DBase database. This
has been working smoothly up until Yesterday. Now I am having problems
importing the data.
The only error message returned is "DB-LIBRARY error: Write to SQL Server
failed." And this only after it has been trying to copy the data for
anywhere from 15 to 60 minutes. Sometime, after an hour, it will copy the
data. The number of rows being copied are from 300 to 500. The two tables
that seem to be having the most problems have 21 and 37 columns in them.
I have checked, and there is plenty of room on the Device that the Data
and Log are on. Also, the tempdb had plenty of room, although I don't
think this would be an issue.
I'm able to BCP out without any problems or delays. I've tried increasing
the Physical Memory, but that didn't help. I originally had 64 MB and then
increased it to 128 MB (which seems ridiculously high to me.) The total
memory on the Server is 256, and there is nothing else running on the
Server.
If anyone has any ideas, please post a message here, or send me e-mail at
Richard.Klemmer@usda.gov. Thank you.

The Server information is

Sybase SQL Server version 11.0.3 for Windows NT Intel.
BCP version 10.0.4


Dinyar Posted on 1998-05-20 13:51:43.0Z
Message-ID: <3562DFEE.63328BA9@rocketmail.com>
Date: Wed, 20 May 1998 19:21:43 +0530
From: Dinyar <dinyar@rocketmail.com>
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
To: "Richard R. Klemmer" <richard.klemmer@usda.com>
Subject: Re: Problem with BCP
References: <01bd5e36$d3da83c0$663b80c7@rklemmer.fsis.usda.gov>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 47
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:4989
Article PK: 1092352

hi, just a couple of questions.
1) have u tried an older version of bcp?
2) was the same version working all along?
3) have u tried sending in batches?
4) can u post the output of sp_helpdb db_name?
5) can u post row no.21 and 37?
6) is your data delimited or fixed length?
7) if fixed length, can u post your format file?
8) if delimited, what is the delimeter?
regards
Dinyar

Richard R. Klemmer wrote:

> For the past couple of Months, I have been using BCP on an almost daily
> basis to import data into SQL Server System 11 from a DBase database. This
> has been working smoothly up until Yesterday. Now I am having problems
> importing the data.
> The only error message returned is "DB-LIBRARY error: Write to SQL Server
> failed." And this only after it has been trying to copy the data for
> anywhere from 15 to 60 minutes. Sometime, after an hour, it will copy the
> data. The number of rows being copied are from 300 to 500. The two tables
> that seem to be having the most problems have 21 and 37 columns in them.
> I have checked, and there is plenty of room on the Device that the Data
> and Log are on. Also, the tempdb had plenty of room, although I don't
> think this would be an issue.
> I'm able to BCP out without any problems or delays. I've tried increasing
> the Physical Memory, but that didn't help. I originally had 64 MB and then
> increased it to 128 MB (which seems ridiculously high to me.) The total
> memory on the Server is 256, and there is nothing else running on the
> Server.
> If anyone has any ideas, please post a message here, or send me e-mail at
> Richard.Klemmer@usda.gov. Thank you.
>
> The Server information is
>
> Sybase SQL Server version 11.0.3 for Windows NT Intel.
> BCP version 10.0.4
>