2368290 - BCP utility failing with multiple errors | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2368290 - BCP utility failing with multiple errors

Symptom

When using bcp utility the precision on money columns is being lost and getting multiple errors when trying to bcp in:

[D1pSyDB.vitas.com:sybase]/sybdata/bcp $/opt/sybase/OCS-16_0/bin/bcp64 DBAwork..billsum in billsum.bcp -f bcp.fmt  -b1000 -Ulclark -SD1PSYDB -Yiso_1

Starting copy...
Batch successfully bulk-copied to the server.
1000 rows sent to the server.
Batch successfully bulk-copied to the server.
2000 rows sent to the server.
Batch successfully bulk-copied to the server.
3000 rows sent to the server.
Server Message: XXXXX - Msg 5702, Level 10, State 1:
ASE is terminating this process.

CTLIB Message:  - L5/O3/S5/N7/5/0:
ct_send(): network packet layer: internal net library error: Net-Lib protocol driver call to write data failed
CTLIB Message:  - L1/O1/S1/N50/1/0:
ct_send_data(): user api layer: external error: The connection has been marked dead.
bcp copy in partially failed

3000 rows copied.

ASE errorlog reports a stacktrace with the following functions:

kernel Current process (0x15700ac) infected with signal 11 (SIGSEGV)
kernel Address 0x0x0000000000a3c715 (bt__check_insert_position+0x6f), siginfo (code, address) = (1, 0x0x0000000600000000)

kernel  curcmd = 325 program = bcp
kernel  pc: 0x00000000012deabc pcstkwalk+0x46e()
kernel  pc: 0x00000000012de48f ucstkgentrace+0x20f()
kernel  pc: 0x00000000012db382 ucbacktrace+0x54()
kernel  pc: 0x00000000015872dc terminate_process+0xf4c()
kernel  pc: 0x0000000001310144 kisignal+0x31b()
kernel  pc: 0x0000000000a3c715 bt__check_insert_position+0x6f()
kernel  pc: 0x000000000189816d bt__traverseandinsert+0x24d()
kernel  pc: 0x00000000018922d3 bt_insert+0x203()
kernel  pc: 0x0000000001035250 bulk_fast_idxupdate+0x4f7()
kernel  [Handler pc: 0x0x0000000001d2efd0 ut_handle installed by the following function:-]
kernel  pc: 0x000000000102cbdc bulk_fast_row+0x5d7()
kernel  pc: 0x00000000008ef038 LeBulkOp::_LeOpOpenHelper(le_bulk_ex volatile*, ExeCtxt&)+0x9e0()
kernel  [Handler pc: 0x0x0000000001d2efd0 ut_handle installed by the following function:-]
kernel  [Handler pc: 0x0x0000000001d2efd0 ut_handle installed by the following function:-]
kernel  pc: 0x00000000008d2a52 LeBulkOpOpen+0x1d3()
kernel  pc: 0x00000000015cab23 LeEmittOp::_LeOpOpen(ExeCtxt&)+0x43()
kernel  pc: 0x00000000015b926b LePlanOpen+0xbb()


Read more...

Environment

Adaptive Server Enterprise 16.0 SP02 PL02 EBF 25320 SMP

BCP 16.0 SP02 PL02

Product

SAP Adaptive Server Enterprise 16.0

Keywords

BCP , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.