AutoCAD Map/Civil 3D Feature Data Object (FDO) layer displays but is no longer editable

by Ed Camden   Last Updated April 16, 2019 07:22 AM

Just over a week ago, one of our main GIS layers became uneditable. Our GIS layers are connected to AutoCAD Civil 3D (Fig.3) via an SQL Server Spatial Connection in the Task Pane. We were able to edit all connected layers for years, until last week when Cadastre became read only within AutoCAD Civil 3D. All other Feature Data Object (FDO) layers remained editable (Fig.1), while Cadastre is only visible and selectable (Fig.2).

What we know up to this point:

  • Cadastre is selectable but cannot be edited in AutoCAD Civil 3D
  • All other layers can be selected and edited in AutoCAD Civil 3D
  • DB Admin reported no locks or unusual activity on the Cadastre table
  • All layers, including Cadastre, are editable in another application - QGIS
  • Cadastre table was reconnected several times in AutoCAD Civil 3D
  • This affects all users using AutoCAD Civil 3D on separate workstations
  • All users have the same edit permissions to the Cadastre table in the database

Can you help us resolve this issue?

Fig.1 - Other layer objects present edit grips when selecting them.

enter image description here

Fig.2 - Cadastre can be selected but no edit grips presented. No edit commands or function are available for this layer.

enter image description here

Fig.3 - AutoCAD Civil 3D version.

enter image description here

Answers 1

After further investigation, it seems the table in question was recreated at some point and the "Primary Key" value was omitted from the PK column, which was set to an "Identity" column type. After recreating the Cadastre table with the correct column type and value of "Identity" and "Primary Key" respectively, AutoCAD now permits edits.

Ed Camden
Ed Camden
April 16, 2019 05:28 AM

Related Questions

Updated March 27, 2015 13:07 PM

Updated April 09, 2015 02:09 AM

Updated July 11, 2017 02:22 AM

Updated March 31, 2017 22:22 PM

Updated July 16, 2018 04:22 AM