Issue: Data Exchange fails with error "ERROR [22003] [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the varchar value '<LARGE NUMBER VALUE>' overflowed an int column."

Date Documented: 9 Oct 2018


Symptoms / Error

  • Data Exchange fails and pushes document to manual indexing.

  • Dataexchangeseervice.log displays the entry "ERROR [22003] [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the varchar value '<LARGE NUMBER VALUE>' overflowed an int column."

Cause

  • This is due to Data Exchange pulling a large number value, normally a check number, and attempting to put this value into a numeric field within a Docuphase index. 

Fix

  • Method 1: Change the check number within Petroware as to be a valid number value.

  • Method 2: Create a text field index within Docuphase. Copy data from the number field to the text field. Cleanup the remaining now unused number field. 

Summary

  • This only appears to be an issue within Rev applications but it's possible for it be lurking someplace else as well.