topic Re: Annotation Class (SDE) in Geodatabase Questions

Annotation Class (SDE)

DanKerntop — Tue, 06 Feb 2018 22:24:17 GMT

We have a standard annotation class in a few datasets in SDE that do not allow us to add, delete or rename the annotation classes in the properties. However, we are able to do this in a file geodatabase. We are using ArcMap 10.5.1. Has anyone else had this issue and if so, how did you resolve it? Finally, we have contacted ESRI and they are unable to provide an answer.

Re: Annotation Class (SDE)

Asrujit_SenGupta — Wed, 07 Feb 2018 04:38:40 GMT

What issues do you face? Is there an error message? What is the error message, if any?
What configuration are you using (Database, Database version, Enterprise gdb version)?

Is the data in that Feature Dataset consumed in any services? Maybe a Lock is preventing?

If you make sure that there are no connections to the Geodatabase and then try, does it help?

If you create a copy of that same Feature Dataset, in that same Enterprise gdb, does it show the same behavior?

Re: Annotation Class (SDE)

DanKerntop — Wed, 07 Feb 2018 14:34:08 GMT

We do not get an error message. It seems once we version the dataset the anno feature class the options are ‘grayed’ out.

Dan Kerntop

GIS Analyst

City of Wausau

Dept of Public Works

407 Grant St

Wausau, WI 54403

City of Wausau

Office: (715) 261-6757

Learn more about

the City of Wausau at:

www.ci.wausau.wi.us<http://www.ci.wausau.wi.us/>

Re: Annotation Class (SDE)

Asrujit_SenGupta — Wed, 07 Feb 2018 14:46:12 GMT

A quick tour of registering and unregistering data as versioned—ArcGIS Help | ArcGIS Desktop

Check for any known limitations...

Re: Annotation Class (SDE)

Asrujit_SenGupta — Thu, 08 Feb 2018 04:45:27 GMT

Well, I checked again once, and Registering as Versioned, should not make those options Grayed Out.

As I suggested earlier, try the below:

Is the data in that Feature Dataset consumed in any services? Maybe a Lock is preventing?
If you make sure that there are no connections to the Geodatabase and then try, does it help?

Re: Annotation Class (SDE)

shan_sarkar — Thu, 08 Feb 2018 06:32:33 GMT

Dan,

Since you are able to create annotations for the data residing in a file geodatabase,I just wanted to confirm a few things:

What is the License level for ArcGIS Desktop?
Did you create a map annotation or an annotation feature class?
The feature class residing in the enterprise database, is it already participating in any complex relationship (e.g. Network dataset, Geometric dataset.

Regards,

~Shan

Re: Annotation Class (SDE)

DanKerntop — Thu, 08 Feb 2018 18:59:55 GMT

Hello Shan,

1. What is the License level for ArcGIS Desktop? 10.5.1

2. Did you create a map annotation or an annotation feature class? Annotation feature class in SDE

3. The feature class residing in the enterprise database, is it already participating in any complex relationship (e.g. Network dataset, Geometric dataset. Yes, it is part of a Network dataset with simple and complex edges, etc. I may try moving the annotation feature to a separate feature dataset without the network….

Regards,

Dan Kerntop

GIS Analyst

City of Wausau

Dept of Public Works

407 Grant St

Wausau, WI 54403

City of Wausau

Office: (715) 261-6757

Learn more about

the City of Wausau at:

www.ci.wausau.wi.us<http://www.ci.wausau.wi.us/>

Re: Annotation Class (SDE)

ThomasColson — Thu, 08 Feb 2018 21:04:45 GMT

My knee jerk answer as that you have an orphan schema lock. In db admin, go to connections, and kill them all (like Pokemon). My second knee jerk answer is...can you post a screen shot(s) of exactly what/how you're trying the operation? You may be in a known limitation....

Re: Annotation Class (SDE)

shan_sarkar — Fri, 09 Feb 2018 06:00:57 GMT

1. What is the License level for ArcGIS Desktop? 10.5.1
2. Did you create a map annotation or an annotation feature class? Annotation feature class in SDE
3. The feature class residing in the enterprise database, is it already participating in any complex relationship (e.g. Network dataset, Geometric dataset. Yes, it is part of a Network dataset with simple and complex edges, etc. I may try moving the annotation feature to a separate feature dataset without the network….

License level would mean (Basic, Standard, Advanced) 10.5.1 is the version of the product.

The annotation that you are trying create are they feature linked annotations?

~Shan

Re: Annotation Class (SDE)

DanKerntop — Mon, 12 Feb 2018 12:59:19 GMT

1. 10.5.1

2. Feature class anno

3. It doesn’t seem to matter if it’s in a network

Also, when I turn off ArcGis Server, then I can make changes to the feature class anno properties..

Dan

Re: Annotation Class (SDE)

DanKerntop — Mon, 12 Feb 2018 14:07:08 GMT

The desktop and license manager are running 10.5.1

It doesn’t seem to matter if the anno feature class is in a geometric network or not. When I stop running ArcGIS Server it allows me to change the anno classes in the anno feature class. I just don’t want to have to stop ArcGIS Server to make changes. Schema locks are bad enough withit.

Thanks for your Reply,

Dan

Re: Annotation Class (SDE)

DanKerntop — Mon, 12 Feb 2018 14:09:32 GMT

Thanks for your reply,

The desktop and license manager are running 10.5.1

It doesn’t seem to matter if the anno feature class is in a geometric network or not or if it is verstioned-those things don’t seem to matter. However, when I stop running ArcGIS Server it allows me to change the anno classes in the anno feature class. I just don’t want to have to stop ArcGIS Server to make changes. Schema locks are bad enough in ArcGIS.

Regards,

Dan

Re: Annotation Class (SDE)

DanKerntop — Mon, 12 Feb 2018 14:14:20 GMT

Yes, a lock is consuming it. When I stop running ArcGIS Server it allows me to change the anno classes in the anno feature class. I just don’t want to have to stop ArcGIS Server to make changes. Schema locks are bad enough with it. So, will I have to stop my web services every time I edit anno classes in my properties?!

Thanks for your Reply,

Dan

Re: Annotation Class (SDE)

ThomasColson — Mon, 12 Feb 2018 15:17:24 GMT

I may be wrong, but it is not possible to make schema changes while ArcGIS Server has an instance open on the feature class, despite unchecking "Maintain Schema Lock" on the service properties. You may have to consider a workflow that does not involve use of ArcGIS Server, or plan your schema changes during times of no or low service use.

Re: Annotation Class (SDE)

Asrujit_SenGupta — Mon, 12 Feb 2018 15:27:02 GMT

Connect as the Data Owner for that Anno, check locks on that particular Anno FC and disconnect only those locks. See if that hampers your other workflow\data\service and implement if you find it satisfactory.

As Thomas mentioned, you can never change the schema of a data, without an Exclusive lock on it.