MigrationExporter.log file has below errors:
(SqlplusUtil.java:183), trace.com.rsa.tools.common.SqlplusUtil, ERROR, ALBVP1RSAAUT001.ppsystems.ppservices.mdc,,,,com.rsa.ims.oracle.OracleException: ORA-01920: user name 'RSA_MIGRATION_ADMIN' conflicts with another user or role
at com.rsa.ims.oracle.OracleProcessOutputLineFilter.processLine(OracleProcessOutputLineFilter.java:120)
at com.rsa.ims.common.process.HandleProcessOutput.run(HandleProcessOutput.java:65)
at com.rsa.ims.common.process.ProcessUtil.executeCommand(ProcessUtil.java:156)
at com.rsa.ims.common.process.ProcessUtil.executeCommand(ProcessUtil.java:185)
at com.rsa.tools.common.SqlplusUtil.executeSQLFile(SqlplusUtil.java:262)
at com.rsa.tools.common.SqlplusUtil.executeSQLFile(SqlplusUtil.java:225)
at com.rsa.tools.common.SqlplusUtil.execute(SqlplusUtil.java:305)
at com.rsa.ims.migration.admin.dal.impl.MigrationAccessSql.createRSAMigrationAdmin(MigrationAccessSql.java:680)
at com.rsa.ims.migration.admin.dal.impl.MigrationAccessSql.createRSAMigrationAdminOnPrimaryOnly(MigrationAccessSql.java:380)
at com.rsa.ims.migration.admin.impl.IMSMigrationMgtImpl.createMigrationUserOnPrimaryOnly(IMSMigrationMgtImpl.java:830)
at com.rsa.ims.migration.service.impl.MigrationServiceImpl.createMigrationUserOnPrimaryOnly(MigrationServiceImpl.java:375)
at com.rsa.ims.internal.migration.engine.tasks.premigrate.impl.CreateMigrationUserOnPrimaryOnlyPreMigrationTask.performExecuteTask(CreateMigrationUserOnPrimaryOnlyPreMigrationTask.java:45)
at com.rsa.ims.internal.migration.engine.tasks.impl.AbstractTask.executeTask(AbstractTask.java:142)
at com.rsa.ims.internal.migration.engine.impl.MigrationEngineImpl.premigrate(MigrationEngineImpl.java:207)
at com.rsa.ims.migration.command.ExportMigrationPackageCommand.execute(ExportMigrationPackageCommand.java:116)
at com.rsa.exporter.izpack.util.RunExportTool.runTool(RunExportTool.java:35)
at com.rsa.exporter.izpack.util.RunActionTool.run(RunActionTool.java:42)
at java.lang.Thread.run(Thread.java:662)
Connect to SQL interface in RSA Authentication Manager 7.1
1. Obtain the password for sysdba account.
cd utils
rsautil manage-secrets -a get com.rsa.db.root.password
Enter master password:
You will get the password for sysdba account. (DO NOT SEND ME THE OUTPUT)
2. Command to connect:
a. On Appliance and UNIX servers only:
cd utils
. ./rsaenv ( Notice the two dots. This will set the environment)
b. sqlplus sys/<value from step1> as sysdba
SQL> select * from sys.all_users;
USERNAME USER_ID CREATED
------------------------------ ---------- ---------
RSA_MIGRATION_ADMIN 66 22-APR-14
RSA_BATCHREP 65 23-APR-12
RSA_STREAMS_ADMIN 64 23-APR-12
RSA_LOG_ARCHIVER 63 23-APR-12
RSA_LOGREP 61 23-APR-12
RSA_REP 60 23-APR-12
RSA_USER_9W8WE6AG 59 23-APR-12
RSA_DBA_OGSPT4XX 58 23-APR-12
SCOTT 57 20-JUL-10
MGMT_VIEW 56 20-JUL-10
MDDATA 53 20-JUL-10
Connect to SQL. sqlplus sys/<pwd> as sysdba
drop user RSA_MIGRATION_ADMIN CASCADE;
Related Articles
How to enable AveksaAdmin account if it has been disabled from the UI by another user with admin privileges in RSA Governa… 53Number of Views Adding trusted realm in RSA Authentication Manager 8.1 SP1 fails with an error: "The trust is not unique. Either the trust… 86Number of Views Migrating users from one identity source to another in Authentication Manager 35Number of Views RSA Authentication Manager 8.7 SP1 upgrade fails due to GRUB issue 152Number of Views The T_AV_ROLE_METRICS table is very large in RSA Identity Governance & Lifecycle 30Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Authenticator 6.2.2 for Windows Administrator Guide RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide How to Update the Root (Server) and Client Certificates in RSA Identity Governance & Lifecycle RSA SecurID software token .sdtid file fails to import into RSA SecurID Software Token 5.0 for Windows