Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
When I use the dataloadeditor to load data by sql query (odbc) I sometimes make mistakes in my script syntax .
But the problem is that Qlik waits 10 minutes to show me that error when I run the script without debug-mode.
It doesn't seem to be doing anything. I have to wait for about 10 minutes and 30 seconds before I get a simple message like "connection not found", or "can't find field XXXX". Seems like something it would know after 1 second. Is this a parameter somewhere, that Qlik keeps trying for x minutes before returning an error?
Thank you, Nas
There is no timeout setting in Qlikview. Perhaps the odbc driver has one. You'll have to look at the documentation of the odbc driver to find that out. That's not part of Qlikview.
You can also use the Debug mode and then specify how many records you want to load in the debug run. Or you can add a line like FIRST 100 above the sql load statement. I recommend debugging properly to make sure all the load statements are correct and return results.
There may be several issues in your environment – please review the behaviors below and fix any that may apply: