549 views

Resolving ODBC disk cache error due to maximum field length

 

Problem
The ODBC Driver returns a disk cache error when the amount of data for a field is greater than the maximum field length.

 

Symptoms
The following error message appears:

OLE DB provider "MSDASQL" for linked server "SERVICENOW" returned message "[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Disk cache error. Field length:89280 exceeds maximum limit of 65535.[10232]".
Cause
The max_length dictionary attribute for a field in the query is smaller than the amount of data in that field.

 


Resolution
Increase the value of the max_length dictionary attribute for the field to 16384 or greater.

Article Information

Last Updated:2016-09-08 14:51:56
Published:2016-09-08