sqlstate=HY000 SQLCODE=-1039

[Anonymous]

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 ?

[v-juanli-msft]

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]

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]

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.