000035731 - 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

Document created by RSA Customer Support Employee on Dec 1, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035731
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.2 P03
IssueAfter 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
CauseColumn 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.
ResolutionThis is fixed in 7.0.2 P04.
WorkaroundRun the attached script file, ACM-81060.sql, and restart the application. 
$ sqlplus avuser/<password>
SQL> @ACM-81060.sql
SQL> exit
$ acm restart