157 views

Description

When using the 1.0.9 ODBC driver to report on a decimal field that is 10 digits (such as 1,000,000,000), the query fails with the following error:

OLE DB provider "MSDASQL" for linked server "ServiceNowTRAIN" returned message "[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Invalid value passed for column:disk_space.[10372]."

Fails: 1,000,000,000
Works: 100,000,000

Steps to Reproduce

 

  1. Open any cmdb_ci_server record.
  2. Set the the disk_space field to 1,000,000,000.
  3. Connect to the instance via ISQL using the 1.0.9 ODBC driver.
  4. Run the following query:
    select disk_space from cmdb_ci_server;
    The query fails.
  5. Repeat steps 1 and 2, but set the field value to 100,000,000.
  6. Run the query in step 4 again.
    The data returns correctly.

Workaround

  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 more than 40 (for example, 41).
  4. Click Update.

Related Problem: PRB663485

Seen In

Eureka Patch 12

Fixed In

Helsinki

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-07-07 07:45:10
Published:2016-02-23