Awinstall Errors with ORA-01775: looping chain of synonyms
Article ID: 84789
Updated On:
Products
CA Automic Applications Manager (AM)
Issue/Introduction
Error Message :
ORA-01775: looping chain of synonyms
When running awinstall with option one the above error message is displayed in the $AW_HOME/install/awinstall.log.
Â
ORA-01775: looping chain of synonyms
When running awinstall with option one the above error message is displayed in the $AW_HOME/install/awinstall.log.
Â
Cause
Cause type:
Other
Root Cause: This is an Oracle database error generated by the database. Oracle defines the error message as followed….
ORA-01775: looping chain of synonyms
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:
CREATE SYNONYM s1 for s2 CREATE SYNONYM s2 for s3 CREATE SYNONYM s3 for s1
Action: Change one synonym definition so that it applies to a base table or view and retry the operation.
Other
Root Cause: This is an Oracle database error generated by the database. Oracle defines the error message as followed….
ORA-01775: looping chain of synonyms
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself. For example, the following definitions are circular:
CREATE SYNONYM s1 for s2 CREATE SYNONYM s2 for s3 CREATE SYNONYM s3 for s1
Action: Change one synonym definition so that it applies to a base table or view and retry the operation.
Environment
Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:
Component:
Resolution
Contact your database administrator to resolve the error on the Oracle database.
Fix Status: No Fix
Fix Status: No Fix
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
