Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: ODBC read failed

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

17 Replies
Employee
Employee

Re: ODBC read failed

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

Re: ODBC read failed

Hi

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

Thanks,

Vishal

Not applicable

Re: ODBC read failed

Hi all! Thank for your answers.

I use SQL query

vishalwaghole
Valued Contributor II

Re: ODBC read failed

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

Re: ODBC read failed

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

Re: ODBC read failed

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

Re: ODBC read failed

Ok. Thanks. Trying.

Not applicable

Re: ODBC read failed

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

Re: ODBC read failed

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

Community Browser