topic Re: Multiple Users Accessing Same SDE File in Data Management Questions

Multiple Users Accessing Same SDE File

Lake_Worth_BeachAdmin — Fri, 02 Dec 2016 21:07:48 GMT

I am in charge of a SDE with my Municipality with a large amount of data over 300+ separate files. I have multiple departments that have access to this SDE with multiple users in each department. No users besides myself and one other (my associate) edit any information. Everyone else is only viewing the data (in ArcMap).

My problem is that when it comes time for myself or my colleague to make edits or perform file property changes (add domains etc.) to files, the files are being used by other users (usually more than one) which cause file locks.

I want to know how I can still make these edits/ file changes while other users are still viewing the files.

I have proposed that when these file locks occur I ask the users to exit out of ArcMap the only issue is some users have very old PC's and the start-up time for these MXD's can be very long and asking them to boot off arcMap multiple times a day is not a reasonable request.

It would be ideal for me to be able to make my desired edits while other users are reading the files and these files would update for the user once they exit out and reopen the file connection to the SDE. So basically while reading the file nothing changes (even though I made edits while they had the file open) until they close arcmap and re-open it.

Any information at all regarding this topic is much appreciated!

Re: Multiple Users Accessing Same SDE File

ChrisDonohue__GISP — Fri, 02 Dec 2016 21:31:21 GMT

I don't know the exact solution (I'm not an SDE expert), but do want to pass on that at the City I am at we have many people viewing the information while others edit the data. That's one of the big advantages of an enterprise geodatabase (SDE). For example, it is very common to have dozens of people viewing our Parcel data while at the same time we have two people editing the Parcel data (in versions). Locks occasionally are a problem, but not a major issue. So the fact you are getting lock issues seems odd.

To help the SDE experts on GeoNet provide ideas, can you elaborate on the following:

Is the system structured so Default is protected?
Is it a Versioned environment?
What version of ArcGIS are you using and what enterprise geodatabase (and version)?

Geodatabase

Chris Donohue, GISP

Re: Multiple Users Accessing Same SDE File

Lake_Worth_BeachAdmin — Fri, 02 Dec 2016 21:38:11 GMT

Hello Chris,

Thank you for taking the time to look over my issue.

We are using ArcGIS 10.3.1 with a matching GeoDatabse with a SQL Server Enterprise Geodatabase.

I am not sure if the SDE is configured to be an versioned environment it was configured before I arrived here at the City (any way I can quickly figure out?)

Not sure by what you mean is 'Default protected' as well, I've only been working with the SDE for about a month or two so I am pretty new at this.

I know sometimes in order to make edits to certain files I do have to versionize them via ArcCatalog in the SDE but not for all files.

Re: Multiple Users Accessing Same SDE File

JoeBorgione — Fri, 02 Dec 2016 22:19:03 GMT

Joseph- you might want to start here: An overview of versioning—ArcGIS Help | ArcGIS for Desktop before going much farther.

Long story short, yes, you can edit data while others are viewing it, but there are a number of strategies available to you that might be appropriate. For example, I'm a big fan of database replication, and use it often to allow non-editing users to view data without posing any threat to the original, edited data. See Geodatabase replication and ArcGIS for Server—ArcGIS Help | ArcGIS for Desktop . You might also consider Arcgis Server published services as well. See What is ArcGIS for Server?—Documentation | ArcGIS for Server .

Lots of options, but do yourself a favor and get a better grip on the technology first.

Re: Multiple Users Accessing Same SDE File

ChrisDonohue__GISP — Fri, 02 Dec 2016 22:20:21 GMT

There are several factors that come into play when designing an Enterprise Geodatabase setup, with tradeoffs for each design. Here's two of them (from a non-expert's perspective).

One of the simplest designs is generally called Direct Editing (they call it Concurrent Editing in the link below). In other words, Editors directly edit the Production Data (commonly called Default). Changes are immediate to the production data. I hear it is easy to set up SDE this way, but also easy for data to get inadvertantly modified. Also, with this setup some processes will lock out users while there are being run.
Another common design is generally called Default Protected (called Multiple Projects in the link below) In this case no one can edit the Production Data (Default) directly. Instead, a child copy (version) is made of the Production database, which is then edited. This is what we use. It controls who has access to change the data and helps prevent conflicts. Changes are made to the Version, but until it is Posted the Production database (default) is not updated. This delay also allows for an opportunity to QC the data to double-check it before Posting to the Production Data (Default).

Version scenarios—ArcGIS Help | ArcGIS for Desktop

As to how to tell which design you have, I do not know. Hopefully some of the SDE Admin types will read this and reply. I suspect their are Administrative tools will quickly reveal the setup you have.

Chris Donohue, GISP

Re: Multiple Users Accessing Same SDE File

ChrisDonohue__GISP — Fri, 02 Dec 2016 22:29:20 GMT

