topic Oracle OLEDB connection hangs in QlikView

Oracle OLEDB connection hangs

jonathandienst — Wed, 11 May 2011 08:11:41 GMT

I have a strange situation with an Oracle based model. When I reload the document the reload hangs on the Oracle connect statement:

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxxx;Data Source=xxxx;Extended Properties=""]....

I can load the model by entering debug mode and clicking Run. When I do that, the connection works perfectly, but not if I reload by clicking reload or with CTRL-R.

I can also open the SELECT dialog and browse the database without a problem - but we won't be able to deploy this model until this has been resolved.

Tested on 10SSR1 and 10SR2 and after re-installing QV. The computer is running 64bit WIindows Server 2008. We do not have the problem on small models, or on the problem model if it is no-data loaded.

Any ideas?

Jonathan

Oracle OLEDB connection hangs

prieper — Wed, 11 May 2011 08:18:47 GMT

Independent from the actual stopping-point, might make sense to check in your query the date-format. Observed the same on SQL-queries with the SR2 (with the same script as used before) and execution simply halted without any error-message. Also the log stopped somewhere within the script.

Finally it turned out that we have used a "sloppy" formatting of the dates used in the SQL-Where-clause.

Peter

Oracle OLEDB connection hangs

jonathandienst — Wed, 11 May 2011 08:55:57 GMT

Peter

Thanks for the response.

The script stops at the CONNECT statement (verified from the log), so its not even getting to the queries (although I will bear your point in mind for the future)!.

The confusing thing is that it works perfectly in Debug mode.

Jonathan

Oracle OLEDB connection hangs

prieper — Wed, 11 May 2011 09:46:55 GMT

In Debug-Mode with "You" as user? Then it might be something with user-rights....

Peter

Oracle OLEDB connection hangs

stephencredmond — Wed, 11 May 2011 11:34:46 GMT

Hi,

Do you have the "Save before reload" option on in User Preferences?

What happens if you turn it off?

Regards,

Stephen

Oracle OLEDB connection hangs

jonathandienst — Thu, 12 May 2011 17:20:47 GMT

Thanks all for your suggestions - a faulty disk was replaced on the server (and the server restarted) and the problem has resolved itself!

Regards

Jonathan