Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Hi
Please tell me how you load data, that means using SQL query or anything else.
Thanks,
Vishal
Hi all! Thank for your answers.
I use SQL query
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
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?
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.
Ok. Thanks. Trying.
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.
Could you please possible to upload your sample file those getting error for you.