Environment: Project Server 2010
Background: New Project fail to publish.
<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.