Problem Note 63395: Accessing Teradata version 16.00 or later might result in "General error Response Row size exceeds 64K bytes...incompatible with the Client software"
 |  |  |  |
When you run code that accesses a Teradata database version 16.00 or later and that generates results in which the row size exceeds 64K, the following error might occur:
This issue can occur in the following scenarios:
- You use the columnInfo action with the CAS procedure.
- You run code that reads a Teradata table, including but not limited to the SQL, DS2, FEDSQL, CASUTIL, and CAS procedures.
This issue occurs because a new feature, which enables support for wide-row tables, was introduced in Teradata 16.00. The previous limit was 64,000 bytes.
Beginning with SAS® 9.4M7 (TS1M7) and SAS® Viya®, the DS2, FEDSQL, and CAS procedures will support this new Teradata feature.
The DATA step, and other procedures, like PROC SQL, including Explicit SQL, can still get the error for wide-row tables. However, refer to SAS Note 68644, "Accessing Teradata 16.00 or later results in 'Row size exceeds 64K bytes...incompatible with the Client software' when you use certain procedures," for an update.
The only workaround is to restrict the number of columns to avoid exceeding the 64K row size.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Teradata | Windows 7 Ultimate x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Windows 7 Professional x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Windows 7 Professional 32 bit | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Windows 7 Home Premium x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Windows 7 Home Premium 32 bit | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Windows 7 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Windows 7 Enterprise 32 bit | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2016 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2012 Std | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M5 | |||||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M5 | |||||
| Microsoft Windows Server 2008 | 9.4 TS1M5 | |||||
| Microsoft Windows 10 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Microsoft® Windows® for x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| 64-bit Enabled AIX | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| 64-bit Enabled Solaris | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| HP-UX IPF | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Linux for x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| Solaris for x64 | 9.4 TS1M5 | 9.4 TS1M7 | ||||
| z/OS | 9.4 TS1M5 | |||||
| SAS System | SAS Data Connector to Teradata | Linux for x64 | V.03.03 | V.03.05 | Viya | Viya |
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-11-30 09:26:37 |
| Date Created: | 2018-12-17 09:43:24 |