Problem s BCP

RV vicek.radek na cpost.cz
Pátek Prosinec 3 14:24:08 CET 2010


Dobry den,

potreboval bych rucne "materializovat" tabulku sekundarni DB a nejak se 
potykam s BCP. Data se mi odmitaji naloudovat.

Jedna se o dve identicke tabulky jen s ruznym nazvem viz. priloha.

Data se mi snad dari vycist bez chyb timto prikazem:

bcp hpstred..st_fakturace out st_fakturace_out -Shposta -Usa -Pxxx -J 
cp1250 -c

Bohuzel naliti dat timto prikazem dopadne takto:

C:\Users\55720\Documents\HP\Skripty\BCP>bcp hpcent..hp_fakturace in 
st_fakturace_out -Shybrid-test -Usa -Pxxx -c -J cp1250

Starting copy...
CSLIB Message:  - L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The 
conversion/operation was stopped due to a syntax error in the source field

CSLIB Message:  - L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The 
conversion/operation was stopped due to a syntax error in the source field

CSLIB Message:  - L0/O0/S0/N36/1/0:
cs_convert: cslib user api layer: common library error: The result is 
truncated because the conversion/operation resulted in overflow.
CSLIB Message:  - L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The 
conversion/operation was stopped due to a syntax error in the source field

CSLIB Message:  - L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The 
conversion/operation was stopped due to a syntax error in the source field

CSLIB Message:  - L0/O0/S0/N36/1/0:
cs_convert: cslib user api layer: common library error: The result is 
truncated because the conversion/operation resulted in overflow.
CSLIB Message:  - L0/O0/S0/N24/1/0:
cs_convert: cslib user api layer: common library error: The 
conversion/operation was stopped due to a syntax error in the source field

The total number of errors in this BCP operation is greater than the 
maximum number of errors (10) allowed. BCP has stopped.
CTLIB Message:  - L5/O3/S5/N6/5/0:
ct_cancel(): network packet layer: internal net library error: 
Net-Library operation terminated due to disconnect
bcp copy in failed

Stejne tak zkrachuje (s jinou chybou) naliti pres nativni format:

C:\Users\55720\Documents\HP\Skripty\BCP>bcp hpcent..hp_fakturace in 
st_fakturace_out -Shybrid-test -Usa -Pxxx -n -J cp1250

Starting copy...
CSLIB Message:  - L0/O0/S0/N20/1/0:
cs_convert: cslib user api layer: common library error: The 
conversion/operation resulted in overflow.
CSLIB Message:  - L0/O0/S0/N20/1/0:
cs_convert: cslib user api layer: common library error: The 
conversion/operation resulted in overflow.
Text/image field is larger than the maximum value. Data truncated.
Unexpected EOF encountered in BCP data-file.
bcp copy in failed


Mohli byste mi poradit v cem je problem? Zkousel jsem i zvetsit velikost 
poli typu text prikazem -T ale chova se to vicemene stale stejne.

Dekuji.

-- 
Radek Vicek
vedoucí oddělení
odd. provozní programátoři
--
vicek.radek na cpost.cz
Tel: +420 387 010 307
--
Česká pošta s.p.
Postservis
Nemanická 2208/16
370 20 České Budějovice
--


------------- další část ---------------
An embedded and charset-unspecified text was scrubbed...
Name: dotaz.txt
URL: <http://list.hw.cz/pipermail/hw-list/attachments/20101203/1fde5ea4/attachment.txt>


Další informace o konferenci Hw-list