topic Re: How do I upgrade annotation for use in Pro? in ArcGIS Pro Questions

How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 14:44:57 GMT

I looked up in the help how to upgrade my annotation to be editable in Pro. I saw I should run the Upgrade Dataset tool (which by the way is not named correctly as I am attempting to upgrade a annotation feature class not a dataset). So far this is good until I run the tool and get a warning that says the dataset cannot be versioned. Ok, so I unregistered the dataset that the annotation feature class resides in and ran the tool again. I get the same error. The error is here: 000100: The dataset cannot be versioned.—Help | ArcGIS Desktop and is not very helpful. I understand why it would need to be unversioned but I don't know how to get rid of this error since I've already unregistered it as versioned. I'm using 2.2.1.

Re: How do I upgrade annotation for use in Pro?

MichaelVolz — Wed, 29 Aug 2018 14:54:22 GMT

Josh:

If you import an mxd to Pro that contains annotation, this process does not automatically upgrade the annotation to be able to be edited in Pro?

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 15:04:53 GMT

Nope, and I found that out the hard way. I was editing a new annotation feature class and was trying to make sure it didn't overlap an existing one created in ArcMap, I wanted to move the older annotation slightly and discovered I couldn't edit it which is how I got to this point. Check out this link.

Upgrade Dataset—Data Management toolbox | ArcGIS Desktop

Re: How do I upgrade annotation for use in Pro?

Robert_LeClair — Wed, 29 Aug 2018 15:15:26 GMT

What release of your geodatabase are you using? 10.6? 10.5? etc. In reviewing the AGP Help for upgrading ArcMap annotation to AGP annotation data models, the geodatabase has to be upgraded to the current release. Then one may run the Upgrade Dataset GP tool. If unregistering your annotation feature class as versioned using AGP does not work, try to do it in ArcMap. Then return to AGP and see if you can Upgrade the dataset. Lastly, the documentation says versioned annotation feature classes cannot be upgraded. So a few things to sort out here.

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 15:37:45 GMT

Thats odd, I thought I had already upgraded the geodatabase but its still reporting it to be 10.4.1. More hiccups as I try to upgrade the geodatabase and in both ArcMap and Pro I'm told it cant do it because something's still connected. I've gone in and removed all of the connections except the current one and it still wont work. UGH!

Re: How do I upgrade annotation for use in Pro?

Robert_LeClair — Wed, 29 Aug 2018 15:44:09 GMT

Do you have any services running referencing your Enterprise GDB? If so, shut those down and attempt the upgrade again.

Re: How do I upgrade annotation for use in Pro?

MichaelVolz — Wed, 29 Aug 2018 15:51:10 GMT

Are you upgraded to ArcMap 10.6 as that is the equivalent ArcMap version to Pro 2.2.1?

I'm a bit confused about ESRI's upgrade messages for enterprise gdbs. In ArcMap 10.5.1 I click on the Properties of an SDE database connection and is shows below so the Upgrade Geodatabase button is grayed out and not enabled:

But if I go to the Properties of an SDE database connection in Pro 2.2.1 (equivalent to 10.6) it shows below where the geodatabase is up-to-date but it should not be for Pro as 2.2.1 is equivalent to 10.6 and the SDE geodatabase is still at 10.5.1 so it should be able to be upgraded in Pro to match the version.

Robert or Kory Kramer can you explain how this is working as eventually my org will need to upgrade annotation in SDE to be able to be edited in Pro?

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 15:54:56 GMT

Yes, the services were referencing it, so I stopped them all and even rebooted my machine. I still got the same error even though the only connection listed was my current one. I have to bring my services back up as my users need them so I am at a stand still on this.

Re: How do I upgrade annotation for use in Pro?

MichaelVolz — Wed, 29 Aug 2018 15:58:55 GMT

Sounds like a tech support call.

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 16:00:13 GMT

That does appear to be my issue but as I said to Robert above, I can't get the upgrade to work even when it appears there are no connections to the database. However, in Pro right now it says 0 of 1 users connected and there is a listing in the locks list so I'm confused here.

Re: How do I upgrade annotation for use in Pro?

Robert_LeClair — Wed, 29 Aug 2018 16:11:25 GMT

This is interesting certainly. By chance are you using an application server connection vs. a direct connection to your Enterprise Geodatabase? (i.e. gsrvr.exe and giomgr.exe) If so, create a direct connection and attempt the upgrade again.

Re: How do I upgrade annotation for use in Pro?

Robert_LeClair — Wed, 29 Aug 2018 16:13:50 GMT

Just out of curiosity, if you close AGP and open ArcMap to manage your Enterprise connections, do you see the same locks in play here? If so, is it possible to disconnect those locks (without impacting other users certainly), then close ArcMap. Start AGP and attempt the upgrade again.

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 16:23:55 GMT

I've have tried it in both software suites with the same results.

Re: How do I upgrade annotation for use in Pro?

Robert_LeClair — Wed, 29 Aug 2018 16:36:24 GMT

In reviewing the Esri Support Services logs, it could be an orphaned lock in your Enterprise GDB. One workflow that fixed this for another customer is as follows:

The only possible workaround for now is to manually delete the orphan locks. To do so:
1. Make a full back up of the database
2. Make sure there are no active connections to the database of concern. (open AGP/AM sessions, Services running, etc.)
3. Run a query for the SDE_table_locks, SDE_layer_locks, SDE_object_locks, SDE_state_locks and SDE_process_information and notice if there are orphan lock entries. Or open your Enterprise Manager (Oracle) or SQL Server Management Studio (SQL Server) and open the tables referenced above to see what locks are open.
4. Delete the entries from SDE_table_locks, SDE_layer_locks, SDE_object_locks and SDE_state_locks
5. You should be able to access the geodatabase administration, locks tab on relaunching ArcGIS Pro

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 16:37:30 GMT

I think I am looking in the right place, when in the Geodatabase Administration window in Pro, the connections all have a connection type of Direct Connect.

Re: How do I upgrade annotation for use in Pro?

Robert_LeClair — Wed, 29 Aug 2018 16:43:49 GMT

The direct connect is fine and is best practice. What you need to do is view the repository tables (sde and gdb tables) using Oracles or Microsoft Management tools. What RDBMS are you using?

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 16:56:26 GMT

I may have missed a step somewhere but I tried all of that, deleting the entries in SQL but I open Pro and the connections are all still there, and deleting them doesn't help still have the error. I guess there is some setting wrong and I'll have to resort to a tech support call.

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 29 Aug 2018 16:56:47 GMT

SQL

Re: How do I upgrade annotation for use in Pro?

Robert_LeClair — Wed, 29 Aug 2018 16:59:11 GMT

Okay - so you created the backup, open SSMS, went to the correct database and view the repository tables for the 4 lock tables. Then deleted any locks in one or more of those repository tables and the issue remains? If so, then I would encourage a tech support call to get this figured out.

Re: How do I upgrade annotation for use in Pro?

JoshWhite — Wed, 12 Sep 2018 22:01:53 GMT

After several different calls to Tech Support I finally got my geodatabase to upgrade and now I can also upgrade my annotation. It had something to do with the sde user in SQL Management Studio. Its sad these days that you have to be an IT guru to do some things in GIS.

Specifically here is how my Support Analyst wrote it up:

we were able to resolve the issue after resyncing the "sde" login to the database and granting it db_owner role and then running upgrade geodatabase tool on the database. This behavior is due to an existing defect.

Here are the details of the defect:
BUG-000100778 : Upgrade geodatabase tool at 10.5 fails with error [sde_branches : Error (-96) DBMS error code: 0]

We had to also first upgrade to a 10.5 database before upgrading to 10.6.