Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
milk_li0916
Regular Visitor

Scheduled refresh failed seemingly random

 

以下是具体的错误消息,PBI RS 版本为 202409

 

   在 Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveFlags flags, Int32 maxParallelism)
   在 Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.RefreshDatabase(String databaseName, IEnumerable`1 dataSources, IEnumerable`1 parameters, String clientSessionId)
   在 Microsoft.PowerBI.ReportServer.WebHost.EventHandler.AnalysisServicesDataRefresh.RefreshDatabase(AsDatabaseInfo asDatabaseInfo)
   在 Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<>c__DisplayClass34_0.<ExecuteActionWithLogging>b__0()
   在 Microsoft.PowerBI.ReportServer.WebHost.EventHandler.DataRefreshScope.<ExecuteFuncWithLogging>d__33`1.MoveNext()
2025-01-24 08:50:15.5946|ERROR|84|Error Processing Data Model Refresh: SessionId: 638470bf-07d7-49f9-b603-97639a6848f3, Status: Error Failed Data Refresh, Exception Microsoft.AnalysisServices.OperationException: Failed to save modifications to the server. Error returned: 'DataSource.Error: PostgreSQL: 57014: canceling statement due to user request. DataSourceKind = PostgreSQL. DataSourcePath = hgpostcn-cn-nwy3e6ywy00a-cn-shenzhen.hologres.aliyuncs.com:80;hqwx_bigdata. Message = 57014: canceling statement due to user request. ErrorCode = -2147467259. 。此异常由 IDataReader 接口引发。请查看错误消息和提供程序文档,以了解详细信息和纠正措施。
The command has been canceled.。该异常由 IDbCommand 接口引发。
已取消当前操作,因为事务中的另一个操作失败。
The command has been canceled.。该异常由 IDbCommand 接口引发。

 

 

2 REPLIES 2
lbendlin
Super User
Super User

Looks like your data source has its own timeouts and enforces them by cutting the connection?

Hi,

  Sorry for the late reply, as I was swamped with a lot of work.

  This scheduled task is set to run every 5 minutes. After testing, the results varied across different versions of the report server.
  - When running the same BI file on the 2024.1 version, the schedule executed without errors.
  - When running the same BI file on the 2024.9 version, it occasionally failed, with a success-to-failure ratio of 1:1.

  The conclusion is that the errors are likely not related to the data source. Preliminary investigation suggests that the issue might be with the configuration of the 2024.9 version. Below are the configuration screenshots for both versions.

2024.9 version:

milk_li0916_0-1738745898557.png

milk_li0916_1-1738745959585.png

 

 

 

  

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors