Thread:Project:Support desk/Locks failing to release

Releaes prcess locks -have 6 locks- when attemnptiung to use this it fails and processes are not released.

Have been able to release in past and permissions have not changed,

SELECT L.LOCKID, ProcessType=C.NAME, ProcessName=A.NAME, L.LOCKEDBY, L.LOCKACQUIRED, L.RUNNING FROM CADIS_SYS.CO_PROCESSLOCK L JOIN CADIS_SYS.VW_ALL_PROCESSES A ON A.COMPONENTID=L.COMPONENTID AND A.GUID=L.GUID AND A.OBSOLETE = 0 JOIN CADIS_SYS.CO_COMPONENT C ON C.ID=L.COMPONENTID

Returns...

LOCKID	COMPONENTID	GUID	LOCKEDBY	LOCKACQUIRED	RUNNING 1975738	8	df49aec602f34a7983b459bea029fc70	EUROPE1\ETLServicePRD_svc	2015-01-03 05:02:27.020	1 1975740	8	66a3ed9ef403440480df05a4c27dc086	EUROPE1\ETLServicePRD_svc	2015-01-03 05:02:28.037	1 1975746	5	b95ac76360094b5fb8e13a588963fe45	EUROPE1\ETLServicePRD_svc	2015-01-03 05:02:31.580	1 1975766	0	547eb395fcf04b359821308f78525564	EUROPE1\ETLServicePRD_svc	2015-01-03 05:04:45.333	1 1975769	8	3b2ebd1e9b4943f097e173c630fcb3d6	EUROPE1\ETLServicePRD_svc	2015-01-03 05:05:39.340	1 1975770	0	9e8a4741cff7411990d0a299b1e40b34	EUROPE1\ETLServicePRD_svc	2015-01-03 05:05:41.933	1

Is unloackign just removing from this table. Nothing is currently running that woull account for these entries

Thanks

Stephen