ORA-01451: column to be modified to NULL cannot be modified to NULL error while migrating database from Version 7.0 and above to Version 7.0.2 in RSA Identity Governance and Lifecycle
3 years ago
Originally Published: 2017-09-22
Article Number
000041544
Applies To
RSA Product Set: Identity Governance and Lifecycle (IGL)
RSA Version/Condition: 7.0.0+
 
Issue
You can see the below error in the UI while migrating the database from Version 7.0.0+ to Version 7.0.2.
  
Schema Migration is required.
   Database version is 7.0.0.93958. Server version is 7.0.2.126845.
 
Found invalid object(s) in the database. Please check the log for error(s).
 
ORA-01451: column to be modified to NULL cannot be modified to NULL
ORA-06512: at line 3
 
Schema Migration completed in 0h 0m 18s with errors.
 
/home/oracle/wildfly/standalone/tmp/vfs/temp/tempa6e920c7ec98c7a8/content-f5b8d8d3449a3381/contents/aveksa.war/WEB-INF/database/updates/7.0/ACM-55209.sql(1):
BEGIN
 – Hack - Disable null checks for now
 execute immediate 'ALTER TABLE WP_JOB_MONITOR MODIFY (PROCI_ID NUMBER(38,0) NULL)';
 execute immediate 'ALTER TABLE WP_JOB_MONITOR MODIFY (PROCI_DB NVARCHAR2(4) NULL)';
END;
java.sql.SQLException: ORA-01451: column to be modified to NULL cannot be modified to NULL
ORA-06512: at line 3

 
Cause
When we try to execute an Alter table modify query attempting to change a column to accept NULL values, but the column either already allows NULL values or the column is used in a constraint and cannot accept NULL values.
Resolution
We need to replace the ACM-55209.sql with the right sql file and followed by running the migrate.sh from the /home/oracle/database directory to continue with the migration. 
Please contact RSA support to avail the ACM-55209.sql file. 
 
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?