BCP problems with OpenSwitch 12.5

Braulio Rojas

unread,

Nov 22, 2007, 10:39:27 AM11/22/07

to

Hi Guys,

Is BCP supported on OpenSwitch 12.5 without using Full Passthrough option?

I have a customer who's trying to do the BCP but is getting} the following
error message:
----------------
E:\>bcp P_Independencia..cie_contratos_concilia_tmp2 in
cie_contratos_conciliacion.bcp -Ucierre_noc2 -SFISA_OSW -c -Pcierre_noc2sys
Server Message: MEX_OSW - Msg 16044, Level 10, State 0:
The blk_srvinit() datatype '16' is not a known datatype

Server Message: MEX_OSW - Msg 0, Level 0, State 0:
STATE EVENT: blk layer: user error: Cannot call API blkdrop() from this
state: initialized
CTLIB Message: - L0/O0/S0/N0/0/0:
blk_init(): blk layer: CT library error: Failed when CT_Lib routine
ct_results() called.
blk_init failed.
----------------
OpenSwitch version:
----------------
Sybase OpenSwitch/12.5.1/EBF 13270/P/Linux Intel/Linux 2.4.9-e.40enterprise
i686/0/OPT/Wed Feb 15 22:54:53 2006

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

Ct is having problems with numeric(6, 0) columns that have a default
defined.
If ct changes the column definition to int instead of numeric(6, 0) the BCP
works OK.

Any advice?

Thanks,

Braulio Rojas
Sybase de México

A Cornell

unread,

Nov 23, 2007, 7:46:52 PM11/23/07

to

BCP is not supported thru openswitch

"Braulio Rojas" <bro...@sybase.com> wrote in message
news:4745a2af$1@forums-1-dub...

SybaseNeal

unread,

Nov 26, 2007, 9:59:38 AM11/26/07

to Braulio Rojas

Hello,

bcp is supported in OpenSwitch 12.5.1 and later via a new configuration
parameter named "BCP_LOGGED":
http://manuals.sybase.com/onlinebooks/group-os/osg1251e/openswug/@Generic__BookTextView/2992;pt=4166#X

Datatype '16' is CS_NUMERIC_TYPE and should also be supported.

Are they using a very old version of bcp? If so, that might be the problem.
If the customer is using a DB-Library version of bcp (pre 11.1.x) numeric is
not a valid data type unless bcp calls the DB-Library API "dbsetversion(DBVERSION_100)".

I have seen where old DB-Library applications did not call dbsetversion().
and queried a table with a numeric column. ASE knew that the application
did not support numeric, so ASE converted the numeric columns to float.
OpenSwitch does not do this, it raises the error.

I tried to reproduce the problem with OpenSwitch 12.5.1 and bcp 15.0 with
the following table definition but could not:
1> sp_help t1
2> go
Name Owner
Object_type
------------------------------------------------------------ ------------------------------------------------------------
----------------------------------------------------------------
t1 dbo
user table

(1 row affected)
Data_located_on_segment When_created
------------------------------------------------------------ --------------------------
default Nov 26 2007 7:38AM
Column_name Type Length Prec Scale Nulls Default_name
Rule_name Access_Rule_name Identity
------------------------------ ------------------------------ ----------- ---- ----- ----- ------------------------------
------------------------------ ------------------------------------------------------------ --------
c1 int 4 NULL NULL 0 NULL
NULL NULL 0
c2 char 1 NULL NULL 0 NULL
NULL NULL 0
c3 numeric 4 6 2 0 NULL
NULL NULL 0