Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    Silver Spring, Maryland
    Posts
    74

    Unanswered: 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???

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Is this disk full?

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •