17 Replies Latest reply: Jul 31, 2014 6:21 AM by Ksenia Babikhina RSS

    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



        • Re: ODBC read failed
          Chris Rice

          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
            vishal waghole

            Hi

             

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

             

            Thanks,

             

            Vishal

              • Re: ODBC read failed

                Hi all! Thank for your answers.

                I use SQL query

                  • Re: ODBC read failed
                    vishal waghole

                    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

                        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
                            vishal waghole

                            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

                                Ok. Thanks. Trying.

                                • 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.

                                    • Re: ODBC read failed
                                      vishal waghole

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

                                        • Re: ODBC read failed

                                          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

                                              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
                                                  Andre Rehn

                                                  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

                                                      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
                                                          Friedrich Hofmann

                                                          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

                                                              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
                                                                  Friedrich Hofmann


                                                                  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

                                                                      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

                                                                      Next

                                                                       

                                                                       

                                                                      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