Monday, June 28, 2010

HRESULT: 0x80040E14

When attempting to add content to a List we got the following error "Exception from HRESULT: 0x80040E14". This error may occur when the file system on the data tier has run out of space. I used mstsc.exe to login to the server running SQL Server for this SharePoint farm and discovered there was only 500K left on the 40 gig C: drive. In SQL Server Management Studio I found the chief culprits were two log files hogging up approx. 23 gig and confirmed the files' location/sizes on the C: drive. I truncated both of them, this C: drive now has over 23 gig of free space, and this resolved the issue. Here's the command I used for truncating one of these log files.

USE SharePoint_Config
GO
ALTER DATABASE SharePoint_Config Set Recovery Simple
GO
ALTER DATABASE SharePoint_Config Set Recovery Full
GO
DBCC SHRINKFILE('SharePoint_Config_log', 2)
GO

No comments:

Post a Comment