使用SSDT 15.9.9部署具有兼容级别1400的表格项目。返回错误：'意外的列名' [英] Deploy tabular project with SSDT 15.9.9 with compatibility level 1400. Error returned: 'Unexpected column name'
问题描述
你好，
Hello,
我无法使用SSDT 15.9.9部署Tabular项目在Analysis Server 14.0.239.1中具有兼容级别1400（1200可用）。我收到以下错误：
I cannot deploy a Tabular project with SSDT 15.9.9 with compatibility level 1400 (with 1200 it works) in Analysis Server 14.0.239.1. I get the following error:
================== ==========
错误消息：
============================
无法保存对服务器的修改。返回错误：'意外的列名：在行集'注释'中收到列'ObjectID.Expression'。预期
列'ObjectID.Set'。
'。
----------------------------
无法保存对服务器的修改。返回错误：'意外的列名：在行集'注释'中收到列'ObjectID.Expression'。预期
列'ObjectID.Set'。
'。
----------------------------
打开模型时发生错误。单击详细信息以获取更多信息。
============================
Call Stack：
< em style ="border：0px; font-weight：inherit; font-family：inherit; margin：0px; outline：0px; padding：0px"> ================= ===========
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges（SaveOptions saveOptions）
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges（SaveFlags saveFlags）
at Microsoft.AnalysisServices.BackEnd.DataModelingServer.CreateCatalog（String databaseName，Int32 localeID，DirectQueryMode directQueryMode，
Int32 clientCompatibilityLevel）
------------------------- ---
; at Microsoft.AnalysisServices.BackEnd.DataModelingServer.CreateCatalog（String databaseName，Int32 localeID，DirectQueryMode directQueryMode，
Int32 clientCompatibilityLevel）
at Microsoft.AnalysisServices.VSHost.VSHostManager.OnNewProjectPrepareSandbox（Boolean isRealTimeMode，Int32 clientCompatibilityLevel）
at Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox（Boolean newProject，Boolean& isRefreshNeeded，Boolean& isImpersonationChanged，
Boolean& saveRequired，List`1& truncatedTables，Boolean isRealTimeMode，Int32 clientCompatibilityLevel）
---------- ------------------
at Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox（Boolean newProject，Boolean& isRefreshNeeded，Boolean& isImpersonationChanged，
Boolean& saveRequired，List`1& truncatedTables，Boolean isRealTimeMode，Int32 clientCompatibilityLevel）
at Microsoft.AnalysisServices.VSHost.Integration.EditorFactory.CreateEditorInstance（UInt32 grfCreateDoc，String pszMkDocument，String pszPhysicalView，
IVsHierarchy pvHier，UInt32 itemid，IntPtr punkDocDataExisting，IntPtr& ppunkDocView，IntPtr& ppunkDocData，String& pbstrEditorCaption，Guid& ; pguidCmdUI，Int32& pgrfCDW）
============================
============================
Error Message:
============================
Failed to save modifications to the server. Error returned: 'Unexpected column name: Received column 'ObjectID.Expression' in rowset 'Annotations'. Expected
column 'ObjectID.Set'.
'.
----------------------------
Failed to save modifications to the server. Error returned: 'Unexpected column name: Received column 'ObjectID.Expression' in rowset 'Annotations'. Expected
column 'ObjectID.Set'.
'.
----------------------------
An error occurred while opening the model. Click Details for more information.
============================
Call Stack:
============================
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveFlags saveFlags)
at Microsoft.AnalysisServices.BackEnd.DataModelingServer.CreateCatalog(String databaseName, Int32 localeID, DirectQueryMode directQueryMode,
Int32 clientCompatibilityLevel)
----------------------------
at Microsoft.AnalysisServices.BackEnd.DataModelingServer.CreateCatalog(String databaseName, Int32 localeID, DirectQueryMode directQueryMode,
Int32 clientCompatibilityLevel)
at Microsoft.AnalysisServices.VSHost.VSHostManager.OnNewProjectPrepareSandbox(Boolean isRealTimeMode, Int32 clientCompatibilityLevel)
at Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox(Boolean newProject, Boolean& isRefreshNeeded, Boolean& isImpersonationChanged,
Boolean& saveRequired, List`1& truncatedTables, Boolean isRealTimeMode, Int32 clientCompatibilityLevel)
----------------------------
at Microsoft.AnalysisServices.VSHost.VSHostManager.PrepareSandbox(Boolean newProject, Boolean& isRefreshNeeded, Boolean& isImpersonationChanged,
Boolean& saveRequired, List`1& truncatedTables, Boolean isRealTimeMode, Int32 clientCompatibilityLevel)
at Microsoft.AnalysisServices.VSHost.Integration.EditorFactory.CreateEditorInstance(UInt32 grfCreateDoc, String pszMkDocument, String pszPhysicalView,
IVsHierarchy pvHier, UInt32 itemid, IntPtr punkDocDataExisting, IntPtr& ppunkDocView, IntPtr& ppunkDocData, String& pbstrEditorCaption, Guid& pguidCmdUI, Int32& pgrfCDW)
============================
我也测试了一个新项目。 更重要的是，如果我创建了一个新项目并设置了w orkspace服务器使用SQL Server，我收到同样的错误。
I have tested with a new project too. What's more, if I create a new project and set the workspace server to use the SQL Server, I receive the same error.
使用表格式编辑器，兼容性为1400，工作正常，如果我在同一个SQL分析服务器中恢复兼容级别为1400的数据库，那么我认为问题出在SSDT IDE中。你知道原因吗？
With Tabular Editor with compatibility at 1400 works fine and If I restore a Data Base with compatibility level at 1400 in the same SQL Analysis Server works also so I think the problem is in SSDT IDE. Do you know the reason?
提前谢谢你。
Thank you in advance.
$ b $bNicolás。
Nicolás.
推荐答案
嗨Nicolas C，
Hi Nicolas C,
我不确定哪个部分会导致这个问题。你说你用的是" 工作区服务器使用SQL Server，"，
它会提示错误，你可以尝试使用SSAS表格服务器（确保当前SSAS版本具有1400兼容性级别）并将兼容级别设置为1400以查看它是否有效。您可以参考 兼容性
级别的Analysis Services表格模型。
I am not sure which part will cause this problem. you said you use " workspace server to use the SQL Server,", it will prompt error, you could try to use SSAS tabular server(make sure current SSAS version have 1400 compatibility level ) and set compatibility level to 1400 to see whether it works or not. You could refer to Compatibility level for Analysis Services tabular models.
顺便说一句，你也可以使用其他SSDT的版本，以检查是否由工具造成。
By the way, you also could use other version of SSDT to check whether this cause by tool.
这篇关于使用SSDT 15.9.9部署具有兼容级别1400的表格项目。返回错误：'意外的列名'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
