My Oracle Support Banner

'ORA-01440: Column to be Modified must be Empty to Decrease Precision or Scale' Error on OFSAA Model Upload / Import (Doc ID 2143149.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, when you run the model upload / import model, the process fails and the following error exists in the log in /<ftpshare>/<infodom>/logs:

----------------------------------------------
STARTED ALTERING THE COLUMNS
----------------------------------------------
Altering the Columns for the table custom_table1.sql
custom_table1.sql---------Error while executing Update :Failed Executing Query. Reason: ORA-01440: column to be modified must be empty to decrease precision or scale
Inside the Rollback Segment
Number of Exec Statements = 23


As a result of the error, the model upload process fails to update the Oracle Database with the data model changes.

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


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