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

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

Article Content

Article Number000035574
Applies ToRSA Product Set: Identity Governance and Lifecycle (IGL)
RSA Version/Condition: 7.0.0+
 
IssueYou 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

 
CauseWhen 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.
ResolutionWe 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

    Outcomes