Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

sqlstate=HY000 SQLCODE=-1039

Dear Coll, I have trouble with the download of data from IBM DB2 connection. The Query worked fine untill 2 weeks ago. Since then, it turned slow, meaning the download runs at +/- 500 lines instead of 10,000 lines /second. (download at +/- 800 kbps instead of 50 Mbps) Nowadays, it even gets worse. After being slow for 2 hours, it breaks down. error code : see above. I have tested several conditions; it is not the network, neither the LAN or my network card; drivers haven't been changed. The only thing that differs is an update from win 10 (cumulative update 2019 07 win 10 version 1903 X64 (KB4505903) I have tried a reset to previous restore point, but that failed. Google and I have no clue what this error may have caused. Anyone an idea ?
Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    What is the completed error message?

    This error may be caused for a distribution key or organizing key is changed at the same time.

    Check if the similar thread would help.

    https://community.powerbi.com/t5/Desktop/April-release-broke-certain-DB2-connections-SQLSTATE-HY000/td-p/396090

    or

    https://community.powerbi.com/t5/Desktop/Error-when-trying-to-connect-to-IBM-DB2/td-p/69094

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      complete error :

       

      DataSource.Error: Microsoft Db2 Client: Er is een uitzondering opgetreden van het type Microsoft.HostIntegration.Drda.Common.DrdaException. SQLSTATE=HY000 SQLCODE=-1039
      Details:
          DataSourceKind=DB2
          DataSourcePath=as400:446;PRD
          Message=Er is een uitzondering opgetreden van het type Microsoft.HostIntegration.Drda.Common.DrdaException. SQLSTATE=HY000 SQLCODE=-1039
         ErrorCode=-2146233088

       

      Dear Miss,

       

      I have checked both proposed solutions. Not applicable in my case, since both solutions are correct in my settings.  I have emptied the cache in the power BI. Is there any limit on cache or data ?  In my excel, I download +/- 4 million data lines into a pivot table. 

      Yesterday, I have divide the PT into smaller pieces and it works (but it takes all day to download).

       

      KR,

       

      FHO

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi Anonymous 

        From the error message, it seems it takes time out when loading large data.

        When you import large data from IBM DB2 database into Power BI, to get it connected quicklly,you could connect to the database in direct query mode.

        In this way, it doesn't need to import data into Power BI, but keep a connection with database.

        https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

         

        Best Regards
        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.