Migration utility fails with an error 'ORA-01920: user name 'RSA_MIGRATION_ADMIN' conflicts with another user'
Originally Published: 2014-05-15
Last Modified: 2023-09-22
Article Number
000049381
Applies To
RSA Authentication Manager 7.1
Issue
Migration utility fails with an error "ORA-01920: user name 'RSA_MIGRATION_ADMIN' conflicts with another user"
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)
Cause
Database has corrrupt block

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


Resolution

Connect to SQL. sqlplus sys/<pwd> as sysdba

drop user RSA_MIGRATION_ADMIN CASCADE;


Workaround
Administrator is running migration utility on AM 7.1 server to create the database dump. Administrator is planning to migrate the database to AM 8.1

Related Articles

Trending Articles

Don't see what you're looking for?