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.

bcp copy in failed

11 posts in General Discussion Last posting was on 2009-12-01 20:14:09.0Z
Eugene Posted on 2009-11-30 21:14:56.0Z
From: Eugene <ekorolkov@davidsohn.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: bcp copy in failed
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b1435d0$1@forums-1-dub>
Date: 30 Nov 2009 13:14:56 -0800
X-Trace: forums-1-dub 1259615696 10.22.241.152 (30 Nov 2009 13:14:56 -0800)
X-Original-Trace: 30 Nov 2009 13:14:56 -0800, vip152.sybase.com
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28706
Article PK: 77947

Hi gurus,

Our client started to getting that message at the end of bcp on QA on
any file, though actually it is successful, the same configuration on
production does not produce that error.


ASE Server:

> select @@version

> Adaptive Server Enterprise/15.0.3/EBF 16548 ESD#1/P/Sun_svr4/OS 5.8/ase1503/2680/64-bit/FBO/Thu Mar 5 09:39:28 2009

bcp version:
> bcp -v
> Sybase CTBCP Utility/12.5.1/P/DRV.12.5.1.0/SPARC/Solaris 2.8/BUILD1251-004/OPT/Mon Nov 10 12:02:24 2003

Any ideas ?

Regards,
Eugene


"Mark A. Parsons" <iron_horse Posted on 2009-11-30 21:41:06.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub>
In-Reply-To: <4b1435d0$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091130-0, 11/30/2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b143bf2$1@forums-1-dub>
Date: 30 Nov 2009 13:41:06 -0800
X-Trace: forums-1-dub 1259617266 10.22.241.152 (30 Nov 2009 13:41:06 -0800)
X-Original-Trace: 30 Nov 2009 13:41:06 -0800, vip152.sybase.com
Lines: 35
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28707
Article PK: 77949

More details?

- bcp version string (bcp -v) used for each bcp operation ?

- actual bcp commands used against the 2 dataservers ?

- actual/complete bcp errors ?

- confirmation that *all* data is bcp'd into the table (and in the correct columns) ?

- any differences in the table schemas in the 2 dataservers ?

Eugene wrote:
> Hi gurus,
>
> Our client started to getting that message at the end of bcp on QA on
> any file, though actually it is successful, the same configuration on
> production does not produce that error.
>
>
> ASE Server:
>> select @@version
>
>> Adaptive Server Enterprise/15.0.3/EBF 16548 ESD#1/P/Sun_svr4/OS
>> 5.8/ase1503/2680/64-bit/FBO/Thu Mar 5 09:39:28 2009
>
> bcp version:
>> bcp -v
>> Sybase CTBCP Utility/12.5.1/P/DRV.12.5.1.0/SPARC/Solaris
>> 2.8/BUILD1251-004/OPT/Mon Nov 10 12:02:24 2003
>
> Any ideas ?
>
> Regards,
> Eugene


Eugene Posted on 2009-11-30 22:46:43.0Z
Message-ID: <4B144B58.8020707@davidsohn.com>
From: Eugene <ekorolkov@davidsohn.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub>
In-Reply-To: <4b143bf2$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 30 Nov 2009 14:46:43 -0800
X-Trace: forums-1-dub 1259621203 10.22.241.152 (30 Nov 2009 14:46:43 -0800)
X-Original-Trace: 30 Nov 2009 14:46:43 -0800, vip152.sybase.com
Lines: 97
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28710
Article PK: 77952

Mark,

>> - bcp version string (bcp -v) used for each bcp operation ?

See in prev.email

>> actual bcp commands used against the 2 dataservers ?

> bcp margins_yest..fxrates in tmp1.txt -c -U<user> -P<user_pwd> -S<server_name>
I do not think it is related to the file or/and table.
> Starting copy...
> bcp copy in failed

> bcp margins_yest..fxrates in tmp1.txt -c -b1 -U<user> -P<user_pwd> -S<server_name>
> Starting copy...
> Batch successfully bulk-copied to SQL Server.
> bcp copy in failed

Table (for example):

> CREATE TABLE dbo.fxrates
> (
> ccy_code char(3) NOT NULL,
> mult_div_ind char(1) NOT NULL,
> fx_rate float NOT NULL,
> market char(2) NOT NULL,
> last_update_time char(12) NULL
> )
> LOCK ALLPAGES
> go