Go with what Joe Borgione said. Learning about how SDE works will be of great aid. That said, I will admit it doesn't seem to be the easiest part of GIS to try to figure out, so if parts of it seem arcane, that is a pretty normal response. Classes in SDE are hard to come by and there doesn't seem to be a whole lot of reading material around that explains it to beginners. Luckily, we have old farts experienced SDE Administrators like Joe to help explain it.

Chris Donohue, GISP

Re: Multiple Users Accessing Same SDE File

JoeBorgione — Sat, 03 Dec 2016 01:21:19 GMT

Hey now... watch it young man...

Re: Multiple Users Accessing Same SDE File

DerekLaw — Sat, 03 Dec 2016 04:51:17 GMT

Hi Joseph,

Both Chris and Joe have posted some great info and resources. I'll add a couple more that might be slightly easier to start with than the help doc,

Hope this helps,

Re: Multiple Users Accessing Same SDE File

ModyBuchbinder — Sun, 04 Dec 2016 05:44:39 GMT

You have to understand between different types of locks. Check this: Schema locking—ArcGIS Help | ArcGIS for Desktop If many people wants to edit together the version will help you. If you want to change the schema (add a field) you need to log everybody out.

Have fun

Re: Multiple Users Accessing Same SDE File

Lake_Worth_BeachAdmin — Mon, 05 Dec 2016 13:44:57 GMT

Thank you all for the information, indeed I have much to learn about this.

I have read some of the documents you all have provided and they are already giving me a clearer picture of the setup.

I will post back here when I have came to a reasonable solution and share my resolution with you all.

Thank you all again,

Joe

Re: Multiple Users Accessing Same SDE File

Lake_Worth_BeachAdmin — Mon, 05 Dec 2016 14:01:09 GMT

I do have one more question/request.

I was not the individual who originally configured the ArcSDE, this was done a few years back and that person no longer works for us. I have digged around for awhile now and cannot figure out the workflow they are using in its configuration. I do believe we are not making edits directly to the Default.

Is there a menu prompt or something that will help me figure this out?

Re: Multiple Users Accessing Same SDE File

ChrisDonohue__GISP — Mon, 05 Dec 2016 15:50:29 GMT

Given the complexity of SDE, it may be worth a call to ESRI Support to get a perspective on your particular setup and the issues you are having.

Esri Support Contact Tech Support

Chris Donohue, GISP

Re: Multiple Users Accessing Same SDE File

Robert_LeClair — Mon, 05 Dec 2016 16:38:43 GMT

There are a few multiuser geodatabase (SDE) classes offered by Esri that may assist with the learning curve:

Deploying and Maintaining a Multiuser Geodatabase

Implementing Versioned Workflows in a Multiuser Geodatabase

Versioned Editing Workflows for the Multiuser Geodatabase

Versioning 101 Whitepaper

Hope this helps!

Robert LeClair

Esri-Denver

Re: Multiple Users Accessing Same SDE File

JoeBorgione — Mon, 05 Dec 2016 17:00:51 GMT

To view if a database is versioned, in ArcCatalog right click on the database connection and select Geodatabase Connection Properties:

Re: Multiple Users Accessing Same SDE File

DerekLaw — Mon, 05 Dec 2016 17:31:49 GMT

Hi Joseph,

Another suggestion, in ArcCatalog right click on the database connection and select Administration > Administer Geodatabase. This will open the Geodatabase Administration dialog, which shows you how many versions (if any) are in the geodatabase, as well as a tree view showing version lineages.

Some help doc on the tree view: The version tree view—ArcGIS Help | ArcGIS for Desktop

Hope this helps,

Re: Multiple Users Accessing Same SDE File

JoeFlannery — Mon, 05 Dec 2016 17:48:41 GMT

Joseph:

This is a very handy presentation from the 2016 Esri UC.

Administering Your Microsoft SQL Server Geodatabase

Create different user roles on the SQL Server side and then create different SDE Connection files for the different user types.

Re: Multiple Users Accessing Same SDE File

Lake_Worth_BeachAdmin — Mon, 05 Dec 2016 18:53:25 GMT

Thank you! This is what I was looking for.

Re: Multiple Users Accessing Same SDE File

Lake_Worth_BeachAdmin — Mon, 05 Dec 2016 18:54:02 GMT

Thank you! This is what I was looking for, it appears there are no versions and we are directly editing the Default.

Re: Multiple Users Accessing Same SDE File

Lake_Worth_BeachAdmin — Mon, 05 Dec 2016 18:57:03 GMT

So it appears we are not using any versions and users (myself and one other) are editing directly to the Default.

I have proposed we changed this to my director (he has no idea what any of this means) and i have pasted the image of the workflow diagram below, open to comments, critiques, suggested anything!

Re: Multiple Users Accessing Same SDE File

JoeBorgione — Mon, 05 Dec 2016 19:42:42 GMT

Personally I don't like multiple versions; if someone edits a feature and then someone else edits the same feature you have to make a decision as to which is correct. If that's cool with you, then that's cool; I just don't like dealing with conflicts when reconciling and posting as I'm not the guy making the edits. Would it make sense to group various versions as shown above into their own databases? For example a Water and Electric database?