1) sSQL := 'SELECT ID FROM Configuration.ServerSessions'
          + ' WHERE ID <> ' + inttostr(F_EDBSession.CurrentRemoteID);

2) self.F_EDBDatabase.Database := 'Configuration';
sSQL := 'REMOVE SERVER SESSION ' + p_sID;

where the p_sID is one of the values found in the above result

---

 Comments

---

The problem was caused by the population of the ServerSessions table not occurring with a lock on each session being read for status information. Therefore, it was possible for the population to not get a clean read on some user login objects that might change during the read. EDB now locks each session as it reads the session status information, which can cause delays if the session is busy with a long process, but is the only safe way to handle this situation.

---

 Resolution

---

Fixed Problem on 6/12/2011 in version 2.05 build 10

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial