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 OCTOBER 02, 2017

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!


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