Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 10 total |
problems with locked tables |
Thu, Nov 24 2011 4:30 AM | Permanent Link |
Iztok Lajovic (1) | Hello
I have a problem regarding 11013 error message. I was opening tables on one of my directories (not on local machine) and at some moment got an error 11013. I didn't think that would be a problem as all I had to do was close the process of my application which was left hanging after crash. It didn't help. In fact ... now I could not open even those .dat files that I could open few minutes before. I get 11013 message every time. All of that was happening on my (local) machine. I tried that on one other local machine and got the same result. Then I tried that on the server (physical machine) and I could open all my tables in that directory. I tried with reset of my local and server computers and that didn't do any good as well. So now I don't know who or what is holding those files locked? Is it DBISAM server or system? How to see that? How to prevent that kind of locking? I really get that message a LOT with my application. So I would like to know what to change in my application or anywhere else. Any tips on how to code your program in order to avoid such problems? What do I have to add to my code to make it more stable (regarding this error message)? thank you Sašo |
Thu, Nov 24 2011 6:54 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 1
Reading the manual for that error code gives: DBISAM_OSEACCES (11013) Access denied to table or backup file '<Name>' This error usually occurs when an attempt is made to open up a table or backup file and the operating system does not allow access to the table or backup file due to the fact that it has already been opened up exclusively by another application or the same application or a user rights issue. A table can be opened exclusively only once. It can also occur when an attempt is made to open up a table for read/write access that is in a read-only directory or on a read-only drive and not marked as read-only as an attribute. Please see the Opening Tables topic for more information. It is also possible that a table's backup files cannot be overwritten during the processing of altering the structure of a table, adding indexes to a table or deleting indexes from a table, or optimizing a table. Please see the Creating and Altering Tables, Adding and Deleting Indexes from So since you say you get it a lot in your app probably means you have problems with file rights. Roy Lambert [Team Elevate] |
Thu, Nov 24 2011 7:06 AM | Permanent Link |
Iztok Lajovic (1) | Roy Lambert wrote:
1 Reading the manual for that error code gives: DBISAM_OSEACCES (11013) Access denied to table or backup file '<Name>' This error usually occurs when an attempt is made to open up a table or backup file and the operating system does not allow access to the table or backup file due to the fact that it has already been opened up exclusively by another application or the same application or a user rights issue. A table can be opened exclusively only once. It can also occur when an attempt is made to open up a table for read/write access that is in a read-only directory or on a read-only drive and not marked as read-only as an attribute. Please see the Opening Tables topic for more information. It is also possible that a table's backup files cannot be overwritten during the processing of altering the structure of a table, adding indexes to a table or deleting indexes from a table, or optimizing a table. Please see the Creating and Altering Tables, Adding and Deleting Indexes from So since you say you get it a lot in your app probably means you have problems with file rights. Roy Lambert [Team Elevate] Thank you but... I agree. I does look like that, but I've been using this location for long time now and sharing/owner policy has not changed. I always use full control on shared directories or drives. Is there any way or tool that can show you who has exclusive rights on a certain file at that time? It would help a lot if I could see where exactly my problem lies. Sašo |
Thu, Nov 24 2011 7:39 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sašo
>Thank you but... > >I agree. I does look like that, but I've been using this location for long time now and sharing/owner policy has not changed. I always use full control on shared directories or drives. >Is there any way or tool that can show you who has exclusive rights on a certain file at that time? It would help a lot if I could see where exactly my problem lies. SysInternals (somewhere on the MS site) should have a tool that can do that, or one of the unlockers (just search for unlocker on the internet) should be able to tell you who has a file locked. Roy Lambert [Team Elevate] |
Thu, Nov 24 2011 7:59 AM | Permanent Link |
Iztok Lajovic (1) | Roy Lambert wrote:
Sašo >Thank you but... > >I agree. I does look like that, but I've been using this location for long time now and sharing/owner policy has not changed. I always use full control on shared directories or drives. >Is there any way or tool that can show you who has exclusive rights on a certain file at that time? It would help a lot if I could see where exactly my problem lies. SysInternals (somewhere on the MS site) should have a tool that can do that, or one of the unlockers (just search for unlocker on the internet) should be able to tell you who has a file locked. Roy Lambert [Team Elevate] Thank you for your support. I will definitely have to try it. Sašo |
Thu, Nov 24 2011 8:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sašo
Are you using client/server or file/server. Do you have any backup processes running? Could it be av software? Could it be a network hardware issue? Roy Lambert [Team Elevate] ps you posted this in the ElevateDB ng not the DBISAM one |
Thu, Nov 24 2011 8:52 AM | Permanent Link |
Iztok Lajovic (1) | Roy Lambert wrote:
Sašo Are you using client/server or file/server. Do you have any backup processes running? Could it be av software? Could it be a network hardware issue? Roy Lambert [Team Elevate] ps you posted this in the ElevateDB ng not the DBISAM one Oops. I apologize for posting in the wrong section. I am using client/server and for the rest of your questions I have to say that I don't know precisely. But I will have to look into that. thank you Sašo |
Thu, Nov 24 2011 9:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sašo
>Oops. I apologize for posting in the wrong section. No problem. >I am using client/server and for the rest of your questions I have to say that I don't know precisely. But I will have to look into that. If its c/s then all the file handling should be being done by the server so I'm slightly more baffled. Another thought - go on to ElevateSofts website and shove 11013 into the search and see what, if any, light that can throw on the subject. Roy Lambert [Team Elevate] |
Wed, Nov 30 2011 5:03 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Iztok,
<< I have a problem regarding 11013 error message. >> 11013 "access denied" errors are caused by incompatible file open modes at the OS level, and not specifically DBISAM locking. For example, if another process opens one the .dat files exclusively, like in the case of an anti-virus engine performing real-time scanning, then this would prevent DBISAM from opening the .dat file in shared mode and you would see such an error. You can see what files are open by starting the Computer Manager on the machine that is hosting the files (Windows 7 example): Control Panel/Administrative Tools/Computer Management/Shared Folders/Open Files Windows Server 2003/2008 has a similar management console. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Dec 1 2011 7:38 AM | Permanent Link |
Iztok Lajovic (1) | Tim,
thank you for the information. I didn't know for this option. Regards Iztok Lajovic "Tim Young [Elevate Software]" je napisal v sporoÄŤilo news:E227F8EF-87F5-4983-BB5C-15E02A14AE6B@news.elevatesoft.com ... Iztok, << I have a problem regarding 11013 error message. >> 11013 "access denied" errors are caused by incompatible file open modes at the OS level, and not specifically DBISAM locking. For example, if another process opens one the .dat files exclusively, like in the case of an anti-virus engine performing real-time scanning, then this would prevent DBISAM from opening the .dat file in shared mode and you would see such an error. You can see what files are open by starting the Computer Manager on the machine that is hosting the files (Windows 7 example): Control Panel/Administrative Tools/Computer Management/Shared Folders/Open Files Windows Server 2003/2008 has a similar management console. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, May 15, 2024 at 08:40 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |