Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 7 of 7 total |
Can't alter a table with C/S |
Sun, Aug 14 2011 6:49 PM | Permanent Link |
Allan Roberts | I have C/S 4.28, and can't restructure a table. I receive a 11013 Access
Denied error when I try to save changes, even though there are no other users logged into the server. Shouldn't no connections mean no record locking? Or if there are 'dangling locks' from an improper shutdown (I don't know of any...), is there a way to gracefully clear them? Thanks for any help. |
Mon, Aug 15 2011 6:46 AM | Permanent Link |
Jose Eduardo Helminsky HPro Informatica | Allan
My suggestion is set "Max Dead Sessions" to 0 (zero) and "Dead Session Cleanup Interval" to 15 (seconds). It will remove the dangling connections. Eduardo |
Mon, Aug 15 2011 6:54 AM | Permanent Link |
Fernando Dias Team Elevate | Allan
It's not a lock issue, it's an access rights issue, as the error message says. One of the possible causes is the anti-virus, turn it off temporarily just to be sure. The other possible and a more likely cause, is your DBISAM server trying to create temporary files, during the process of changing the structure, in a directory where the server process has no write permissions. By default the server runs under the SYSTEM account if it's running as a service, or under a user account if it's running as an application. In any of the cases, the account being used must have write permissions to the directory where the server is trying to create the temporary files. To fix this issue you may either give the account used by the server process the required write permissions to the temporary files directory (you can check what directory it being used with the Server Administration Utility) or you can set the server to use the database directory to create those files. Please take a look here, for a better explanation: http://www.elevatesoft.com/manual?action=viewprop&id=dbisam4&product=b&version=2006&comp=TDBISAMEngine&prop=CreateTempTablesInDatabase -- Fernando Dias [Team Elevate] Em 14-08-2011 23:49, Allan Roberts escreveu: > I have C/S 4.28, and can't restructure a table. I receive a 11013 Access > Denied error when I try to save changes, even though there are no other > users logged into the server. > > Shouldn't no connections mean no record locking? Or if there are 'dangling > locks' from an improper shutdown (I don't know of any...), is there a way to > gracefully clear them? Thanks for any help. > |
Mon, Aug 15 2011 4:08 PM | Permanent Link |
Allan Roberts | Fernando, Thanks for your informative and detailed reply. I discovered in dvsrvr that there was one disconnected session left over, and removed it, which allowed access to the table (I thought that I had already checked it, but apparently not). I am going to save your information, however, because I have a feeling that sooner or later, I will have a need for it. Thanks again. Fernando Dias wrote: Allan It's not a lock issue, it's an access rights issue, as the error message says. One of the possible causes is the anti-virus, turn it off temporarily just to be sure. The other possible and a more likely cause, is your DBISAM server trying to create temporary files, during the process of changing the structure, in a directory where the server process has no write permissions. By default the server runs under the SYSTEM account if it's running as a service, or under a user account if it's running as an application. In any of the cases, the account being used must have write permissions to the directory where the server is trying to create the temporary files. To fix this issue you may either give the account used by the server process the required write permissions to the temporary files directory (you can check what directory it being used with the Server Administration Utility) or you can set the server to use the database directory to create those files. Please take a look here, for a better explanation: http://www.elevatesoft.com/manual?action=viewprop&id=dbisam4&product=b&version=2006&comp=TDBISAMEngine&prop=CreateTempTablesInDatabase -- Fernando Dias [Team Elevate] Em 14-08-2011 23:49, Allan Roberts escreveu: > I have C/S 4.28, and can't restructure a table. I receive a 11013 Access > Denied error when I try to save changes, even though there are no other > users logged into the server. > > Shouldn't no connections mean no record locking? Or if there are 'dangling > locks' from an improper shutdown (I don't know of any...), is there a way to > gracefully clear them? Thanks for any help. > |
Mon, Aug 15 2011 5:18 PM | Permanent Link |
Fernando Dias Team Elevate | Allan,
So much detail and yet my answer was wrong , haha. Anyway, it could be right You said there were no active connections... -- Fernando Dias [Team Elevate] |
Mon, Aug 15 2011 8:50 PM | Permanent Link |
Allan Roberts | Fernando Dias wrote:
Allan, So much detail and yet my answer was wrong , haha. Anyway, it could be right You said there were no active connections... -- Fernando Dias [Team Elevate] Fernando, The session displayed that it was disconnected, so I didn't think it would be an issue. Only after I deleted the session was the table freed. You sent a link to something that I didn't know about before, so I still benefited. Thanks again. |
Wed, Aug 17 2011 2:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Fernando,
<< So much detail and yet my answer was wrong , haha. >> Story of my life. -- Tim Young Elevate Software www.elevatesoft.com |
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 |