>>could not allocate a new page for database because of insufficient space in filegroup...
This error is usually due to insufficient disk space or the database autogrowth settings have limited the growth( You may have disabled autogrowth and the database size has reached the maximum limit ).You can solve this problem by increasing the disk space or the max size of the database files.Or Delete data from your database to free up space for the new object.
If deleting the table fails to free up space, you can add some space and rebuild the clustered indexes. If the table does not have a clustered index, create a new one.
Rebuilding the clustered index can reduce fragmentation.
If the response helped, do "Accept Answer" and upvote it.