1

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

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.