Forum Discussion

milk_li0916's avatar
milk_li0916
Frequent Visitor
1 year ago

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

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

    • milk_li0916's avatar
      milk_li0916
      Frequent Visitor

      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: