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
ASR fails to generate with an 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' error in RSA … 127Number of Views ASR Report fails with ERROR ORA-06502: PL/SQL: numeric or value error: character string buffer too small in RSA Identity G… 22Number of Views RSA Identity Governance and Lifecycle Identity Data Unification fails with ORA-06502: PL/SQL: numeric or value error: Bulk… 178Number of Views After applying a patch, an 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' error occurs whe… 163Number of Views ASR fails to generate and the log file has 'ORA-04063: package body "AVUSER.SRSECTION_SYSTEM" has errors' errors in RSA Id… 210Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators