Cannot refresh a Power BI Report

[Lorenz33]

We are running Power BI Report Server (January 2022). We have a Power BI report where the data source is a DB2 database. It imports approximately 5 GB of data. This report has been uploaded to our Power BI Report Server development environment. We set up the data source with Basic Authentication and it connects successfully. We then set up a scheduled refresh and it runs for 10 minutes and then fails with this error:

Data source error: Login failed for data source

[0] -33333333333: DataSource.Error: Microsoft Db2 Client: Processing was cancelled due to an interrupt. SQLSTATE=57014 SQLCODE=-952. DataSourceKind = DB2. DataSourcePath = BD33333;MyDB. Message = Processing was cancelled due to an interrupt. SQLSTATE=57014 SQLCODE=-952. ErrorCode = 0. . The exception was raised by the IDbCommand interface.

I increased the query timeout value from 1800 to 3600 seconds and it still fails. Please let me know what solutions are available to get this data refresh to finish successfully.

[v-luwang-msft]

Hi @Lorenz33 ，

If the application sets a query timeout value, it will stop the execution of the statement if it exceeds the timeout resulting in a SQL0952N error.

And details solution to resolve the problem,refer the following links:

https://www.ibm.com/support/pages/sql0952n-error-returned-long-running-sql-statement 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Lorenz33]

Thanks Lucien. The attached article looks very helpful. Does anything need to be done on the Power BI Report Server side? The article explains to increase the query timeout interval on the different application types. Within Power BI Report Server I went to site settings and under report timeout I changed the value to 3660 seconds from 1800 to allow the report to run before timing out. This would be one hour and the scheduled refresh fails after 10 minutes.

[v-luwang-msft · Accepted solution]

Hi @Lorenz33 ,

I am sorry that I cannot reproduce your situation. It seems to me that in Power Bi Service not need to be adjusted, if it is due to a timeout setting in Power BI Service, it will simply report an error timeout instead of Processing was cancelled due to an interrupt. Related link below, there are the same users who encountered the same problem If you have the same problem, you can refer to the linked solution to change the DB2 timeout or disable timouts:

https://www.toolbox.com/tech/data-management/question/sql0952n-processing-was-cancelled-due-to-an-in... 

https://stackoverflow.com/questions/11570439/db2-queries-get-occasional-sql0925n-processing-cancelle... 

https://www.ibm.com/mysupport/s/question/0D50z000060GOynCAG/error-57014-ibmdb2nt-sql0952n-processing... 

Best Regards

Lucien

[d_gosbell]

The part of the error that says "Processing was cancelled due to an interrupt" looks to me like it's probably coming from DB2. Have you talked to your DB2 DBAs to see if they can assist with this? It could be some sort of resource governing on the DB2 side of things

[Lorenz33]

I spoke with the DB2 DBA and he said that there is no timeout value set up on the DB2 side and there is nothing in the DB2 logs related to the query being interupted or timing out.