tmp1.txt - has just 1 row
> od -c tmp1.txt
> 0000000 T R Y \t M \t 0 . 6 7 2 2 7 0 0 0
> 0000020 \t \t 0 \n
> 0000025


>> - actual/complete bcp errors ?
This is most tricky- no actual errors, everything went OK.
(not in stdout, not in err.file)

>> - confirmation that *all* data is bcp'd into the table (and in the
>> correct columns) ?

> select * from fxrates where ccy_code="TRY"
> go

> TRY M 0.67227 0

>> - any differences in the table schemas in the 2 dataservers ?
No


HTH,
Eugene


Mark A. Parsons wrote:
> More details?
>
> - bcp version string (bcp -v) used for each bcp operation ?
>
> - actual bcp commands used against the 2 dataservers ?
>
> - actual/complete bcp errors ?
>
> - confirmation that *all* data is bcp'd into the table (and in the
> correct columns) ?
>
> > - any differences in the table schemas in the 2 dataservers ?


>
> Eugene wrote:
>> Hi gurus,
>>
>> Our client started to getting that message at the end of bcp on QA on
>> any file, though actually it is successful, the same configuration on
>> production does not produce that error.
>>
>>
>> ASE Server:
>>> select @@version
>>
>>> Adaptive Server Enterprise/15.0.3/EBF 16548 ESD#1/P/Sun_svr4/OS
>>> 5.8/ase1503/2680/64-bit/FBO/Thu Mar 5 09:39:28 2009
>>
>> bcp version:
>>> bcp -v
>>> Sybase CTBCP Utility/12.5.1/P/DRV.12.5.1.0/SPARC/Solaris
>>> 2.8/BUILD1251-004/OPT/Mon Nov 10 12:02:24 2003
>>
>> Any ideas ?
>>
>> Regards,
>> Eugene


Neal Stack [Sybase] Posted on 2009-12-01 15:30:03.0Z
Message-ID: <4B15367A.1080002@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Eugene <ekorolkov@davidsohn.com>
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub> <4B144B58.8020707@davidsohn.com>
In-Reply-To: <4B144B58.8020707@davidsohn.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Dec 2009 07:30:03 -0800
X-Trace: forums-1-dub 1259681403 10.22.241.152 (1 Dec 2009 07:30:03 -0800)
X-Original-Trace: 1 Dec 2009 07:30:03 -0800, vip152.sybase.com
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28712
Article PK: 77956

Hello,

What is the server's character set (sp_helpsort)?
What is the client's character set (select @@client_csname)?
What is the DDL for the table?

If I have the above information, I will give it a try with the sample data you listed in your email.

Regards,
Neal


Eugene Posted on 2009-12-01 15:52:41.0Z
Message-ID: <4B153BCF.1060405@davidsohn.com>
From: Eugene <ekorolkov@davidsohn.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: "Neal Stack [Sybase]" <nstack@nospam.com>
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub> <4B144B58.8020707@davidsohn.com> <4B15367A.1080002@nospam.com>
In-Reply-To: <4B15367A.1080002@nospam.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Dec 2009 07:52:41 -0800
X-Trace: forums-1-dub 1259682761 10.22.241.152 (1 Dec 2009 07:52:41 -0800)
X-Original-Trace: 1 Dec 2009 07:52:41 -0800, vip152.sybase.com
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28713
Article PK: 77955

Neal,

1.

> Sort Order Description
>
> ------------------------------------------------------------------
> Character Set = 1, iso_1
> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
> Sort Order = 50, bin_iso_1
> Binary ordering, for the ISO 8859/1 or Latin-1 character set (
> iso_1).
> Characters, in Order
>
> ------------------------------------------------------------------
> ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
> @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
> ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
> ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
> Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
> á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
>
> (return status = 0)

2.
> 1> select @@client_csname
> 2> go
>
> ------------------------------
> iso_1
>
> (1 row affected)

3. See prev.email

HTH,
Eugene

Neal Stack [Sybase] wrote:
> Hello,
>
> What is the server's character set (sp_helpsort)?
> What is the client's character set (select @@client_csname)?
> What is the DDL for the table?
>
> If I have the above information, I will give it a try with the sample
> data you listed in your email.
>
> Regards,
> Neal


Neal Stack [Sybase] Posted on 2009-12-01 16:21:16.0Z
Message-ID: <4B15427A.1080703@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Eugene <ekorolkov@davidsohn.com>
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub> <4B144B58.8020707@davidsohn.com> <4B15367A.1080002@nospam.com> <4B153BCF.1060405@davidsohn.com>
In-Reply-To: <4B153BCF.1060405@davidsohn.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Dec 2009 08:21:16 -0800
X-Trace: forums-1-dub 1259684476 10.22.241.152 (1 Dec 2009 08:21:16 -0800)
X-Original-Trace: 1 Dec 2009 08:21:16 -0800, vip152.sybase.com
Lines: 111
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28715
Article PK: 77954

Hello,

It seems to work for me using the exact same version of bcp and nearly the same version of ASE.
My version of ASE only has one additional fix related to CIS so that should not make a difference.

Does your "sp_help fxrates" output show any differences from mine such as float scale/precision or indexes?

% od -c fxrates.dat
0000000 T R Y \t M \t 0 . 6 7 2 2 7 0 0 0
0000020 \t \t 0 \n
0000025
% ./bcp -v
Sybase CTBCP Utility/12.5.1/P/DRV.12.5.1.0/SPARC/Solaris 2.8/BUILD1251-004/OPT/Mon Nov 10 12:02:24 2003

% ./bcp tempdb..fxrates in fxrates.dat -Usa -P -c

Starting copy...

1 rows copied.
Clock Time (ms.): total = 1 Avg = 1 (1000.00 rows per sec.)

% isql -Usa -P -D tempdb -w 132
1> select @@version
2> select * from fxrates
3> go



---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Adaptive Server Enterprise/15.0.3/EBF 16919 ESD#1 ONE-OFF/P/Sun_svr4/OS 5.8/ase1503/2681/64-bit/FBO/Tue May 12 18:08:30 2009


(1 row affected)
ccy_code mult_div_ind fx_rate market last_update_time
-------- ------------ -------------------- ------ ----------------
TRY M 0.672270 0

(1 row affected)
1> sp_help fxrates
2> go
Name Owner Object_type Create_date
------- ----- ----------- -------------------
fxrates dbo user table Dec 1 2009 9:22AM

(1 row affected)
Column_name Type Length Prec Scale Nulls Default_name Rule_name Access_Rule_name Computed_Column_object Identity
---------------- ----- ------ ---- ----- ----- ------------ --------- ---------------- ---------------------- ----------
ccy_code char 3 NULL NULL 0 NULL NULL NULL NULL 0
mult_div_ind char 1 NULL NULL 0 NULL NULL NULL NULL 0
fx_rate float 8 NULL NULL 0 NULL NULL NULL NULL 0
market char 2 NULL NULL 0 NULL NULL NULL NULL 0
last_update_time char 12 NULL NULL 1 NULL NULL NULL NULL 0
Object does not have any indexes.
No defined keys for this object.


Regards,
Neal

Eugene wrote:
> Neal,
>
> 1.
>> Sort Order Description
>>
>> ------------------------------------------------------------------
>> Character Set = 1, iso_1
>> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
>> Sort Order = 50, bin_iso_1
>> Binary ordering, for the ISO 8859/1 or Latin-1 character set (
>> iso_1).
>> Characters, in Order
>>
>> ------------------------------------------------------------------
>> ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
>> @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
>> ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ ¡
>> ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
>> Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
>> á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
>>
>> (return status = 0)
>
> 2.
>> 1> select @@client_csname
>> 2> go
>>
>> ------------------------------
>> iso_1
>>
>> (1 row affected)
>
> 3. See prev.email
>
> HTH,
> Eugene
>
> Neal Stack [Sybase] wrote:
>> Hello,
>>
>> What is the server's character set (sp_helpsort)?
>> What is the client's character set (select @@client_csname)?
>> What is the DDL for the table?
>>
>> If I have the above information, I will give it a try with the sample
>> data you listed in your email.
>>
>> Regards,
>> Neal


Eugene Posted on 2009-12-01 16:54:10.0Z
Message-ID: <4B154A38.4050201@davidsohn.com>
From: Eugene <ekorolkov@davidsohn.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: "Neal Stack [Sybase]" <nstack@nospam.com>
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub> <4B144B58.8020707@davidsohn.com> <4B15367A.1080002@nospam.com> <4B153BCF.1060405@davidsohn.com> <4B15427A.1080703@nospam.com>
In-Reply-To: <4B15427A.1080703@nospam.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Dec 2009 08:54:10 -0800
X-Trace: forums-1-dub 1259686450 10.22.241.152 (1 Dec 2009 08:54:10 -0800)
X-Original-Trace: 1 Dec 2009 08:54:10 -0800, vip152.sybase.com
Lines: 167
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28716
Article PK: 77957

