Issue with Oracle Synonym - Qlik Community

l_palacios · ‎2015-09-24

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?

Anonymous · ‎2015-09-28

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

SreeniJD · ‎2015-09-28

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 · ‎2015-10-08

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 · ‎2015-10-08

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