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
RSA Via Lifecycle and Governance Fulfillment Workflows "Create a job per group, grouping by user" creates a single job for… 15Number of Views RSA Identity Governance and Lifecycle 7.5 Administrator's Guide 45Number of Views RSA Governance & Lifecycle 7.5.2 Administrator's Guide 212Number of Views RSA Identity Governance and Lifecycle 7.1 Administrator's Guide 66Number of Views RSA Governance & Lifecycle 8.0.0 Administrators Guide 685Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) Connection fails to Cloud Authentication Service when connecting through a proxy server from RSA Authentication Manager to… Downloading RSA Authentication Manager license files or RSA Software token seed records RSA Release Notes for RSA Authentication Manager 8.8 RSA Release Notes: Cloud Access Service and RSA Authenticators