My Oracle Support Banner

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 MARCH 20, 2019

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.