KB Article #72600
"Record locked by another user" when trying to update an object in Gateway Navigator
-- Trying to update the properties of an object (Remote Site, Cgate...) in Gateway Navigator results in the following error:
Record locked by another user
-- As a result, the object cannot be edited.
-- The objective of this solution is to unlock the object, to allow it being updated
Resolution
* The error is generated because another session of Gateway Navigator is trying to update the same object: had open the object for editing (Modify)
* There are multiple solutions to this problem:
Solution 1:
Ask the specific Gateway Navigator user to close the Properties Window in which the object is being updated.
or
Solution 2:
On the Gateway server kill the Navigator process that is blocking that object
a) Determine the Navigator Processes:
> netstat -anp | grep 6390
tcp 0 0 0.0.0.0:6390 0.0.0.0:* LISTEN 12285/ipelapid.sock
tcp 0 0 10.133.14.34:6390 10.133.14.235:64418 ESTABLISHED 12326/ipelapid.sock
tcp 0 0 10.133.14.34:6390 10.133.14.239:64312 ESTABLISHED 12295/ipelapid.sock
alternative command:
> ps -ef | grep ipelapid.sock
bconstan 12326 12285 0 09:38:59 - 0:00 /home/bconstan/Gateway/bin/ipelapid.sock -tpt CSTCP
bconstan 12285 1 0 Mar 08 - 0:00 /home/bconstan/Gateway/bin/ipelapid.sock -tpt CSTCP
bconstan 12295 12285 0 09:39:02 - 0:00 /home/bconstan/Gateway/bin/ipelapid.sock -tpt CSTCP
b) Kill the Navigator session. In this example the session opened from IP: 10.133.14.239 - process 12295
kill -9 12295
Note that, in this case, the process 12285 should not be killed as it was started with Gateway and it is responsible for the other client sessions.
or
Solution 3:
Restart Gateway