Using the ODBC Driver 1.0.9 to query a field that has a maximum length of less than 40 characters causes the query to fail and produces the following error:

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Invalid value passed for column:<column_name>.

Steps to Reproduce

Using the ODBC Driver 1.0.9, query a column that has a maximum length of fewer than 40 characters.


  1. Navigate to System Definition > Dictionary.
  2. Select the dictionary entry for the column causing the error.
  3. Change the Max length field value to 40 or more.
  4. Click Update.

Related Problem: PRB629200

Seen In

Dublin Patch 8
Fuji Patch 3
Fuji Patch 7 Hot Fix 5

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-02-24 08:07:35