Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

While clickin on rolad ,i am getting following error

Hi,

I  am  able to connect oracleXE from qlick vie 11.Connection was successful  but when clicking on reload i am getting following error.

Can anybody please help  on this issue. I am new to Qlickview

SQL##f - SqlState: S1000, ErrorCode: 12170, ErrorMsg: [Oracle][ODBC][Ora]ORA-12170: TNS:Connect timeout occurred

ODBC CONNECT TO [QlickOracleXEDSN;DBQ=XE] (XUserId is GSJeWZFPTDdKWWBQ, XPassword is DZaQRZFPTDdKWWNJ)

15 Replies
senpradip007
Specialist III
Specialist III

Can you share your script?

Not applicable
Author

con1.png

SreeniJD
Specialist
Specialist

Can you please check on Force 32 Bit and try reload?

Not applicable
Author

Hi Sreeni,

I tried  but   it  is  giving error.Do  i  need to install qlickview server.I  am not able to see any services related to qlickview in my machine.

petter
Partner - Champion III
Partner - Champion III

Whatever you might think:

1) You don't have a LOAD statement in your script - only an ODBC CONNECT

2) This ODBC CONNECT is failing when you execute your load script

3) The ODBC CONNECT statement has either a wrong USERID and/or wrong PASSWORD specified.

    These are stored in the XUserID and XPassword as hashed values. When they don't work you will typically

    get this request for User Name and Password by the dialog box you have shown.

4) This obviously fails too - although the error message tells about a timeout not password error...

It is still hard for me to judge exactly where your error is.

The normal thing to do when you have a CONNECT ODBC is immediately to create a LOAD statement by pressing the SELECT button. Maybe that is what you are doing? But you told me that you do a reload... So what is the case?

Not applicable
Author

Hi Peter,

Thanks for  travelling with me. I  have sloved  my issue.