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… 58Number of Views Cannot login with AveksaAdmin password after importing a database from another environment into RSA Identity Governance an… 215Number of Views Application is in a questionable state and collections may get stuck after an unexpected database failure in RSA Identity … 41Number of Views Unable to log into Microsoft apps on Android devices when Microsoft Office 365 is configured with the RSA SecurID Access A… 51Number of Views Entitlements manually added when an Application has 'Complete Manual Activity Before Collection' enabled do not show in th… 217Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device Manual synchronization introduced in RSA Authentication Manager 8.2 Service Pack 1 patch 6 Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory How to verify NTP server synchronization is not working in RSA Authentication Manager 8.x RSA Governance & Lifecycle 8.0.0 Installation Guide