4 Replies Latest reply: Aug 7, 2012 1:08 PM by Kaushik Solanki RSS

    Data Fetching Issue

      Hi all,

       

      I am currently using QV10 SR4 and are now planning to migrate to QV11 at new machine which is a 64 bit machine. (Current machine is 32 bit).

      I am facing challenges while fetching data from BAAN erp.

      My client have installed ODBC driver for Oracle (64 bit) and have copied tnsnames.ora file from the current machine to the new one.

       

      I have made the DSN and when I connect to database in QV it says "Connection Test Succeded"

      but when I fetch tables from the 'Select' button, only few tables are fetched completely others are not at all fetched or are fetched partially.

       

      Driver installed is  : Oracle in OracleClient11g

       

       

      Error shown is :

      Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 22007, ErrorCode: 0, ErrorMsg: [Oracle][ODBC]Invalid datetime format.

       

      When I tried to comment the date field, table is loaded fully.

       

       

      Please help me out as it has become a show stopper for migration.

       

      Please find the attached log file.

       

      Thanks

      Monika

        • Re: Data Fetching Issue
          Kaushik Solanki

          HI Monika,

           

              Then you should check for the date format in your SQL query.

           

              If possible you can paste the query here, so that we can try to figureout the issue.

           

          Regards,

          Kaushik Solanki

            • Re: Data Fetching Issue

              Hi,

              Thanks for repying.

              I am using the autogenerated query that we get when we select a table.

               

              LOAD *;

              SQL SELECT *

              FROM BAAN.TTDCUS001100;

              It throws error.

               

              But if I select a single field all records are fetched.

               

              LOAD 

               

                      date(T$INVD,'DD-MMM-YYYY') as  "T$INVD";

              SQL SELECT

                     T$INVD

              FROM BAAN.TTDCUS001100

              where T$INVD >= '01-JAN-2012';

               

              I have tried fetching all date fields by same method but again 0 rows are  fetched.

              May be I am missing something.

               

              Formatting all fields might get us to the result but that won't be a generic solution since we have many tables each with multiple date fields.