This content has been marked as final. Show 3 replies
In production (i.e. Not a new install), we have started getting something similar:
Exception : EprmDBSQLExecutionFailure
Type : EprmDBSQLExecutionFailure
Event Code : PRMDB-1080-0
PRM DBAccess Error: Database Server Error: Could not allocate space for object 'dbo.REFRDEL'.'ndx_refrdel_table_pk' in database 'pmdb$primavera' 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.
As we are approaching the 4GB (4096MB) limit, we are deleting unwanted projects via MS SQL Server as follows:
1) Backup database 'pmdb$primavera'
2) Determine Project ID for Project X
i.e. select proj_id from project where proj_short_name like '<Project X>';
e.g. Gives the result 729
3) Delete Project X
i.e. declare @pret_val int, @pret_msg varchar(1000)
exec project_delete 729, @pret_val output, @pret_msg output, 0
Note: In Step 3, Line 2, 729 is the result of the query in Step 2
I'm unsure if the above helps...
With Best Regards,