Home » Developer & Programmer » Forms » Getting ORA-01775: looping chain of synonyms error (Forms 6i, Windows)
Getting ORA-01775: looping chain of synonyms error [message #328852] Mon, 23 June 2008 01:46 Go to next message
rjayakumar
Messages: 3
Registered: June 2008
Junior Member
Hi,

I have Oracle forms 6i in windows. The database is oracle 10gR2. when i am trying to run the forms, i am getting the error: ORA-01775: looping chain of synonyms error.

I checked in the database for any self-refering synonyms or in loop as was explained for the error desc. But, there are no such synonyms, they are refering to the tables only.

Can anyone guide me in finding the cause and solution for this.

Thanks in advance.

Regards,
Jayakumar R
Re: Getting ORA-01775: looping chain of synonyms error [message #328858 is a reply to message #328852] Mon, 23 June 2008 02:08 Go to previous messageGo to next message
cjack
Messages: 22
Registered: June 2008
Junior Member
Hi
If the synonyms scenario like this

a= sys.b
b= sys.c
c= sys.a

You can check from all_synonyms this system view.
Re: Getting ORA-01775: looping chain of synonyms error [message #328903 is a reply to message #328858] Mon, 23 June 2008 05:09 Go to previous messageGo to next message
rjayakumar
Messages: 3
Registered: June 2008
Junior Member
I have checked in all_synonyms, there is no such synonym one refering to another like this.
Re: Getting ORA-01775: looping chain of synonyms error [message #328906 is a reply to message #328858] Mon, 23 June 2008 05:17 Go to previous messageGo to next message
rjayakumar
Messages: 3
Registered: June 2008
Junior Member
Hi,

Can someone tell what will exactly happen as soon as the database login credentials are entered when opening a Oracle Forms application, before the form's code is executed?

Thanks.
Re: Getting ORA-01775: looping chain of synonyms error [message #337114 is a reply to message #328852] Tue, 29 July 2008 23:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Getting ORA-01775: looping chain of synonyms error [message #354772 is a reply to message #337114] Tue, 21 October 2008 03:26 Go to previous messageGo to next message
dattavg
Messages: 1
Registered: May 2008
Junior Member
hi

i am also geeting ora-01775 :looping chain of synonyms error.
when i am trying to run the form.This is first error which is appearing,before pre-form trigger.
I ahve checked all synonyms and databas objects ,found no problem.
Is any body aware how to debug/resolve this issue
thanks in advance

Regards
Dattatraya G
dattavg@gmail.com
Re: Getting ORA-01775: looping chain of synonyms error [message #354780 is a reply to message #354772] Tue, 21 October 2008 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This error may also comes when a synonym points to a no more existing object.

Regards
Michel
Re: Getting ORA-01775: looping chain of synonyms error [message #399286 is a reply to message #328852] Tue, 21 April 2009 07:35 Go to previous messageGo to next message
robajohnson
Messages: 9
Registered: February 2006
Location: Dallas Texas area
Junior Member

I have the exact same problem. Forms 6i in a new 10gR2 db.

I only have 8 synonyms so it has not been too tough to confirm that they all reference a table or view and not another synonym and I have confirmed with select statements that selecting from any of my synonyms will return rows so everything is valid.

I am sooo stumped! Sad
Re: Getting ORA-01775: looping chain of synonyms error [message #399595 is a reply to message #399286] Thu, 23 April 2009 02:07 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is forms using the same userid as you have used for your testing in SQL*Plus?

david
Previous Topic: Client_get_file_name
Next Topic: Three blocks form execution problem
Goto Forum:
  


Current Time: Thu Dec 08 16:40:29 CST 2016

Total time taken to generate the page: 0.14376 seconds