Sunday, November 27, 2011

SQL Express Database full error in Sharepoint :Exception from HRESULT: 0x80131904

This Post reveals the erro message that you would get once your SQL Express database is full.
For instace,If you try to add any new item in the created webpart then you would end up the
below shown message.
Exception from HRESULT: 0x80131904



Log Message :
SqlError: 'Could not allocate space for object 'dbo.AllDocs'.'AllDocs_ParentId' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files,

Solution :
upgrade the SQL Express Edition to full SQL edition. This was coming from the fact that my content database was full.

NOTE:Please refer to article "Upgrade SQLExpress 2008 to SQL 2008 r2"

1 comment:

  1. Not necessarily. For what I can see, this can be also related to other problems, most probably SQL Server errors (see e.g. http://social.msdn.microsoft.com/Forums/en-US/sharepointgeneralprevious/thread/d96eaefb-d519-4aef-bbe6-8afb19a4e835).

    In my case it was the 'column contains [text]' query for lookup column, which was referencing computed column. This was translated to invalid SQL query by Sharepoint.

    The best way to deal with this error is to look for '0x80131904' in your ULS logs and see the error details, which should be included.

    ReplyDelete