Error: -2147217900: Could not allocate space for object PVDM_SECTRACKGEN_1

Description


Users receive the following error when attempting to login to PaperVision Enterprise: Error: -2147217900 - Could not allocate space for object PVDM_SECTRACKGEN_1 in database PAPERVISIONDM because the 'PRIMARY' filegroup is full. (Source: LoginUserEx2.LoginUser.

EntAddSecTrackGeneral.EntAddSecTrackGeneral.Microsoft)

 

Summary


This error message usually indicates that the PaperVision database has reached its size limitation within its filegroup. The indication from the error is that the 'PRIMARY' filegroup (or any other named filegroup) is full, which could just mean that your SQL administrator needs to increase the size of your filegroup. However, this error is typically encountered in MSDE2000 and SQL Server Express editions of SQL database server, because they have size limitations as follows: MSDE2000 Installations can be no larger than 2 GB. SQL Server 2005/2008 Express installs can be no larger than 4 GB. SQL Server 2008 R2 Express can be no larger than 10 GB.

To resolve this follow the steps below:

If using SQL Server 2005/2008 Express

  1. Create a Full Backup of your SQL Database.
    1. In SQL Management Studio Express, right click the physical database, select tasks, and Backup.
    2. Select options accordingly, but make sure you do a Full Backup.
  2. Shrink existing database.
    1. Right click the physical database, select tasks, and shrink.
  3. Attempt to login to PVE. If the DB is unable to be shrunk to an acceptable size, upgrading to a newer or full version of SQL Server will be required.

If using MSDE2000

  1. Backup the existing database located at C:\Program Files\Microsoft SQL Server\MSSQL (file names may vary).
  2. An upgrade to an express version of SQL is required, which will allow for a bigger Database (4-10 GB).
    1. Download and install SQL Server Express with Management Studio from Microsoft.com. Note that Digitech carries SQL Express on the ISO of the most recent version of PaperVision Enterprise, which can be found on MYDSI.
  3. After installation is completed, attach the MSDE database to the new installation.
    1. The options to attach can be found in the context (right click) menu of the “Databases” folder inside of Management Studio.
    2. Select the Add button, and browse the location of your .MDF file. (Database)

Consider upgrading to a full version of SQL. This will alleviate any future problems with database size limitations.

 

Note:

Always make a Full Backup of any SQL Database and/or files associated with your database prior to making changes or upgrading the database server.

 

Filed under PaperVision® Enterprise, R70

Last modified May 12, 2010

Submitted May 12, 2010

Related Articles

Share via Email Print