Schema Update Fails With Error "Arithmetic overflow error converting float to data type numeric" (Doc ID 1330476.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Data Quality Management - Version 11.1.2.0.00 and later
Information in this document applies to any platform.

Symptoms


schema update fails on an application upgraded from 9.3.3 to 11.1.2.1.
The schema upgrade utility fails on tdataseg5 table at the 11.1.2 schema upgrade stage with error

ERROR:
Code............................................. -2147217833
Description...................................... Arithmetic overflow error converting float to data type numeric.
IF OBJECT_ID(N'DF_tDataSeg5_Amount') IS NOT NULL
Begin
ALTER TABLE TDATASEG5 DROP CONSTRAINT DF_tDataSeg5_Amount
End
ALTER TABLE TDATASEG5 ALTER COLUMN Amount Decimal(29, 12) NOT NULL
IF OBJECT_ID(N'DF_tDataSeg5_Amount') IS NULL
Begin
ALTER TABLE TDATASEG5 ADD CONSTRAINT DF_tDataSeg5_Amount DEFAULT (0) FOR Amount
End
Procedure........................................ clsDataManipulation.fExecuteDML
Component........................................ upsWDataWindowDM
Version.......................................... 1112
Thread........................................... 2380

This indicates that the schema upgrade tries to alter a column from float to decimal. When trying to manually execute this sql within SQL, the same error occurs

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