Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
以下是具体的错误消息,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 接口引发。
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:
User | Count |
---|---|
4 | |
4 | |
2 | |
2 | |
2 |