Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 1 of 1 total |
Error 506. Again... |
Thu, May 25 2023 6:14 PM | Permanent Link |
Ian Branch | Hi Team,
I have this code.. {code} try // while true do begin // if TEDBEngineSessionManager(DBSWhoIsOn.Handle).TryLock(1) then begin TEDBEngineSessionManager(DBSWhoIsOn.Handle).Unlock; { Session is not locked and is safe for you to use } tqServerSessions.ExecSQL; Break; // end else // Delay for the specified amount of time Sleep(500); // end; // except {code} tqServerSessions executes this.. {sql} SELECT runsum(1), * FROM Configuration.ServerSessions Group by ID order by ID {sql} Despite the TryLock/Unlock for the session manager, I still occasionally get.."ElevateDB Error #506 Cannot lock the session manager (ID: 17)." errors when tqServerSessions executes. Can I test in the sql if Configuration.ServerSessions is in use/locked? Regards & TIA, Ian |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |