2200500 - BCP encountered errors after ASE 15.7 upgrade.

• Using bcp to bulk copy a large volume of rows, in the millions, on ASE 15.7 SP122 configured for SSL (openssl) and error occurred before copy completes:

280000 rows successfully bulk-copied to host-file.
CTLIB Message: - L4/O1/S5/N28/5/0:
ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.
281000 rows successfully bulk-copied to host-file.
bcp copy out partially failed

281000 rows copied.

• Also, error can occur in client application, such as isql, and selecting large volume will terminate in error, displaying garbled data:

select * from bigauth:

172-32-1176 409-56-7008 893-72-1158 899-46-2035 527-72-3246
White
Bennet Heath17
-32-1176 409-56-7008 893-72-1158 893-72-1158 712-4
-1867 White BennetHeatheMcBadden del Castillo 172
CT-LIBRARY error:
ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.

 

Read more...

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 15.7 
• SAP Adaptive Seerver Enterprise SDK 15.7 

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

ssl, open ssl , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-SDK , SDK , Problem