2298296 - ADO.NET Provider Error “String data, right truncated" - SAP SDK | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2298296 - ADO.NET Provider Error “String data, right truncated" - SAP SDK

Symptom

  • ADO.Net Data Provider truncates big strings into 16384 characters (16K) when inserting big strings into an ASE table column of a text data type.
  • The issue may happen silently.
  • The issue can result in an error String data, right truncatedin ADO.Netclient applications.
  • The following pattern can be seen in the RIBO tracing (example using “*” in big string sequence):

PDU Header
 
  TDS Packet Type [1]:          BUF_NORMAL (0x0F)

  Status [1]:                   BUFSTAT_EOM (0x01)
  Length [2]:                   176
  Channel [2]:                  0
  Packet No. [1]:               0
  Window [1]:                   0
 
PARAMS Token (0xD7); variable length.
 
  Param 1

    Length [4]:                 16384
    Param data [16384]:  “*** (...) ***” 

  • Using “set textsize” or “TextSize” in the connection string to expand the string size does not work. 

Read more...

Environment

  • SAP Adaptive Server Enterprise (SAP) 16.0 SP02 PL02
  • SAP Adaptive Server Enterprise (SAP) 15.7
  • Adaptive Server Enterprise ADO.Net Data Provider 16.0.02.02
  • Adaptive Server Enterprise ADO.Net Data Provider 15.7 SP133
  • Adaptive Server Enterprise ADO.Net Data Provider 15.7 SP136

Product

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

Keywords

AseConnection, connstring, adonet, driver, CR796948. CR#796948. 796948, ado,net, text, string truncation , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.