Application fails to start with 'ORA-01439: column to be modified must be empty to change datatype' after applying 7.0.2 P03 to RSA Identity Governance and Lifecycle
Originally Published: 2017-11-13
Last Modified: 2023-11-30
Article Number
000041574
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.2 P03
 
Issue
After applying 7.0.2 P03, the application restart fails with the following error in the patch.log and RSA Identity Governance and Lifecycle will not start.

User-added image
Cause
Column definitions cannot be altered if they contain data. In this case, one or more of the columns in T_RAW_USER_DELETED that is being modified from datatype NUMBER to datatype VARCHAR2 contains data.
Resolution
This is fixed in 7.0.2 P04.
Workaround
Run the attached script file, ACM-81060.sql, and restart the application. 

$ sqlplus avuser/<password>
SQL> @ACM-81060.sql
SQL> exit
$ acm restart
Attachments
If the attachment does not open when clicked, please refresh the page and try again. You must be logged into view the file(s).

    Related Articles

    Trending Articles

    Don't see what you're looking for?