KB Article #72600

"Record locked by another user" when trying to update an object in Gateway Navigator

Problem

-- 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