Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Can't alter a table with C/S
Sun, Aug 14 2011 6:49 PMPermanent 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 AMPermanent 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 AMPermanent Link

Fernando Dias

Team Elevate 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 PMPermanent 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 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Allan,

So much detail and yet my answer was wrong , haha.
Anyway, it could be right Smiley You said there were no active connections...

--
Fernando Dias
[Team Elevate]
Mon, Aug 15 2011 8:50 PMPermanent Link

Allan Roberts

Fernando Dias wrote:

Allan,

So much detail and yet my answer was wrong , haha.
Anyway, it could be right Smiley 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Fernando,

<< So much detail and yet my answer was wrong , haha. >>

Story of my life. Wink

--
Tim Young
Elevate Software
www.elevatesoft.com
Image