ERROR: A database error has occured (FailDBInsert)

Coxy · Post by **Coxy** » Thu Aug 10, 2006 4:28 am

Hi, I'm a new user to Vault so still learning the ropes.....hope you can help.

When checking out i receive the error message in the title. I've looked in the sgvault.log and also get this:

Could not allocate space for object 'tblcheckoutlistitems' in database 'sgvault' because the 'PRIMARY' filegroup is full.

Also, i cannot "Get Latest" - the operation appears to perform as normal but no file is copied to the working directory.

I need help on this urgently as i have lots of files checked out that have been updated and am worried about checking them in and losing all the work......Anyone got any ideas?

lbauer · Post by **lbauer** » Thu Aug 10, 2006 5:40 am

Sounds like SQL Server is out of space. The database or log file might be out of disk space, or you could be using MSDE or SQL Server Express and hitting their database size limits. MSDE is 2 GB, SQL Server Express 2005 is 4 GB.

Here are some forum posts with similar issues and solutions:

http://support.sourcegear.com/viewtopic.php?t=6457
http://support.sourcegear.com/viewtopic.php?p=25999

Coxy · Post by **Coxy** » Thu Aug 10, 2006 6:00 am

Great, thanks lbauer.

I deleted some of the databases on the server that weren't required so that SQL Server had more space and it allowed me to check out.