Create SDE Layer as versioned and editable

Discussion created by sabitat on Sep 15, 2011
Latest reply on Sep 16, 2011 by vangelo-esristaff

Like • Show 0 Likes0
Comment • 5

I am using the direct connection to connect to the Arcsde (Sqlserver 2008) database. I created a spatial table and registered it as a layer using sde command. Now, I want to create service that will allow us to edit the layer in database (Feature Access Service). But I keep getting an error and on the desktop when I try to edit the layer it prompts a message "layer is not editable and it's not versioned". See the attachment.

So, the question is:
a) How do I register layer as versioned? It failed with sde -o register ...-V command
b) How do I create a layer that's editable? Note: I have already added ArcGISSOC account in sql server and grated a read/write permission.

Thanks,
Sabita

Attachments

Layer Error.docx270.1 KB

Outcomes

bpierce-esristaff

Sep 16, 2011 7:26 AM

Sabita,

If you Open the Geodatabase in ArcCatalog you should be able to right click on the feature class or table in question and select "register as versioned". Once the class is versioned you should be able to start a versioned edit session on the class in desktop.

Hope this helps,
-Brent

Actions

sabitat Sep 16, 2011 9:29 AM

Brent,

We don't have ArcEditor license therefore we can't use ArcCatalog to register as versioned. Can it be done using the ArcSDE layer command?

Sabita

Actions

vangelo-esristaff

Sep 16, 2011 10:23 AM

There are no ArcSDE command-line utilities which change anything managed by ArcObjects
(geodatabases are implemented on top of ArcSDE functionality).

- V

Actions

sabitat Sep 16, 2011 12:07 PM

vangelo, Thanks for the reply!

So, are you saying we must have a ArcEditor license to make a spatial data versioned and editable? Do we need just the ArcEditor or ArcInfo as well (note that we just have Arcview license currently)?

Is there any other way to create this layer without having to use ArcEditor?

Thanks,
Sabita

Actions

vangelo-esristaff

Sep 16, 2011 12:33 PM

It helps to keep the terminology straight:
+ ArcSDE operates with 'tables' and 'layers'
+ ArcGIS operates with 'feature classes'

Only ArcGIS can register a new feature class in an ArcSDE geodatabase for editing with ArcGIS
(and only with the ArcEditor or ArcInfo license levels).

If you are using ArcGIS 10, you don't need to use ArcSDE to access tables with GEOMETRY/
GEOGRAPHY columns -- instead you can use query layers.

- V

Actions

5 Replies

bpierce-esristaff Sep 16, 2011 7:26 AM
Sabita,

If you Open the Geodatabase in ArcCatalog you should be able to right click on the feature class or table in question and select "register as versioned". Once the class is versioned you should be able to start a versioned edit session on the class in desktop.

Hope this helps,
-Brent
Like • Show 0 Likes0
Actions
sabitat Sep 16, 2011 9:29 AM
Brent,

We don't have ArcEditor license therefore we can't use ArcCatalog to register as versioned. Can it be done using the ArcSDE layer command?

Sabita
Like • Show 0 Likes0
Actions
vangelo-esristaff Sep 16, 2011 10:23 AM
There are no ArcSDE command-line utilities which change anything managed by ArcObjects
(geodatabases are implemented on top of ArcSDE functionality).

- V
Like • Show 0 Likes0
Actions
sabitat Sep 16, 2011 12:07 PM
vangelo, Thanks for the reply!

So, are you saying we must have a ArcEditor license to make a spatial data versioned and editable? Do we need just the ArcEditor or ArcInfo as well (note that we just have Arcview license currently)?

Is there any other way to create this layer without having to use ArcEditor?

Thanks,
Sabita
Like • Show 0 Likes0
Actions
vangelo-esristaff Sep 16, 2011 12:33 PM
It helps to keep the terminology straight:
+ ArcSDE operates with 'tables' and 'layers'
+ ArcGIS operates with 'feature classes'

Only ArcGIS can register a new feature class in an ArcSDE geodatabase for editing with ArcGIS
(and only with the ArcEditor or ArcInfo license levels).

If you are using ArcGIS 10, you don't need to use ArcSDE to access tables with GEOMETRY/
GEOGRAPHY columns -- instead you can use query layers.

- V
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Create SDE Layer as versioned and editable

Attachments

Outcomes

Related Content

Recommended Content