Permlink Replies: 3 - Last Post: Nov 9, 2009 3:06 PM Last Post By: Paul Gunn Threads: [ Previous | Next ]
pauwels.e@pg.com

Posts: 25
Registered: 05/14/06
Error 109: An error occured in the database.
Posted: Nov 6, 2009 9:42 AM
  Click to reply to this thread Reply
Attachment VaultLog.txt (17.5 KB)
We have 2 vaults. I can drag/drop a file in one vault, but when I do the same in the other it gives this error 109.
Do we have a tool to check the vault database integrity? log file attached
Paul Gunn
Re: Error 109: An error occured in the database.
Posted: Nov 6, 2009 7:25 PM   in response to: pauwels.e@pg.com in response to: pauwels.e@pg.com
  Click to reply to this thread Reply
Hi,

The error seems to indicate that SQL doesn't have adequate disk space to
grow the database. You may need to free up some space on the drive SQL is
installed on.

Paul Gunn
pauwels.e@pg.com

Posts: 25
Registered: 05/14/06
Re: Error 109: An error occured in the database.
Posted: Nov 6, 2009 9:00 PM   in response to: Paul Gunn in response to: Paul Gunn
  Click to reply to this thread Reply
Thanks Paul,

the problem was auto growth in SQL, for some bizar reason it was set to 12800% ?!
I tried to change it to 100MB, but from the moment I clicked on it an error message popped up.
I finaly managed to fix it by using the command prompt.
Paul Gunn
Re: Error 109: An error occured in the database.
Posted: Nov 9, 2009 3:06 PM   in response to: pauwels.e@pg.com in response to: pauwels.e@pg.com
  Click to reply to this thread Reply
Looks like this is a known SQL defect - apparently fixed in SQL server SP2:

http://www.eggheadcafe.com/software/aspnet/31537760/corrupt-auto-grow-value.aspx

Glad to hear you found a way to reset the growth setting.

Paul