Neal,


It works for me either, it works on client production,
it worked fine on their QA till Oct.13 (!:-)) when they
reloaded schema/data from their production
(it was 12.5.3 at that moment) to QA (was 15.0.3 already)
and then it is started producing that during SOD (start of day) load
data to our system.

It even actually works fine on their QA now, except
producing msg 'bcp copy in failed' (without any details)
at the end of bcp in.
So far my advice to client was to drop/recreate indexes or/and dbcc


Example table has 2 add.indexes (see below), but thing is not related
to particular table/file input, it is happened on any loaded
during start of day file (8 files/tables)

HTH,
Eugene

> CREATE UNIQUE CLUSTERED INDEX index1
> ON dbo.fxrates(ccy_code)
> WITH IGNORE_DUP_KEY
> ON ds01_sgmt
> go
> IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.fxrates') AND name='index1')
> PRINT '<<< CREATED INDEX dbo.fxrates.index1 >>>'
> ELSE
> PRINT '<<< FAILED CREATING INDEX dbo.fxrates.index1 >>>'
> go
> CREATE INDEX index2
> ON dbo.fxrates(market,ccy_code)
> ON is01_sgmt
> go
> IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.fxrates') AND name='index2')
> PRINT '<<< CREATED INDEX dbo.fxrates.index2 >>>'
> ELSE
> PRINT '<<< FAILED CREATING INDEX dbo.fxrates.index2 >>>'
> go

Neal Stack [Sybase] wrote:
> Hello,
>
> It seems to work for me using the exact same version of bcp and nearly
> the same version of ASE.
> My version of ASE only has one additional fix related to CIS so that
> should not make a difference.
>
> Does your "sp_help fxrates" output show any differences from mine such
> as float scale/precision or indexes?
>
> % od -c fxrates.dat
> 0000000 T R Y \t M \t 0 . 6 7 2 2 7 0 0 0
> 0000020 \t \t 0 \n
> 0000025
> % ./bcp -v
> Sybase CTBCP Utility/12.5.1/P/DRV.12.5.1.0/SPARC/Solaris
> 2.8/BUILD1251-004/OPT/Mon Nov 10 12:02:24 2003
>
> % ./bcp tempdb..fxrates in fxrates.dat -Usa -P -c
>
> Starting copy...
>
> 1 rows copied.
> Clock Time (ms.): total = 1 Avg = 1 (1000.00 rows per sec.)
>
> % isql -Usa -P -D tempdb -w 132
> 1> select @@version
> 2> select * from fxrates
> 3> go
>
>
>
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Adaptive Server Enterprise/15.0.3/EBF 16919 ESD#1 ONE-OFF/P/Sun_svr4/OS
> 5.8/ase1503/2681/64-bit/FBO/Tue May 12 18:08:30 2009
>
> (1 row affected)
> ccy_code mult_div_ind fx_rate market last_update_time
> -------- ------------ -------------------- ------ ----------------
> TRY M 0.672270 0
>
> (1 row affected)
> 1> sp_help fxrates
> 2> go
> Name Owner Object_type Create_date
> ------- ----- ----------- -------------------
> fxrates dbo user table Dec 1 2009 9:22AM
>
> (1 row affected)
> Column_name Type Length Prec Scale Nulls Default_name Rule_name
> Access_Rule_name Computed_Column_object Identity
> ---------------- ----- ------ ---- ----- ----- ------------ ---------
> ---------------- ---------------------- ----------
> ccy_code char 3 NULL NULL 0 NULL NULL
> NULL NULL 0
> mult_div_ind char 1 NULL NULL 0 NULL NULL
> NULL NULL 0
> fx_rate float 8 NULL NULL 0 NULL NULL
> NULL NULL 0
> market char 2 NULL NULL 0 NULL NULL
> NULL NULL 0
> last_update_time char 12 NULL NULL 1 NULL NULL
> NULL NULL 0
> Object does not have any indexes.
> No defined keys for this object.
>
>
> Regards,
> Neal
>
>
> Eugene wrote:
>> Neal,
>>
>> 1.
>>> Sort Order Description
>>>
>>> ------------------------------------------------------------------
>>> Character Set = 1, iso_1
>>> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
>>> Sort Order = 50, bin_iso_1
>>> Binary ordering, for the ISO 8859/1 or Latin-1 character set (
>>> iso_1).
>>> Characters, in Order
>>>
>>> ------------------------------------------------------------------
>>> ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
>>> @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
>>> ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
>>> ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
>>> Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
>>> á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
>>>
>>> (return status = 0)
>>
>> 2.
>>> 1> select @@client_csname
>>> 2> go
>>>
>>> ------------------------------
>>> iso_1
>>>
>>> (1 row affected)
>>
>> 3. See prev.email
>>
>> HTH,
>> Eugene
>>
>> Neal Stack [Sybase] wrote:
>>> Hello,
>>>
>>> What is the server's character set (sp_helpsort)?
>>> What is the client's character set (select @@client_csname)?
>>> What is the DDL for the table?
>>>
>>> If I have the above information, I will give it a try with the sample
>>> data you listed in your email.
>>>
>>> Regards,
>>> Neal


