2703 views

ODBC Error Messages: Determining if you need to increase file size limit

  

Symptoms
  • disk cache file size limit reached
  • query resulted in data sizes that exceed the maximum 

Cause
If you receive an error message indicating that the Disk Cache file size limit has been reached, this is likely caused by performing operations on a large number of columns.
Resolution

If you receive the following error message when running a query, [ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Disk Cache file size limit has reached., the disk cache file size limit has been reached. If it is necessary for you to complete the query or operations without reducing the file size, increase the file size limit of the property.

Using the Management Console application, navigate to Services > ServiceNow_ODBC > Service Settings > SQL Engine Parameters and increase the ServiceSQLDiskCacheMaxSize property.

Article Information

Last Updated:2015-05-02 09:55:52
Published:2014-06-12