'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 JUNE 02, 2016

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

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