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
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
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.
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
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
