APPS:Releasing a Locked Call: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
1..Run the SupportWorks Interactive SQL program (Start->Programs->Hornbill Core Services->Interactive SQL.) | 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') | 2..Enter the following SQL, replacing 12345 with the appropriate call reference (numerical part only disregard the initial 'F00') | ||
Use Sw_systemdb; [RETURN] | Use Sw_systemdb; [RETURN] | ||
Delete from Opencall_Locks where callref = 12345; [RETURN] | Delete from Opencall_Locks where callref = 12345; [RETURN] | ||
Revision as of 15:41, 5 February 2016
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] 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).