4 Replies Latest reply: Jul 21, 2015 2:44 AM by Serhan Celebi RSS

    ODBC Error

    Mark Graham

      HI all,

       

      I'm fetching the data from ODBC tables (huge)

       

      Script load gets failed with below error:

       

      QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 08S01, ErrorCode: 10054, ErrorMsg: [IBM][System i Access ODBC Driver]Communication link failure. comm rc=10054 - CWBCO1047 - The System i server application  disconnected the connection

         Error: ODBC read failed

          General Script Error

       

      Any help is appreciated.

        • Re: ODBC Error
          Maxim Senin

          Hi,

           

          Not sure since it was quite a long time ago, but it seems that you have some troubles with your query. Check whether it works well outside of QV. In my case there were some problems with either subqueries or formats of values.

           

          Best regards,

          Maxim

          • Re: ODBC Error
            KALYAN KRISHNA

            Hi,

            Delete the old connection string and try with new connection string. Then, you may get an idea where will be the error is.

            • Re: ODBC Error
              Prashant Sangle

              Hi,

               

              Contact to your DBA team and asked them that they have taken any down time during your extractor was executing.

               

               

              Regards,

              • Re: ODBC Error
                Serhan Celebi

                Hello,

                 

                This is generally because of some formatting problem of some columns in the sql.

                 

                1. Try with limited load.

                2. If result is same try to eliminate the columns to see which one is problematic.

                 

                Another cause might be related to timeout or network problems. If you can trace it on source side, try to do so to locate the problem. Maybe it's rejected by source. That's also possible, looking at the error.

                 

                BR

                 

                Serhan