RSA Identity Governance and Lifecycle - 702 Migration fails with 'ORA-02260: table can have only one primary key'
Originally Published: 2017-11-14
Article Number
Applies To
RSA Version/Condition: 7.0.2
Issue
SQL/line#: /home/oracle/wildfly/domain/servers/server-one/tmp/vfs/deployment/deploymentd323c87af1301dbd/aveksa.war-6c4b34db36bf38a4/WEB-INF/database/Create Scripts/Create_Constraints_Interim.sql(292):
Start time [Sat Nov 04 10:17:27 CDT 2017]
BEGIN
IF (Migration_Utils_Pkg.ConstraintDoesNotExist('T_AV_ACCOUNTS', 'PK_T_MASTER_ACCOUNT_ID')) THEN
EXECUTE IMMEDIATE 'ALTER TABLE T_AV_ACCOUNTS
ADD CONSTRAINT PK_T_MASTER_ACCOUNT_ID
PRIMARY KEY (ID) USING INDEX
TABLESPACE INDX_1M LOGGING ENABLE';
END IF;
END;
java.sql.SQLSyntaxErrorException: ORA-02260: table can have only one primary key
ORA-06512: at line 3
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
Cause
Resolution
1. As 'avuser' run this SQL:
ALTER TABLE t_av_accounts DROP CONSTRAINT old_t_master_account_id; ALTER TABLE t_av_accounts DROP CONSTRAINT old_t_acc_adc_id_t_dc_dcid; ALTER TABLE t_av_accounts DROP CONSTRAINT old_t_acc_app_id_t_apps_id;
2. Enter the migration password in the Initialization Status screen to restart the migration.
Related Articles
Cloud Administration Authenticator Details API Version 2 Number of Views RSA Identity Governance and Lifecycle - Can you map an account to a specific user through Web Services Number of Views RSA Via Lifecycle and Governance Aveksa Data Collector (ADC) becomes stuck for hours on "Inserting account mappings into s… Number of Views Migration from 7.0.1 to 7.0.2 fails with error PLS-00323: subprogram or cursor 'PROCESS_ACTIVE_USER_ACC_MAPS' is declared … Number of Views How to view workflow variable values during workflow execution in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
