SAP Knowledge Base Article - Preview

2078754 - Error Creating A Virtual Table When The Column Size Field Is MAX

Symptom

When creating a virtual table where the remote source is MS SQL Server 2008 to SQL Server 2016 with the the following data types:

  • nvarchar(MAX)
  • varchar(MAX)
  • varbinary(max)

The following errors occur:

SAP DBTech JDBC: [338]: zero-length columns are not allowed: LONGTEXT: line 1 col 209 (at pos 208)

or

ERROR: zero-length columns are not allowed


Read more...

Environment

  • SAP HANA SP 7/8/9/10/12
  • SQL Server 2008
  • SQL Server 2016

Product

SAP HANA 1.0, platform edition

Keywords

SDA, In-memory, SQL Server, smart data access , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , 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.