Solved: Re: ODBC read failed - Qlik Community

Report Inappropriate Content · ‎2013-03-20

Hi!
I'm trying to load data from .DBF files but i have the following problem
"QVX_PIPE_ERROR:
20.03.2013 9:17:57: Error: ODBC read failed".
It doesn't happen all the time. Sometimes it executes succesfully.

I use Microsoft Acess dBase Driver.
I try to delete conecction and create again but problem isn't resolved.

RAM 32 GB

QV Server 11.20.11716.0

This problem happen on QV server and QV Desctop too.

Please, help me

Report Inappropriate Content · ‎2013-05-30

Finally,we found the reason of this error. It is a bugID 62361.

If total amount of core of processors >2 , error will happen.

If total amount of core of processors <=2, it will success.

It works fine in version 11.0.11466 . The error reproduced in 11.20 SR1 and 11.20 SR2 , so we use QV v 11.0.11466 on customer's server. QT plan to fix this bug on v. SR3 (planned release in September).

P.S. We use VMware

View solution in original post

Chris_Rice · ‎2013-03-20

If the error is intermittent, it most likely lies on the ODBC side. I would try using the same driver to pull the information into another tool, and see if the issues persists.

Check out the Support Knowledgebase

VishalWaghole · ‎2013-03-20

Hi

Please tell me how you load data, that means using SQL query or anything else.

Thanks,

Vishal

Report Inappropriate Content · ‎2013-03-21

Hi all! Thank for your answers.

I use SQL query

VishalWaghole · ‎2013-03-21

In your SQL Query dont use *, use individual column name and test individual column.

apply this function on column name who give you the erroe like ODBC read failed.

suppoes your column name is description then

convert(Description,'US7ASCII','WE8ISO8859P1') as Description.

Hope this will help you.

Thanks

Vishal

Report Inappropriate Content · ‎2013-03-21

I load 6 tables and and each time I see error for a different table.

If i don't use * how can it affect this?

VishalWaghole · ‎2013-03-21

You need to select individual columns and then debug that, because of which column you

get this error and then apply function which i gave you earlier for that column.

Report Inappropriate Content · ‎2013-03-21

Ok. Thanks. Trying.

Report Inappropriate Content · ‎2013-03-21

Error hash't happen yet, but i tried to load data from same .dbf files when it was error and it executed succesfully, i.e data is ok.

It executed sucsessfully for 3 month but something has changed in this week.

VishalWaghole · ‎2013-03-22

Could you please possible to upload your sample file those getting error for you.