Neal Stack [Sybase] Posted on 2009-12-01 19:30:32.0Z
Message-ID: <4B156ED9.2090200@nospam.com>
From: "Neal Stack [Sybase]" <nstack@nospam.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: Eugene <ekorolkov@davidsohn.com>
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub> <4B144B58.8020707@davidsohn.com> <4B15367A.1080002@nospam.com> <4B153BCF.1060405@davidsohn.com> <4B15427A.1080703@nospam.com> <4B154A38.4050201@davidsohn.com>
In-Reply-To: <4B154A38.4050201@davidsohn.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Dec 2009 11:30:32 -0800
X-Trace: forums-1-dub 1259695832 10.22.241.152 (1 Dec 2009 11:30:32 -0800)
X-Original-Trace: 1 Dec 2009 11:30:32 -0800, vip152.sybase.com
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28719
Article PK: 77961

Do all 8 problematic tables have a float column?

Do all 8 tables have a nullable final column?

Are they using the "-e errfile.txt" parameter when copying in (I didn't see that parameter in your email)?

Regards,
Neal


Eugene Posted on 2009-12-01 20:14:09.0Z
Message-ID: <4B157917.5040106@davidsohn.com>
From: Eugene <ekorolkov@davidsohn.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: "Neal Stack [Sybase]" <nstack@nospam.com>
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub> <4B144B58.8020707@davidsohn.com> <4B15367A.1080002@nospam.com> <4B153BCF.1060405@davidsohn.com> <4B15427A.1080703@nospam.com> <4B154A38.4050201@davidsohn.com> <4B156ED9.2090200@nospam.com>
In-Reply-To: <4B156ED9.2090200@nospam.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Dec 2009 12:14:09 -0800
X-Trace: forums-1-dub 1259698449 10.22.241.152 (1 Dec 2009 12:14:09 -0800)
X-Original-Trace: 1 Dec 2009 12:14:09 -0800, vip152.sybase.com
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28721
Article PK: 77964

Neal,

1. No
2. No
3. Does not matter, there are no errors anyway

There no "problematic" tables, it is just only 8 of them getting loaded,
but I can take any table and I just did with small "dictionary/constant
" table 'account_type' (2 columns, 3 recs, all chars) did bcp out (OK),
then deleted all 3 recs, did bcp in (OK, but again msg "bcp copy in
failed" at the end).

I think something wrong with database. I am asking hoping that somebody
had the same or knows something, cause I already researched solved
cases, newsgroups, EBFS bug fixes, did open case, so far nothing.
I am not expecting too much from newsgroup or/and TS, just maybe
somebody had that puzzle in the past ?

Again I think it is started when they loaded data and for some reason
copied over using defncopy views, sps from prod (12.5.3/4 at that
moment) to qa (15.0.3, though it seems to me that they had something
like this long time ago (without any 15.0.3)

I suggested to to do dbcc, or/and drop/recreate indexes ( I cannot do it
on their site, only bcp in/out, insert/delete/select/update, even
truncate or/and getting ASE log not possible, cause I am not the owner
or sa_role).

HTH,
Eugene

Neal Stack [Sybase] wrote:
> Do all 8 problematic tables have a float column?
>
> Do all 8 tables have a nullable final column?
>
> Are they using the "-e errfile.txt" parameter when copying in (I didn't
> see that parameter in your email)?
>
> Regards,
> Neal


J Posted on 2009-12-01 16:11:20.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: bcp copy in failed
Reply-To: J@bogusemailAddress.com
Message-ID: <4b153feb.904370@forums.sybase.com>
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub> <4B144B58.8020707@davidsohn.com> <4B15367A.1080002@nospam.com> <4B153BCF.1060405@davidsohn.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Dec 2009 08:11:20 -0800
X-Trace: forums-1-dub 1259683880 10.22.241.152 (1 Dec 2009 08:11:20 -0800)
X-Original-Trace: 1 Dec 2009 08:11:20 -0800, vip152.sybase.com
Lines: 57
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28714
Article PK: 77959

On 1 Dec 2009 07:52:41 -0800, Eugene <ekorolkov@davidsohn.com> wrote:

Does a more recent version of bcp give you the same problem? Are you
positive that the qa and production versions are the same?

J

>Neal,
>
>1.
>> Sort Order Description
>>
>> ------------------------------------------------------------------
>> Character Set = 1, iso_1
>> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
>> Sort Order = 50, bin_iso_1
>> Binary ordering, for the ISO 8859/1 or Latin-1 character set (
>> iso_1).
>> Characters, in Order
>>
>> ------------------------------------------------------------------
>> ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
>> @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
>> ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
>> ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
>> Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
>> á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
>>
>> (return status = 0)
>
>2.
>> 1> select @@client_csname
>> 2> go
>>
>> ------------------------------
>> iso_1
>>
>> (1 row affected)
>
>3. See prev.email
>
>HTH,
>Eugene
>
>Neal Stack [Sybase] wrote:
>> Hello,
>>
>> What is the server's character set (sp_helpsort)?
>> What is the client's character set (select @@client_csname)?
>> What is the DDL for the table?
>>
>> If I have the above information, I will give it a try with the sample
>> data you listed in your email.
>>
>> Regards,
>> Neal


Eugene Posted on 2009-12-01 17:13:28.0Z
Message-ID: <4B154EBE.404@davidsohn.com>
From: Eugene <ekorolkov@davidsohn.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
To: J@bogusemailAddress.com
Subject: Re: bcp copy in failed
References: <4b1435d0$1@forums-1-dub> <4b143bf2$1@forums-1-dub> <4B144B58.8020707@davidsohn.com> <4B15367A.1080002@nospam.com> <4B153BCF.1060405@davidsohn.com> <4b153feb.904370@forums.sybase.com>
In-Reply-To: <4b153feb.904370@forums.sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 1 Dec 2009 09:13:28 -0800
X-Trace: forums-1-dub 1259687608 10.22.241.152 (1 Dec 2009 09:13:28 -0800)
X-Original-Trace: 1 Dec 2009 09:13:28 -0800, vip152.sybase.com
Lines: 68
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28717
Article PK: 77960

J,

I have asked client to upgrade to more recent version,
but it is the same on their production and moreover
worked fine in the past (like 1,5 months).
Looks like the same, but definitely something changed,
I am suspecting that problem arose after client reloaded
data from production (at that time 12.5.3/4) to qa (15.0.3)

HTH,
Eugene

J wrote:
> On 1 Dec 2009 07:52:41 -0800, Eugene <ekorolkov@davidsohn.com> wrote:
>
> Does a more recent version of bcp give you the same problem? Are you
> positive that the qa and production versions are the same?
>
> J
>
>> Neal,
>>
>> 1.
>>> Sort Order Description
>>>
>>> ------------------------------------------------------------------
>>> Character Set = 1, iso_1
>>> ISO 8859-1 (Latin-1) - Western European 8-bit character set.
>>> Sort Order = 50, bin_iso_1
>>> Binary ordering, for the ISO 8859/1 or Latin-1 character set (
>>> iso_1).
>>> Characters, in Order
>>>
>>> ------------------------------------------------------------------
>>> ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
>>> @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
>>> ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~
>>> ¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ ­ ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
>>> Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
>>> á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ
>>>
>>> (return status = 0)
>> 2.
>>> 1> select @@client_csname
>>> 2> go
>>>
>>> ------------------------------
>>> iso_1
>>>
>>> (1 row affected)
>> 3. See prev.email
>>
>> HTH,
>> Eugene
>>
>> Neal Stack [Sybase] wrote:
>>> Hello,
>>>
>>> What is the server's character set (sp_helpsort)?
>>> What is the client's character set (select @@client_csname)?
>>> What is the DDL for the table?
>>>
>>> If I have the above information, I will give it a try with the sample
>>> data you listed in your email.
>>>
>>> Regards,
>>> Neal
>