573 views

Description

When querying a table that has a string field whose value exceeds 65535 kb, the following error occurs:

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Disk cache error. Field length:93238 exceeds maximum limit of 65535

This is only reproducible when querying many rows (not just several) from a table with a string field that has a large value. The issue is due to use of the internal cache mechanism.

Steps to Reproduce

  1. Create a table
  2. Add a new field:
  3. Prepare content larger than 65535 kb.
  4. Create a new record.
  5. Paste the content from step 3 into a value of the field.
  6. Create at least 200 copies of the record.
    If needed, create more records.
  7. Open iSQL console.
  8. Issue the following query:

    select * from my_table;

    Instead of all records being returned, an error message is displayed:

    [SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Disk cache error. Field length:93238 exceeds maximum limit of 65535 is displayed

Workaround

Do one of the following:


Related Problem: PRB711960

Seen In

Helsinki Patch 3

Fixed In

Istanbul
Jakarta

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-04-18 06:37:04
Published:2016-09-12