Error: Could not allocate space for object ‘dbo.MSP_PROJECTS’

Environment: Project Server 2010

Background: New Project fail 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 published database had either reached its maximum size or autogrowth was not enabled.

Solution: Ask your DBA team to either set a larger max size for the Project Server Published database or enable autogrowth. It should fix the issue.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: