Question: # 15
Why do I receive the error: "Failed to delete selected object(s)" when trying to delete an ArcSDE table or feature class in ArcCatalog?
Software: ArcCatalog
Version: 8.3
Platform:
Cause:
The full error message received is:
Failed to delete selected objects(s)
Lock request conflicts with an established lock
[Locked by database user: 'username' on machine: 'MACHINENAME']
Even though there is no connection to ArcSDE by the username from MACHINENAME you could receive this error message if there is a hung connection to ArcSDE that was not terminated correctly.
Answer:
Use the sdemon -o info -I users command to determine the connection that is causing the error message:
C:\>sdemon -o info -I users
ArcSDE Instance esri_sde Registered Server Tasks on TSPGIS01 at Tue Nov 11 13:14:37 2003
-------------------------------------------------------------------------
PID User Host:OS Started
----- -------- -------------------------------- ------------------------
1220 mike TSPGIS02:Win32 Tue Nov 11 13:14:19 2003
1219 tech TSPGIS01:Win32 Tue Nov 11 12:38:18 2003
Find the PID that corresponds to the username and MACHINENAME that is causing the error message. Use the sdemon -o kill -t pid command to terminate the hung connection:
C:\>sdemon -o kill -t 1219
Please enter ArcSDE DBA password:
ArcSDE Instance esri_sde Process Management on TSPGIS01 at Tue Nov 11 13:19:22 2003
-------------------------------------------------------------------------
Kill Server Task 1219? ARE YOU SURE (Y/N)?: y
You should now be able to delete the table or feature class in ArcCatalog.
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。