KB33027: "Could not allocate space for object '(SYSTEM table id: -xxxx)' in database 'db_name' because the 'PRIMARY' filegroup is full" error message occurs when attempting to upgrade MicroStrategy metadata residing on Microsoft SQL Server

SYMPTOM:
User receives the following error when attempting to upgrade a Strategy metadata residing on Microsoft SQL Server to a newer version  through Strategy Configuration Wizard.
 

Sample Code/Error
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Could not create constraint. See previous errors. Could not allocate space for object '(SYSTEM table id: -xxx)' in database 'db_name' because the 'PRIMARY' filegroup is full. The statement has been terminated.

 
It is seen that the error occurs on the following SQL statement:
 

Sql
   BEGIN TRANSACTION

   DECLARE @PKNAME_DSSMDOBJDEFN VARCHAR(255);

   DECLARE @SQL_DSSMDOBJDEFN VARCHAR(255);

   SET @PKNAME_DSSMDOBJDEFN = (SELECT name FROM sysobjects WHERE parent_obj=object_id('DSSMDOBJDEFN') and xtype='PK');

   SET @SQL_DSSMDOBJDEFN = 'ALTER TABLE DSSMDOBJDEFN DROP CONSTRAINT ' + @PKNAME_DSSMDOBJDEFN;

   EXEC (@SQL_DSSMDOBJDEFN);

   ALTER TABLE DSSMDOBJDEFN ADD PRIMARY KEY (PROJECT_ID, OBJECT_ID, DEFINITION_SEQ);

   COMMIT TRANSACTION

 
CAUSE:
The error occurs due to space limit on the Primary Data file. In Microsoft SQL Server, the primary filegroup contains the primary data file with all system objects in it (system tables, system stored procedures, extended stored procedures and so on). Each database has only one primary filegroup. The above error message indicates the drive in which the primary filegroup resides is full.
 
ACTION:
Contact your DBA to allocate enough space on the drive where the primary file resides on.
 
NOTE:
In order to successfully upgrade Strategy metadata to version a newer version, it is recommended to reserve free disk space at least twice the size of the original database file.