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