Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Failure of ODBC reading

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

1 Solution

Accepted Solutions
Not applicable

Re: Failure of ODBC reading

Hello everyone,

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

11 Replies
Employee
Employee

Re: Failure of ODBC reading

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

Not applicable

Re: Failure of ODBC reading

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
Honored Contributor II

Re: Failure of ODBC reading

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

Employee
Employee

Re: Failure of ODBC reading

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

mov
Esteemed Contributor III

Re: Failure of ODBC reading

Laura,

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

konstantin
Contributor III

Re: Failure of ODBC reading

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

Not applicable

Re: Failure of ODBC reading

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

Not applicable

Re: Failure of ODBC reading

The source of data is a PostGre SQL

Not applicable

Re: Failure of ODBC reading

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

Community Browser