ConnectALL 3.9.1 upgrade failed with error "ORA-01440: column to be modified must be empty to decrease precision or scale"

Products

• ConnectAll On-Prem
• ConnectALL

Issue/Introduction

Upgraded ConnectALL from v3.7.0.2-9 to v3.9.1, and it seems that the upgrade was successful, but there were some errors.

ERROR: Exception Details

ERROR: Exception Primary Class:  OracleDatabaseException

ERROR: Exception Primary Reason:  ORA-01440: column to be modified must be empty to decrease precision or scale

ERROR: Exception Primary Source:  Oracle Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Environment

3.9

Cause

DE177672

Resolution

Investigation in Progress.

Workaround-

Rerun the upgrade after deleting records from metadata_cache table.

delete from metadata_cache;