Answer

When upgrading to 19.4.x or later from an earlier version, users with an Oracle database must follow the steps below. If users do not follow these instructions, the database migration may fail with the following error message: ORA-54032: column to be renamed is used in a virtual column expression.

Instructions:

1. Determine if you have a hidden column with the following query:

SELECT COLUMN_NAME, DATA_DEFAULT, HIDDEN_COLUMN
FROM DBA_TAB_COLS
WHERE TABLE_NAME = 'ARTIFACT_EVENT';

• If you see an entry where HIDDEN_COLUMN has a YES, a hidden column exists that may impact your upgrade process.     

2. Next, remove extended statistics to remove the hidden column. 

EXEC DBMS_STATS.DROP_EXTENDED_STATS('<database username>', 'ARTIFACT_EVENT', '(ARTIFACT_HANDLE, INTEGRATION_ID)');

Note: You will need to write your database username in the text labeled <database username>. 

• The third parameter above ARTIFACT_HANDLE, INTEGRATION_ID can be found in the SYS_OP_COMBINED_HASH() from the query in step 1. 

3. To ensure the hidden column has been removed, re-run the query from step 1.