Discussion Board for collaboration on QlikView Scripting.
I sometimes face a probelm while reloading an application with QV Desktop.
I get the error "Failure of ODBC reading".
"QVX PIPE ERROR"
No more explaination.
I have tried to reload the table that looks to raise the problem in a separated application and there no problem.
I have also tried to reload again the application and then, the mistake occurs later (on a another table).
Do you have any ideas about that mistake ? What does it come from ? COuld that be that I import to many data ?
thank you for your help
Go to Solution.
I have found the problem. It's because other users were logged on and were reloading application at this moment. It was too much for the server I think.
Thank you for your help though
You do not see any other error before or after the "Failure of ODBC reading" ?
Also, I would check if you have the latest ODBC driver it might be due to a old ODBC driver.
What is weird is that it happens on one table but before that other tables from the same database has been reloaded.
Check if you have any sentence SQL which your ODBC is not suported.
Have you try to run the same script in Excel? https://www.youtube.com/watch?v=joi2HTh45YQ
see if you can replicate the same issue there.
Try to use ODBC CONNECT statement before each table you load.
What is the source you're trying to load data from? It looks like as in custom driver problem
Hi Michael, it's true I usually put this statement only once at the beginning of the script. I will try that.
edit : I have tried to add the ODBC statement before the reload of the table for which it fails and now I get the error "Failed to connect to Qlikview Connector, ODBC CONNECT To myconnector"
I don't get it, this connector works...
It works in production as well..
The source of data is a PostGre SQL
I think the problem comes from the fact that the table is too big
Because I tried to do it with "first 1000 LOAD ..." and then no problem.
I will try incremental relaod