Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
Error Code 300... |
Tue, Aug 23 2022 12:02 AM | Permanent Link |
Ian Branch | Hi Team,
What sort of actions would cause this?? "Cannot lock the database DBiWorkflow for shared access" at Open Database?? Regards, Ian |
Tue, Aug 23 2022 2:20 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
From the manual EDB_ERROR_LOCK (300) Cannot lock <ObjectType> <ObjectName> for <AccessType> accessThis error is raised whenever ElevateDB cannot obtain the desired lock access to a given object. This is usually due to another session already having an incompatible lock on the object already. Please see the Locking topic for more information. I think from other posts it usually along the lines of changing the DB path or something in the config. Exactly what I don't know Roy Lambert |
Tue, Aug 23 2022 6:03 AM | Permanent Link |
Ian Branch | Hi Roy,
Yes, I read that, and the reference. Didn't make me any the wiser.. Ian |
Tue, Aug 23 2022 8:03 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
Well, if you haven't attained wisdom by your age I'd suggest givig up Mind you I doubt my comment clarified things at all. Is there anything in the system error log? Looking at your latest download it expands the reason a bit - still not much use: Cannot lock the table ChangesLog in the schema Default for shared access and the function is given as Open Table One reason for not being able to open a table as shared is that its opened elsewhere as exclusive - something to have a look for. Roy Lambert |
Tue, Aug 23 2022 1:17 PM | Permanent Link |
Ian Branch | Hi Roy,
I wouldn't be so concerned/interested if it was just 'Open Table', but this was 'Open Database'. |
Wed, Aug 24 2022 2:22 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
What operations does your application carry out that requires exclusive access to the database? Since I do not know what they are I'd guess at anything that updates the Information or Configuration database (massively wide target so I'm pretty sure to hit it). It could just be a timing issue (two or more users trying to do the same thing at the same time), I think I remember people having this when just trying to log on Just done a search for 300 in the subject of these ngs - 213 matches. How about this thread From: Michael Fullerton <fullerm@spamkiller-remove-cybermatrix.com> Newsgroups: elevatesoft.public.elevatedb.general Subject: Elevate DB Error #300 Date: Fri, 22 Jun 2007 08:58:25 -0700 Message-ID: <2asn73dqsub0j7j6s7h0vv5di57ajt9bl0@4ax.com> and the FAQ https://www.elevatesoft.com/supportfaq?action=view&category=edb&question=cannot_lock_database Roy Lambert |
Wed, Aug 24 2022 11:07 PM | Permanent Link |
Ian Branch | Hi Roy,
"What operations does your application carry out that requires exclusive access to the database?" Well I don't know what operations would lock the Database as opposed to a tbale. I will have a look at the references you supplied.... I'm thinking it is some aberration in the Server PC. It happened on and of for a day and hasn't happened since. Equally, it hadn't happened for two months. Back then it was only for a period in a day too. Strange. It is a Windows 2012 Server. Regards, Ian |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |