Migration utility fails with an error 'ORA-01920: user name 'RSA_MIGRATION_ADMIN' conflicts with another user'
3 years ago
Originally Published: 2014-05-15
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