Error:  Failed to compress the database: The column cannot be modified because it is either a computed column or is the result of a UNION operator

相关信息
Article ID: 44828
Software:
ArcGIS for Desktop Advanced 10.2, 10.1, 10.2.1, 10.3, 10.3.1, 10.1 SP1, 10.2.2
ArcGIS for Desktop Standard 10.2.1, 10.1, 10.2, 10.1 SP1, 10.3.1, 10.2.2, 10.3
ArcSDE 10.1, 9.3, 10.2.1, 10.2, 10, 10.2.2, 9.3.1
Platforms: N/A

错误信息
When trying to compress a SQL Server database, the following error may be returned:

"Failed to compress the database:
Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]The column cannot be modified because it is either a computed column or is the result of a UNION operator.]"


错误原因
SQL Server database tables that contain computed columns cannot be compressed because the geodatabase does not support auto-populated fields such as computed columns or auto-incrementing fields.
已邀请:

EsriSupport

赞同来自:

解决方案
Data tables with computed columns can be viewed in ArcGIS using Database Views or Query Layers, but the use of these tables for editing is not supported.


ArcGIS 10.3 Web Help: Create Database View

ArcGIS 10.3 Web Help: Creating a query layer


Removing the computed column allows edits to be compressed successfully.


创建及修改时间
Created: 6/5/2015 Last Modified: 6/8/2015
原文链接
http://support.esri.com/en/kno ... 44828

要回复问题请先登录注册