sql-server - 分析服务连接被远程主机关闭(Azure SQL 数据库)

Question

尝试从 Azure SQL 数据库加载 Analysis Service 中的 FACT 表(约 15M 行)时，我总是在一小时后收到此错误:

Failed to save modifications to the server. Error returned: 'A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.);An existing connection was forcibly closed by the remote host. The exception was raised by the IDataReader interface.

我似乎找不到更改 Azure SQL Server 超时的设置...有人知道我在哪里可以找到它吗？

Answer 1

超时可能是在 SSAS 端而不是 Azure SQL 数据库上设置的吗？

如果您使用现代的“获取数据体验 (Power Query)”，请查看此线程:

SSAS tabular model timeout raised during processing

要检查这一点，请通过单击 Model.bim 打开模型源代码，然后按 F7 并搜索关键字“timeout”。

目标是找到这样的东西:

"options": {
          "commandTimeout": "PT1H"
        },

或

Source = Sql.Database("serverName.database.windows.net","databaseName",
[CommandTimeout=#duration(0, 2, 0, 0)])