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.
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.
1 个回复
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
要回复问题请先登录或注册