Failure of ODBC reading

[#1]

Hello everyone,

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

[Giuseppe_Novello]

Dear Laura,

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.

Gio

[#3]

Hi Giuseppe,

What is weird is that it happens on one table but before that other tables from the same database has been reloaded.

[ecolomer]

Check if you have any sentence SQL which your ODBC is not suported.

[Giuseppe_Novello]

Dear Laura,

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.

Gio

[Anonymous]

Laura,

Try to use ODBC CONNECT statement before each table you load.

[Anonymous]

What is the source you're trying to load data from? It looks like as in custom driver problem

[#8]

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..

[#9]

The source of data is a PostGre SQL

[#10]

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