Inability to check in or add files to the Vault

Issue

You have installed the Autodesk Data Management Server and Vault clients and used them successfully. However, after some time, you were no longer able to check out or add any new files to the Vault. 

In Autodesk Inventor®, you received the following error: 

Error 0: Unspecified Error

In Vault Explorer, you received the following error message:

A problem occurred while attempting to check-out file 'filename.ext' from the server. Would you like to continue checking out any remaining files? The server returned the following information: Unknown Server Error.

However, you were able to log on and perform the Get Latest Version of Files command without any errors occurring.

Solution

This issue occurs if the Vault database has reached the 2 GB limit imposed by Microsoft® SQL Server 2000 (Desktop Edition) or MSDE, or the 4 GB limit imposed by Microsoft SQL Server 2005 Express Edition.

To resolve this issue, you will need to upgrade to either Microsoft SQL Server 2000 Standard or Microsoft SQL Server 2000 Enterprise Edition if you are using Microsoft SQL Server 2000 Desktop Edition. If you are using Microsoft 2005 Express Edition, you will need to upgrade to Microsoft SQL Server 2005 Workgroup, Standard, or Enterprise Edition.

Note: Microsoft SQL Server 2005 Editions are only supported in Autodesk® Vault 5, Autodesk Productstream™ 5, Autodesk Vault 2008, and Autodesk Productstream 2008. Previous versions of Autodesk Vault and Autodesk Productstream do not support any version of Microsoft SQL Server 2005.

To confirm that the 2GB (or 4GB) limit has been reached, you can use one of the following methods:

Method 1 - Verify the size of the Vault database (MDF file)

1. In Windows Explorer, navigate to the following directory:
   
   C:\Program files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Data 
   
   Note: If you have moved the Vault databases, browse to the folder where your databases are now located.
   
2. Check the file size on disk and make sure it is not close to the 2GB limit (or 4GB limit, if using Microsoft SQL Server 2005 Express Edition).

Method 2 - Review server-side Vault logs

1. In Windows Explorer on the Vault Server computer, browse to the following folder:
   
   C:\Documents and Settings\All Users\Application Data\Autodesk\VaultServer\FileStore
   
   
2. Open the most recent vlog-YYYYMMDD.txt file (where YYYYMMDD stands for the date when the log file was created) with Notepad or another text editor.
3. Check to see whether the file contains the following entry:
   
   System.Data.SqlClient.SqlException: Could not allocate space for object 'FileIteration' in database 'Vault' because the 'PRIMARY' filegroup is full

Method 3 - Review SQL Error logs

1. In Windows Explorer, browse to the following folder:
   
   C:\Program Files\Microsoft SQL Server\MSSQL$AUTODESKVAULT\Logs
   
   
2. Open the most recent SQL error log file with Notepad or another text editor. If your database is at the limit, you will find the following entries in the log file:
   
   2005-05-27 08:11:33.98 spid53   
CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.

2005-05-27 08:11:34.01 spid53   
Error: 1105, Severity: 17, State: 2

2005-05-27 08:11:34.01 spid53   
Could not allocate space for object 'FileIteration' in database 'Vault' because the 'PRIMARY' filegroup is full.