Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
l_palacios
Contributor III
Contributor III

Issue with Oracle Synonym

Has anyone come across error with synonym on oracle tables? seems to time out as it thinks the table is either not there but when I run the same script in oracle or toad using the same user id and password credentials, it runs with no problem. Can anyone help with this?

4 Replies
Anonymous
Not applicable

Does a simple select * from tablename from QV against a simple small Oracle table work ok ?

SreeniJD
Specialist
Specialist

To avoid this problem, have 3 tier architecture.. store all relevant source tables into QVDs and then use transformations, this will not have that oracle "synonym" issue.

HTH

Sreeni

l_palacios
Contributor III
Contributor III
Author

Hi Sreeni,

thank you for your help. I tried restructuring the architecture of the table and that seems to have helped. I also, streamlined the amount of data I am pulling in. that is working also. thank you for your help.

SreeniJD
Specialist
Specialist

Glad that it has worked! Please close the thread by marking correct or helpful