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
Originally Published: 2017-09-22
Last Modified: 2023-11-30
Article Number
Applies To
RSA Version/Condition: 7.0.0+
Issue
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
Resolution
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
'ORA-28000: the account is locked' error when migrating an imported database in RSA Identity Governance & Lifecycle 194Number of Views Okta Agent - RSA Ready Implementation Guide 9Number of Views Unification fails at Step 7/11 with 'ORA-54017: UPDATE operation disallowed on virtual columns' in RSA Identity Governance… 91Number of Views FileCloud-SecurID-Access-SAML-Integration 11Number of Views Access Fulfillment Express (AFX) Connector import fails to import enabled capabilities if no mappings are defined in RSA I… 38Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process
Don't see what you're looking for?