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