Latest Contributions by LinkElmore

I am interested in learning a method to identify open edit sessions for users connected to a SQL/SDE database.  Using SQL Management Studio, it is possible to examine the sde_object_locks table.  However, I am unsure if this reflects merely a lock from a user with edit privileges who is connected to their version or if it additionally means they are in an active edit session.  My interest is in being able to disconnect users to perform db maintenance without risking the possibility of data loss if they are in an active edit session. ... View more

I need to disconnect users periodically to conduct geodatabase maintenance and programmatically update feature classes, but do not want to risk losing data when it is being actively edited or when a user may have edits in an open version that has not yet been posted. Esri advises against disconnecting active sessions: Manage geodatabase locks—Help | ArcGIS for Desktop Use caution when disconnecting users. Esri recommends that you avoid disconnecting active sessions, especially if the connected user is in the process of editing. You should only disconnect users to drop locks if a session was left open even when not being used (for example, over the weekend), if a session is orphaned and locking an object, or if a deadlock situation occurs. It's pretty clear that being in an edit session is "in the process of editing".  However, what is less clear how this prohibition applies to open versions not in an active edit session but with edits that have not yet posted to their parent version (dbo).  If I disconnect a user with their unposted version open and then run maintenance actions like Compress, Analyze Datasets, and Rebuild Index, do I risk losing the data in their version? It's easy to see what users are currently connected to an enterprise geodatabase.  The following article details the process of using either ArcCatalog or ArcPy to list users. Manage connections in SQL Server—Help | ArcGIS for Desktop How to identify the nature of the connection?  It's all in the lock type.  The following article details the three types of locks: schema, state, and version. Geodatabase locks—Help | ArcGIS for Desktop The above article states that version locks indicate an active edit session.  State locks are when a version is simply open.  Clearly, disconnecting a session with a version lock risks data loss.  However, is the same true for State locks? ... View more

Question: What tool or set of tools in modelbuilder can be used to edit values in the field of an Esri table using the in_memory workspace? My basic task is to pass two user supplied parameters (Lat and Long as doubles) to the XY EVENT LAYER tool, which requires a table as input.  I don't want to write out a table to disk for every time this process runs so I am hoping to use the in_memory workspace option for the CREATE TABLE tool. I have tried using CALCULATE FIELD, referencing the relevant field from the in_memory table to pass the user supplied values (doubles). The tool runs fine but no output is written to the fields of the in_memory table, therefore nothing passes down the line to the XY EVENT LAYER tool and I get no geometry for output. Is it possible to write to an in_memory table in this way?  Any suggestions on a simpler way to work this problem? Thanks. ... View more

I have a situation where I need to delete a license that has been checked out from a license server, without access to that server. Our organization made a change in license server and ArcMap version.  Some users had a license checked out from the old server, now unavailable.  They are now pointing to the new license server and unable to get a new license checked out because of the existing license on their machine from the old server.  Normally, I would just check it back in to the old one, then point to the new server and get a new license. But the old server is no longer accessible. A successful strategy has been to simply let the old license expire and then check out from the new server.  However, I need to be able to force this process early for some users who will be in the field and without access to the new server when their license expires. Can I delete the checked out version of their license on their local machine? Windows 7 ArcMap 10.3 FlexNet license server C:\ProgramData\FLEXnet contains a ARCGIS_0038ce00_tsf.data file that I suspect, but have been unable to confirm, might be the correct file to delete. Has anyone experienced this or a similar situation? ... View more

Is it possible to change ownership, either in SQL Management Studio or ArcCatalog, of a feature class created by a non-sysadmin user, to the default (dbo) schema? I am using SDE 10.3 and SQL 2008 R2.  Users authenticate via Operating System Auth (Windows Active Directory). I have a number of users who need to be able to create new feature classes but our security policy permits only server admins to have sysadm rights on SQL, therefore any feature classes created by non-sysadmin are named and owned by that user, even if they are given dbo as their default schema in SQL.  The resulting feature class name is "[database].[domain].[user].[featureclass]" rather than the desired [database].DBO.[featureclass].  I would like to allow my users to create the feature class under their account and then use my sysadmin account to change ownership to DBO so as to be available to all enterprise users under the default schema. I have tried simply editing the dbo.SDE_table_registry table in SQL to change the owner to DBO, but when I do, ArcCatalog no longer displays the feature class (under either name).  Clearly, this is not the only place where the owner is being stored in the SDE tables. Does anybody know of a way to effect this ownership change, or a different workflow that would allow non-sysadmin role users to create new features as DBO? ... View more