nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error / Crash when Viewing Enterprise Database Locks

mpboyle

Does anybody else have an issue where when trying to view enterprise locks, Pro displays the errors below and crashes?

This doesn't happen on all our enterprise databases, just certain ones. Is there something specific in the database to look for where this is happening?

System Information:

Pro version: 2.2.2

RDBMS: Sql Server 2014 Standard

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

Javier_AntonioEscudero

Thanks Matthew,

Your sql script worked very well for me. After delete orphaned lock records from tables locks, error 'Colum value is' dissapears from Administration Locks Menu.

Regards,

Javier Escudero

mpboyle

Jonathan Farmer‌

Those 2 highlighted ProcessID values do NOT exist within the SDE_process_information table (first screenshot)
The engDustControl feature class DOES still exist
These 2 locks DO show in the Administer Geodatabase window if using an older version of ArcMap (10.3) (highlighted blue in second screenshot)

JonathanFarmer_oldaccount

Hi Matt,

Just to confirm, the ProcessID for those 2 table locks does not exist in the process_information table? Does the ENGDUSTCONTROL feature class still exist in the database? This lock does not show up in the Geodatabase Administration dialog in ArcMap?

We certainly don't want to go deleting everything from the locks table as some of those are valid locks. Actually, we never want to delete anything from the database but it does sound like you may have a couple of orphans here.

My recommendation would be to take a full backup of this database and restore it into another SQL instance. This way no other users are connected or will connect and there are no services or replicas hitting this geodatabase. You can then make sure that no locks or connections exist in the Geodatabase Administration dialog in ArcMap and also that the SDE_Process_Information table is empty. Once that is done, if the 2 locks for ENGDUSTCONTROL are still present, you can remove them from the SDE_Locks table in the database. Then get back into ArcMap and test to see if the errors are still present.

But you may very well be running into that bug I mentioned and this isn't an issue of orphaned locks. If that is the case, this workflow above won't help. Also feel free to open a case with Support as we can work with you more closely and take a database backup in house to go through these workflows before we ask you to do them yourself to make sure they work on our end. Something to consider.

Jonathan

mpboyle

I put together some queries in Sql Server to try and locate the orphaned locks, so I could hopefully narrow down which specific records are the issue, and what table they are located within.

Below is a screenshot of the end result query showing there seem to be 2 orphaned lock records within the SDE_table_locks table. The sde_id value found in the SDE_table_locks table is NOT found within the SDE_process_information table ... therefore resulting in NULL values for the Lock Owner.

Is it safe to assume, these are the only 2 records that need to be removed, rather than deleting all records within all the lock tables and SDE_process_information table?

Below is the entire Sql statement, which takes into account all the '_lock' tables (what is shown above is a small sample returned). Perhaps this is useful to others when trying to locate specific records rather than deleting all records within these tables.

You can add the where clause below to the end of the query to filter ONLY the orphan records (if any). The LockTable field should point you to the table where the orphans are found, with the ProcessID value equaling the sde_id value of the orphans.

<SPAN class="keyword token">WHERE</SPAN> ProcessIDFound <SPAN class="operator token">=</SPAN> <SPAN class="string token">'N'</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

FYI --- this query does not translate topology and geometric network tables names, they will be returned as stored in the database (ex: T_1_DirtyArea, T_1_PointErrors, etc...)

**Note: you may need to adjust schema names**

<SPAN class="keyword token">SELECT</SPAN> <SPAN class="operator token">*</SPAN>
<SPAN class="keyword token">FROM</SPAN> <SPAN class="punctuation token">(</SPAN>

<SPAN class="comment token">/* STATE LOCKS */</SPAN>

<SPAN class="keyword token">SELECT</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'SDE_state_locks'</SPAN> <SPAN class="keyword token">AS</SPAN> LockTable<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ProcessID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'N'</SPAN> <SPAN class="keyword token">ELSE</SPAN> <SPAN class="string token">'Y'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> ProcessIDFound<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>state_id<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> s<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>state_id<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'N'</SPAN> <SPAN class="keyword token">ELSE</SPAN> <SPAN class="string token">'Y'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignIDFound<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'SDE_states'</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignTable<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CAST<SPAN class="punctuation token">(</SPAN>s<SPAN class="punctuation token">.</SPAN>state_id <SPAN class="keyword token">AS</SPAN> NVARCHAR<SPAN class="punctuation token">(</SPAN><SPAN class="number token">255</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> ObjectName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'Version'</SPAN> <SPAN class="keyword token">AS</SPAN> ObjectType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'state'</SPAN> <SPAN class="keyword token">AS</SPAN> LockType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>owner<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> LockOwner<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> l<SPAN class="punctuation token">.</SPAN>lock_type <SPAN class="keyword token">WHEN</SPAN> <SPAN class="string token">'S'</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'shared'</SPAN> <SPAN class="keyword token">WHEN</SPAN> <SPAN class="string token">'E'</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'exclusive'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> LockMode<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>lock_time<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> DateAcquired<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUBSTRING<SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> CHARINDEX<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN> <SPAN class="punctuation token">,</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> MachineName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">RIGHT</SPAN><SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">LEN</SPAN><SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> CHARINDEX<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN><SPAN class="punctuation token">,</SPAN> p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> GISVersion
<SPAN class="keyword token">FROM</SPAN>
<SPAN class="comment token">--state locks</SPAN>
dbo<SPAN class="punctuation token">.</SPAN>SDE_state_locks <SPAN class="keyword token">AS</SPAN> l
<SPAN class="comment token">--process information</SPAN>
<SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> dbo<SPAN class="punctuation token">.</SPAN>SDE_process_information <SPAN class="keyword token">AS</SPAN> p <SPAN class="keyword token">ON</SPAN> l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">--states</SPAN>
<SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> dbo<SPAN class="punctuation token">.</SPAN>SDE_states <SPAN class="keyword token">AS</SPAN> s <SPAN class="keyword token">ON</SPAN> l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>state_id<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN>s<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>state_id<SPAN class="punctuation token">]</SPAN>


<SPAN class="keyword token">UNION</SPAN> <SPAN class="keyword token">ALL</SPAN>


<SPAN class="comment token">/* TABLE LOCKS */</SPAN>

<SPAN class="keyword token">SELECT</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'SDE_table_locks'</SPAN> <SPAN class="keyword token">AS</SPAN> LockTable<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ProcessID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'N'</SPAN> <SPAN class="keyword token">ELSE</SPAN> <SPAN class="string token">'Y'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> ProcessIDFound<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>registration_id<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> t<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>registration_id<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'N'</SPAN> <SPAN class="keyword token">ELSE</SPAN> <SPAN class="string token">'Y'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignIDFound<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'SDE_table_registry'</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignTable<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">--t.[database_name] + '.' + t.[owner] + '.' + t.[table_name] AS ObjectName,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; t<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>table_name<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ObjectName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'Dataset'</SPAN> <SPAN class="keyword token">AS</SPAN> ObjectType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'schema'</SPAN> <SPAN class="keyword token">AS</SPAN> LockType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>owner<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> LockOwner<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> l<SPAN class="punctuation token">.</SPAN>lock_type <SPAN class="keyword token">WHEN</SPAN> <SPAN class="string token">'S'</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'shared'</SPAN> <SPAN class="keyword token">WHEN</SPAN> <SPAN class="string token">'E'</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'exclusive'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> LockMode<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>lock_time<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> DateAcquired<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUBSTRING<SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> CHARINDEX<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN> <SPAN class="punctuation token">,</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> MachineName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">RIGHT</SPAN><SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">LEN</SPAN><SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> CHARINDEX<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN><SPAN class="punctuation token">,</SPAN> p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> GISVersion&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<SPAN class="keyword token">FROM</SPAN>
<SPAN class="comment token">--table locks</SPAN>
dbo<SPAN class="punctuation token">.</SPAN>SDE_table_locks <SPAN class="keyword token">AS</SPAN> l
<SPAN class="comment token">--process information</SPAN>
<SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> dbo<SPAN class="punctuation token">.</SPAN>SDE_process_information <SPAN class="keyword token">AS</SPAN> p <SPAN class="keyword token">ON</SPAN> l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">--table registry</SPAN>
<SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> dbo<SPAN class="punctuation token">.</SPAN>SDE_table_registry <SPAN class="keyword token">AS</SPAN> t <SPAN class="keyword token">ON</SPAN> l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>registration_id<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN>t<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>registration_id<SPAN class="punctuation token">]</SPAN>


<SPAN class="keyword token">UNION</SPAN> <SPAN class="keyword token">ALL</SPAN>


<SPAN class="comment token">/* OBJECT LOCKS */</SPAN>

<SPAN class="keyword token">SELECT</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'SDE_object_locks'</SPAN> <SPAN class="keyword token">AS</SPAN> LockTable<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ProcessID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> p<SPAN class="punctuation token">.</SPAN>sde_id <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'N'</SPAN> <SPAN class="keyword token">ELSE</SPAN> <SPAN class="string token">'Y'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> ProcessIDFound<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>object_id<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> v<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>version_id<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'N'</SPAN> <SPAN class="keyword token">ELSE</SPAN> <SPAN class="string token">'Y'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignIDFound<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'SDE_versions'</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignTable<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>owner<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'.'</SPAN> <SPAN class="operator token">+</SPAN> v<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>name<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ObjectName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'Version'</SPAN> <SPAN class="keyword token">AS</SPAN> ObjectType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'version'</SPAN> <SPAN class="keyword token">AS</SPAN> LockType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>owner<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> LockOwner<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> l<SPAN class="punctuation token">.</SPAN>lock_type <SPAN class="keyword token">WHEN</SPAN> <SPAN class="string token">'S'</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'shared'</SPAN> <SPAN class="keyword token">WHEN</SPAN> <SPAN class="string token">'E'</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'exclusive'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> LockMode<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>lock_time<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> DateAcquired<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUBSTRING<SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> CHARINDEX<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN> <SPAN class="punctuation token">,</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> MachineName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">RIGHT</SPAN><SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">LEN</SPAN><SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> CHARINDEX<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN><SPAN class="punctuation token">,</SPAN> p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> GISVersion
<SPAN class="keyword token">FROM</SPAN> 
<SPAN class="comment token">--object locks</SPAN>
dbo<SPAN class="punctuation token">.</SPAN>SDE_object_locks <SPAN class="keyword token">AS</SPAN> l
<SPAN class="comment token">--process information</SPAN>
<SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> dbo<SPAN class="punctuation token">.</SPAN>SDE_process_information <SPAN class="keyword token">AS</SPAN> p <SPAN class="keyword token">ON</SPAN> l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token">--versions</SPAN>
<SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> dbo<SPAN class="punctuation token">.</SPAN>SDE_versions <SPAN class="keyword token">AS</SPAN> v <SPAN class="keyword token">ON</SPAN> l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>object_id<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN>v<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>version_id<SPAN class="punctuation token">]</SPAN>


