Releasing a Locked Call

From support-works
Revision as of 15:05, 24 October 2018 by Pamelal (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

When a call is accessed or an action is taking place, the call is locked to give the user exclusive write access. However if a client has an inactivity timeout or experiences a failure of any kind the server will never receive a notification from the client to unlock the call in question. In order to unlock an affected call please carry out the following:

First attempt to close down the stuck session from (Administration > Manage Server Connections) if this does not work then:

1..Run the SupportWorks Interactive SQL program (Start->Programs->Hornbill Core Services->Interactive SQL.)
2..Enter the following SQL, replacing 12345 with the appropriate call reference (numerical part only disregard the initial 'F00')
Use Sw_systemdb; [RETURN]
select * from opencall_locks;
Delete from Opencall_Locks where callref = 12345; [RETURN]

Once done the offending call will no longer be locked. Should the issue still occur please restart the SwServerService (Note this will require everyone to be logged out of the system).