Sunday, February 19, 2012

Could not allocate space for object .. PRIMARY filegroup is full

I am adding a lot of data to my "SQL Server database". Suddenly I get th following error:

SYMBOLGEN: Macro variable TBL resolves to SERVICE_DATA
SYMBOLGEN: Macro variable TBL resolves to SERVICE_DATA
MPRINT(MAIN): proc append base=ODS.AAK_SERVICE_DATA data=TMP.SERVICE_DATA;
NOTE: Appending TMP.SERVICE_DATA to ODS.AAK_SERVICE_DATA.
WARNING: Variable LOST_DAYS_CURR_ENLIST has different lengths on BASE and DATA files (BASE 8 DATA 4).
WARNING: Variable MI_LOST_DAYS_CURR_ENLIST has different lengths on BASE and DATA files (BASE 8 DATA 4).
NOTE: There were 287898 observations read from the data set TMP.SERVICE_DATA.
NOTE: 287897 observations added.
NOTE: The data set ODS.AAK_SERVICE_DATA has . observations and 19 variables.
ERROR: CLI execute error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object
'AAK_SERVICE_DATA' in database 'AAK_ODS' because the 'PRIMARY' filegroup is full.
NOTE: Statements not processed because of errors noted above.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE APPEND used:
real time 1:10.04
cpu time 22.86 seconds

Note I have set the automatic file growth to 10% on the SQL Server side.

Any solutions out there?Is this disk full?

Note - you should always set a max size to stop uncontrolled growth.

No comments:

Post a Comment