表格对象模型（TOM）导致SSAS表格2017的间歇性崩溃 [英] Tabular Object Model (TOM) causes intermittent crash of SSAS Tabular 2017

问题描述

使用TOM删除然后重新创建SSAS表格数据库可能导致以下错误，只能通过重新启动SSAS服务来修复。

Using the TOM to drop then recreate a SSAS Tabular databases can cause the following error which can only be fixed by restarting the SSAS service.

    at Microsoft.AnalysisServices.Tabular.Model.SaveChanges（SaveOptions saveOptions）

   at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)

使用以下代码删除数据库：

Database is dropped using the code:

与服务器建立新连接，并创建TOM数据库对象，然后调用SaveChanges。

A new connection is made to the server and the TOM database objects are created after which the call to SaveChanges is made.

在创建和部署新数据库之前，删除旧数据库并刷新连接似乎存在问题。 也许使用类似于SqlServer的"立即回滚"的东西。

It appears that there is an issue in dropping the old database and refreshing the connections before creating and deploying the new one.  Maybe use something akin to SqlServer's "with immediate rollback".

重新启动SSAS后，数据库按预期部署。

Once SSAS has been restarted the database deploys as expected.

推荐答案

你好jm98，

Hi jm98,

根据你的描述，我不知道哪个部分会导致错误（删除或重新创建部分），如果可能，请您告知我更详细的信息（例如您的代码，代码执行环境）？然后我将在我的环境中对此进行测试。

According to your description, I don't know which part will cause error(drop or re-create part ), if possible, could you please inform me more detailed information(such as your code, your code execution environment)? Then I will test this in my environment.

另外，你的意思是当你使用savechanges（）时，它会起作用（尝试在上面断开连接上添加SaveChanges（））？您可以参考  rying
Process Tabular 1400 AMO Powershell  &absp; this post   for
details。

In addition, did you mean that when you use savechanges(), it will work(try to add SaveChanges() above disconnect)? You could refer to rying Process Tabular 1400 AMO Powershell and this post for details.

顺便说一下，您也可以尝试参考  故障排除：没有进程在管道的另一端 了解详情

By the way, you also could try to refer to Troubleshooting: No Process Is on the Other End of the Pipe for details

这篇关于表格对象模型（TOM）导致SSAS表格2017的间歇性崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！