Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajveer
Contributor II
Contributor II

Not able to resolve this error

I'm getting below error while reloading the script,
Please suggest me how I can resolve it

Connector reply error: ErrorSource: OraOLEDB, ErrorMsg: ORA-01775: looping chain of synonyms

 

 

 

Labels (1)
3 Replies
Anil_Babu_Samineni

@Rajveer This sounds like you have Synonym from this table with another table? Not sure if this is with loop issue or simple SQL statement? 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vinieme12
Champion III
Champion III

This error is returned from the DB ; Qlik is simply returning the error message received from the DB

https://www.xtivia.com/blog/oracle-looping-chain-synonyms-ora-01775/

https://stackoverflow.com/questions/247090/how-to-debug-ora-01775-looping-chain-of-synonyms

I suggest you refer articles from other forums to resolve this.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Rajveer
Contributor II
Contributor II
Author

Actually, I'm getting this error while reloading the QlikView script.
Need to check from DB side ....?