topic ODBC read failed in QlikView

ODBC read failed

Wed, 20 Mar 2013 15:14:46 GMT

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

Re: ODBC read failed

Chris_Rice — Wed, 20 Mar 2013 23:08:01 GMT

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.

Re: ODBC read failed

VishalWaghole — Thu, 21 Mar 2013 03:51:49 GMT

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

Thanks,

Vishal

Re: ODBC read failed

Thu, 21 Mar 2013 04:31:01 GMT

Hi all! Thank for your answers.

I use SQL query

Re: ODBC read failed

VishalWaghole — Thu, 21 Mar 2013 04:47:00 GMT

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

Re: ODBC read failed

Thu, 21 Mar 2013 07:12:57 GMT

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?

Re: ODBC read failed

VishalWaghole — Thu, 21 Mar 2013 07:39:39 GMT

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.

Re: ODBC read failed

Thu, 21 Mar 2013 08:33:33 GMT

Ok. Thanks. Trying.

Re: ODBC read failed

Thu, 21 Mar 2013 20:41:48 GMT

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.

Re: ODBC read failed

VishalWaghole — Fri, 22 Mar 2013 05:19:08 GMT

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

Re: ODBC read failed

Fri, 22 Mar 2013 11:54:42 GMT

Vishal, sorry, i can't .

I don't think that problem is resolved but i can't reproduce the bug two days.

Re: ODBC read failed

Thu, 30 May 2013 18:57:44 GMT

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

Re: ODBC read failed

Mon, 16 Dec 2013 13:18:48 GMT

I am using explicit colum names (not using *) and have installed SR3 and still having the QVX_PIPE_ERROR error.

Is there any other action to do?

Re: ODBC read failed

Mon, 16 Dec 2013 13:44:50 GMT

Hi, Andre!

QT Support told us they wouldn't fix this bug.

So we decided to convert .dbf to Excel and than to load data from Excel to QV.

Re: ODBC read failed

datanibbler — Tue, 29 Jul 2014 10:45:55 GMT

Hi Kseniya,

we have the same issue here, we are running QV 11.2 SR7. Apparently QT has stuck to their word and not fixed it

😉

I read your post such that the number of cores that are working on the script simultaneously is relevant, is that it?

So there may only be one core working on it - if it is distributed (by a LoadBalancing, I imagine), then it fails.

Do you know of any way of fixing it on the server-side?

Best regards,

DataNibbler

Re: ODBC read failed

Tue, 29 Jul 2014 10:56:48 GMT

Hi, DataNibbler! QT didn't fix it. They told us:"

The file format DBF is an old legacy file format from the mid 70s, They have already a history of being troublesome and not supported by multithreaded tasks and could in those cases become corrupted.

Adding full support for the files in Qlikview would take substantial time and could also impact performance or usability in other areas of Database loading and handling. Therefore it is not viable for us to support it.

With that being said, the alernative would be to transform the dbf files to standard Access file type mdb, xls, csv or what ever would be suitable for you"

It will work only in 11.0, so, i recommend you add some .bat for convert dbf to Excel. We have used it since this issue and it works fine on multi-cores.

Re: ODBC read failed

datanibbler — Thu, 31 Jul 2014 09:08:26 GMT

Hi Kseniya,

the problem is now becoming annoying - we have had the same error regularly.

The trouble is, QlikView is not officially supported by our IT, so we cannot necessarily count on their help, we have to ask and hope.

I have no experience in this.

Can you tell me what exactly I should be asking the IT_guys with regard to this error? I'll begin by collecting some of the application_logs where the error occurs.

Thanks a lot!

Best regards,

DataNibbler

Re: ODBC read failed

Thu, 31 Jul 2014 10:21:29 GMT

Ok. We decided this issue without QT support (previos message)

You can resolve this issue for 2 alternate steps:

1. Reinstall QV to version 11.0

2.Get converter dbf to Excel. You can use .vbs :

pathToDbfFolder = "C:\QV_documents\Output"

pathToExcel = "C:\QV_documents\Output\xls\"

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set File = objFSO.CreateTextFile("C:\QV_documents\Convert dbf\log.log", True)

Set objExcel = CreateObject("Excel.Application")

objExcel.visible=false

Set objFolder = objFSO.GetFolder(pathToDbfFolder)

Set colFiles = objFolder.Files

File.WriteLine "found" & colFiles.Count

For Each objFile in colFiles

If objFSO.GetExtensionName(objFile) = "dbf" Then

absFile = objFSO.GetAbsolutePathName(objFile)

File.WriteLine(absFile)

filename = Split(objFile.Name, ".")(0)

File.WriteLine(filename)

Call Convert(absFile, filename, File, objExcel)

End If

objExcel.Application.Quit

Sub Convert(absFile,filename, File, objExcel)

File.WriteLine("Start convert")

Set objWorkbook = objExcel.Application.Workbooks.Open(absFile)

File.WriteLine("Open dbf")

objExcel.ActiveWorkbook.SaveAs pathToExcel & filename & ".xlsx"

File.WriteLine("Save into Excel")

objExcel.ActiveWorkbook.Close

File.WriteLine "End Convert"

End Sub

In the end:

dbf->convertor xls (Excel files)-> QV-> QVD