ArcSDE - unlocking a feature locked through WFS GetFeatureWithLock operation

MontserratMarco — Fri, 14 Sep 2012 07:19:36 GMT

Hi,

How can I unlock a feature locked with the WFS GetFeatureWithLock operation and without using the WFS Transaction operation neither waiting for the timeout. I'm using ArcGis Server 10.1.

I suppose that the lock remains in a table in the ArcSDE database until timeout. I would like to know what table(s) holds the lock and the specific sentences to be executed in order to remove it.

Thanks in advance and best regards,

Montse

Re: ArcSDE - unlocking a feature locked through WFS GetFeatureWithLock operation

MontserratMarco — Fri, 14 Sep 2012 09:02:20 GMT

Answering myself: I have seen that there is a table SDE.VERSION_1_ROW_LOCKS. When I make the GetFeatureWithLock call, a record is stored in this table and disappears after timeout.

Deleting this record is enough to unlock the feature locked by GetFeatureWithLock operation or are other SDE tables involved?

Thanks in advance for your help,
Best regards,
Montse

SQL> SELECT * FROM VERSION_1_ROW_LOCKS;

LOCK_ID                                                        OC_ID     ROW_ID       ISSUE_DA     EXP_DATE
--------------------------------------           ---------- ----------     --------       --------
{F412B54A-DE16-4BD6-87D6-73F86A2DEB13}        641       5004          14/09/12           14/09/12

topic ArcSDE - unlocking a feature locked through WFS GetFeatureWithLock operation in Data Management Questions

ArcSDE - unlocking a feature locked through WFS GetFeatureWithLock operation

Re: ArcSDE - unlocking a feature locked through WFS GetFeatureWithLock operation