Error: Could not Allocate Space for Object ‘dbo.MSP_PROJECTS’

Posted By Posted by: EPM Partners on April 9, 2014

EnvironmentProject Server 2010

Background: New Project failed to publish.

Error Details:

<Error><Class>2</Class><LineNumber>9</LineNumber><Number>1105</Number>

<Procedure>MSP_PUBLISH_PROJECTS_INSERT</Procedure>  <Message>  System.Data.SqlClient.SqlError: Could not allocate space for object ‘dbo.MSP_PROJECTS’.’UQ_MSP_PROJECTS_PROJ_UID’ in database ‘Prod_ProjectServer_Published’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the … 590d3019-a6a5-426a-83ff-85188bf2a3ca.

The cause of the issue is  a published database had either reached its maximum size or autogrowth was not enabled.

Solution: Ask your DBA team to either, set a larger maximum size for the Project Server published database or enable autogrowth. This should fix the issue.


Blog Posted In Blog Posted In: How to, Project Server
Blog Posted In 

Leave a Reply

Your email address will not be published.