Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ODBC read failed

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



1 Solution

Accepted Solutions
Not applicable
Author

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

17 Replies
Chris_Rice
Support
Support

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.

VishalWaghole
Specialist II
Specialist II

Hi

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

Thanks,

Vishal

Not applicable
Author

Hi all! Thank for your answers.

I use SQL query

VishalWaghole
Specialist II
Specialist II

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

Not applicable
Author

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
Specialist II
Specialist II

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.

Not applicable
Author

Ok. Thanks. Trying.

Not applicable
Author

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
Specialist II
Specialist II

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