000034285 - When running PL/SQL block in RSA Identity Governance and Lifecycle, the following error occurs:  ORA-01471: cannot create a synonym with same name as object

Document created by RSA Customer Support Employee on Nov 2, 2016Last modified by RSA Customer Support on Jan 22, 2018
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034285
Applies ToRSA Product Set: RSA Identity Governance and Lifecyle
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.0 and 7.0.1
Platform: WebSphere
Platform (Other): AIX
IssueWhen 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 / 

ERROR at line 1: 
ORA-01471: cannot create a synonym with same name as object 
ORA-06512: at line 7
CauseThe intention of the PL/SQL block in step 6 is to create synonyms in the AVDWUSER schema for each migration report. However, the error occurs because you are logged in as AVUSER. The AVUSER schema already has views defined with the same names as the synonym names so the code fails with the ORA-01471 error. 
ResolutionThe 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.