With MS SQL Server Analytics DB, ODI Job Data Fail With Error Arithmetic Overflow Error Converting Numeric to Data Type Varchar (Doc ID 2077730.1)

Last updated on NOVEMBER 13, 2015

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.

Symptoms

On : 8.6.0.1 version, ODI 11.1.1.9, MS SQL DB, Analytics Reporting and ETL

With MS SQL Server Analytics DB, ODI Job Data Fail With Error Arithmetic Overflow Error Converting Numeric to Data Type Varchar

Error occurred in ODI as
Arithmetic overflow error converting numeric to data type varchar.

Note - This issue happens only on MS SQL DB only. Oracle DB able to handle this data without any issue.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms