RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.0 and 7.0.1
Platform: WebSphere
Platform (Other): AIX
When upgrading to RSA Identity Governance and Lifecycle 7.0.1 and in the process of installing the Migration Reports, the WebSphere implementations with remote databases on AIX require a few additional steps in order to run the Migration Reports. These steps are outlined on page 12 of the RSA Identity Governance and Lifecycle V7.0.1 Upgrade and Migration Guide. When following these steps, step 6 fails with the following error:
SQL> begin
2 FOR rec IN (select 'create or replace synonym ' || TO_CHAR(view_name) || ' for avuser.' || TO_CHAR(view_name) cmd
3 from avuser.T_AV_REPORTS
4 where regexp_like(view_name,'^[vV]_[a-zA-Z0-9_]+$')
5 and LENGTH(view_name) <= 30 AND REPORT_CATEGORY = 'Migration')
6 loop
7 execute immediate rec.cmd;
8 end loop;
9 end;
10 /
begin
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object
ORA-06512: at line 7The solution to this problem is to login as the AVDWUSER instead of the AVUSER when you run step 6. Then when you get to step 6, logout of sqlplus and login again as avdwuser/<password>.
A documentation ticket has been logged (ACM-69154) to update the RSA Identity Governance and Lifecycle V7.0.1 Upgrade and Migration Guide to reflect this necessary step.
Related Articles
RSA Identity Governance & Lifecycle 7.0.0 installation fails with the following error: JBAS014653: Composite operation fa… 227Number of Views On database startup for RSA Identity Governance and Lifecycle the following error is seen: CRS-2501: Resource 'ora.avdb.d… 518Number of Views While running the RSA Authentication Manager 8.x bulk token sync utility the following e rror is seen: FAILED: Concurrent… 337Number of Views RSA Authentication Manager On-Demand Authentication (ODA) failing with the following error: User provided incorrect On-De… 162Number of Views Opening RSA SecurID Software Token 4.1.2.30 for Windows Desktop produces the following message: Error loading the applicat… 469Number of Views
Trending Articles
RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide How to Upgrade Internal SHA-1 Certificates to SHA-256 in Authentication Manager Using rsautil RSA Authentication Manager 8.9 Setup and Configuration Guide How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device