SAP Knowledge Base Article - Preview

3530192 - Text fields without a max length in Odata are imported with max length of 100 by CPI-DS - SAP Cloud Platform Integration for data services

Symptom

  • Text fields without a max length in Odata are imported with max length of 100 by CPI-DS
  • String fields in OData with no max length are imported as VARCHAR(100)
  • ODBC data source <data source name> error message for operation <SQLExecute>: <[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated.
  • "String or binary data would be truncated" error occurs for ODBC data source, regardless of what field length is set in transform(s) of dataflow.


Read more...

Environment

  • SAP Cloud Platform Integration for Data Services
  • Odata Adapter Datastore

Product

SAP Cloud Integration for data services all versions

Keywords

Odata, C4C, Adapter, Adaptor, text, STRING, field, no max, max, undefined, unlimited, length, default, 100, string, binary, date, truncated , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem

About this page

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

Search for additional results

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