Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
l_palacios
Contributor III
Contributor III
‎2015-09-24 01:50 PM

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?

1,156 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2015-09-28 05:41 AM

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

835 Views
0 Likes
SreeniJD
Specialist
Specialist
‎2015-09-28 05:48 AM

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

835 Views
l_palacios
Contributor III
Contributor III
‎2015-10-08 12:48 PM
Author

In response to SreeniJD

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.

835 Views
0 Likes
SreeniJD
Specialist
Specialist
‎2015-10-08 11:51 PM

In response to l_palacios

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

835 Views
0 Likes