<SPAN class="keyword token">UNION</SPAN> <SPAN class="keyword token">ALL</SPAN>


<SPAN class="comment token">/* LAYER LOCKS */</SPAN>

<SPAN class="keyword token">SELECT</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'SDE_layer_locks'</SPAN> <SPAN class="keyword token">AS</SPAN> LockTable<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ProcessID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'N'</SPAN> <SPAN class="keyword token">ELSE</SPAN> <SPAN class="string token">'Y'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> ProcessIDFound<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>layer_id<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignID<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> <SPAN class="keyword token">WHEN</SPAN> y<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>layer_id<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'N'</SPAN> <SPAN class="keyword token">ELSE</SPAN> <SPAN class="string token">'Y'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignIDFound<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'SDE_layers'</SPAN> <SPAN class="keyword token">AS</SPAN> ForeignTable<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; y<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>database_name<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'.'</SPAN> <SPAN class="operator token">+</SPAN> y<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>owner<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'.'</SPAN> <SPAN class="operator token">+</SPAN> y<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>table_name<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> ObjectName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'Layer'</SPAN> <SPAN class="keyword token">AS</SPAN> ObjectType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'layer'</SPAN> <SPAN class="keyword token">AS</SPAN> LockType<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>owner<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> LockOwner<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">CASE</SPAN> l<SPAN class="punctuation token">.</SPAN>lock_type <SPAN class="keyword token">WHEN</SPAN> <SPAN class="string token">'S'</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'shared'</SPAN> <SPAN class="keyword token">WHEN</SPAN> <SPAN class="string token">'E'</SPAN> <SPAN class="keyword token">THEN</SPAN> <SPAN class="string token">'exclusive'</SPAN> <SPAN class="keyword token">END</SPAN> <SPAN class="keyword token">AS</SPAN> LockMode<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>lock_time<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">AS</SPAN> DateAcquired<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUBSTRING<SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> CHARINDEX<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN> <SPAN class="punctuation token">,</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> MachineName<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">RIGHT</SPAN><SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">LEN</SPAN><SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> CHARINDEX<SPAN class="punctuation token">(</SPAN><SPAN class="string token">':'</SPAN><SPAN class="punctuation token">,</SPAN> p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>nodename<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> GISVersion
<SPAN class="keyword token">FROM</SPAN>
<SPAN class="comment token">--layer locks</SPAN>
dbo<SPAN class="punctuation token">.</SPAN>SDE_layer_locks <SPAN class="keyword token">AS</SPAN> l 
<SPAN class="comment token">--process information</SPAN>
<SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> dbo<SPAN class="punctuation token">.</SPAN>SDE_process_information <SPAN class="keyword token">AS</SPAN> p <SPAN class="keyword token">ON</SPAN> l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN>p<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_id<SPAN class="punctuation token">]</SPAN> 
<SPAN class="comment token">--states</SPAN>
<SPAN class="keyword token">LEFT</SPAN> <SPAN class="keyword token">JOIN</SPAN> dbo<SPAN class="punctuation token">.</SPAN>SDE_layers <SPAN class="keyword token">AS</SPAN> y <SPAN class="keyword token">ON</SPAN> l<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>layer_id<SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN>y<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>layer_id<SPAN class="punctuation token">]</SPAN>

<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> lk‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JonathanFarmer_oldaccount

Hi Matt,

We have a bug logged for this issue and it is going to be addressed. I don't have a version that it will be fixed at yet though. We have seen this error in Desktop as well so it's not specific to Pro.

Take a look in the SDE_table_locks, SDE_layer_locks, SDE_object_locks, SDE_state_locks and SDE_process_information tables and see what is there. There may be an orphaned entry hanging things up. But do not modify anything in those tables without a full backup of your database.

BUG-000110574: The error, “Column value is null” is encountered whi..

Jonathan

mvolz47

Check out this thread as it appears to occur in both ArcMap and Pro:

https://community.esri.com/thread/206938-error-trying-to-view-locks

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.