Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
1005 error question |
Fri, Dec 11 2020 3:34 AM | Permanent Link |
Hershcu Sorin | Hello
When I got that error how I can find which users or what session is responsible for that locking? Thanks, Sorin |
Fri, Dec 11 2020 3:46 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Hershcu
If you're using client/server this may help https://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&msg=11682 Roy Lambert |
Fri, Dec 11 2020 4:29 AM | Permanent Link |
Hershcu Sorin | If you're using client/server this may help
https://www.elevatesoft.com/forums?action=view&category=edb&id=edb_general&msg=11682 Thanks, Roy Yes I am using client/server From the old thread, I learn about the ServerSessionLock table I query that table and it's empty. Still, I'm getting the #1005 error Any more suggestions? |
Fri, Dec 11 2020 5:12 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Hershcu
>Thanks, Roy >Yes I am using client/server >From the old thread, I learn about the ServerSessionLock table >I query that table and it's empty. Did you test it in a clean environment where you knew what was locked or are you examining live tables? >Still, I'm getting the #1005 error >Any more suggestions? Only trapping for the error and handling it gracefully. Also check for disconnected sessions that have left a lock dangling. How many users are there on the system? Roy |
Fri, Dec 11 2020 5:37 AM | Permanent Link |
Hershcu Sorin | >Only trapping for the error and handling it gracefully. Also check for disconnected sessions that have left a lock >dangling.
>How many users are there on the system? >Roy The application has a maximum of 5 users but all are logged off. Meanwhile, I solved these problems by stopping and starting the EdbSrvr service. So probably it was a lock dangling. Can I avoid it? Thanks for the support. |
Fri, Dec 11 2020 8:47 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Hershcu
If you're using pessimistic locking then you can try optimistic (which brings its own issues). With 5 users I personally would start by finding out who was doing what when the lock was found and trying to stop it happening. It may be that you have a hardware problem or the server settings need tweaking. Roy Lambert |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |