'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:

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

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