Could not allocate space for object...

Question

_{Wednesday, February 6, 2008 8:46 PM}

 

Hi since few days we are getting below error message on System Center Essential 2007 server every second in event viewer for application...

 

" Could not allocate space for object 'dbo.PerformanceData_21'.'idc_PerformanceData_21_TimeSampled' in database 'OperationsManager' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.  "

 

 

server has enough gb free space on OS and Updates partions...

Any suggestions...

All replies (7)

_{Friday, February 8, 2008 6:30 AM ✅Answered | 6 votes}

Hi Tejas,

I'd like to suggest you  increased the size of the OperationsManager database using the SQL Server Management Studio. Connect to the server running the OpsMgr Operational Database, open the server/databases, right-click on the OperationsManager database (default name) and click properties. Click on the files tab, change the MOM_DATA size to the new size and click Ok. You can validate that the change in size occurred by going back to the properties of the database.

Regards,
Eric Zhang
Microsoft Online Community Support

---

_{Thursday, February 7, 2008 8:23 AM}

Hi All,

 

The same problem for me and DB are configured to autoexpand without limits

and the server has a lot of free disk space...

"Could not allocate new page for database. There are no more pages available in filegroup"

"Could not allocate space for object in database because the filegroup is full"

 

Tnx in advance.

 

Red.

---

_{Friday, February 8, 2008 9:26 PM}

Thanks Eric,

 

We are fine now after doing steps you suggested...

 

Thanks for your time and suggestion..

Tejas

 

---

_{Monday, December 22, 2008 7:20 PM}

Hi,

I know that this is a close thread, but i'm having the same problem. I get the error "Coul not allocate space for table XXXX because the Primary Filegroup is FULL".

I already check all the options of growth and everything is OK.The Autogrowth is configured withou limitation and have above of 20GB of diskspace, so it's almost impossible that the database growth that much, because the datafiles have already assigned 15 GB and 10 of that 15 GB are free, i mean the datafile have internal freespace.

But still i'm getting this error when a DTS Package make a transfer of rows from one server to another.

The only particularity is that the table have defined a column of IMAGE Datatype. But i already check that the size of all the bulk of data is normal and pretty far from fill the datafile to its capacity and make it grow.

The solution you put here i think its not the case for me, but i wanna to know the fundations of the answer i mean, why if everything is set OK in the options this kind of behavior takes place.

I hope you could answer my doubts.

Regards!

Diaz, Cristian Andres

---

_{Sunday, September 11, 2011 8:26 AM}

Please check if you are not using SQL Express, it has a license limit of 4G per database.

---

_{Wednesday, December 18, 2013 11:29 PM}

For those having issues with 1105, you will need to edit the "database that shows up in your error 1105", in my case the database was is SystemCenterEssentials.

from with in Microsoft SQL Server Management Studio

expand Databases

right click on the DB that shows up in your error 1105 (for me = SystemCenterEssentials)

properties

edit the MOM DB as indicated with in this post.

---

_{Wednesday, July 26, 2017 9:17 AM}

Thanks Eric