Recently we were troubleshooting an issue with uploading files on a Sharepoint Site. When we were trying to upload any file we would get an exception message similar to this one:
Unable to complete this operation. Please contact your administrator. at Microsoft.SharePoint.Library.SPRequestInternalClass.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage) at Microsoft.SharePoint.Library.SPRequest.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object varFile, PutFileOpt PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage)
Our first check was to ensure that the site collection did not get accidentally locked or that the site quotas were correct. We navigated to the appropriate Sharepoint web page:
Central Administration => Application Management => Site collection quotas and locks
There we saw that indeed the site collection was unlocked and there were no quotas specified.
What was strange was that this issue was occurring for every site collection, so we decided to check the ULS logs of Sharepoint which would give us more clues about this error. The ULS logs can be found by default here: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS.
By reviewing the latest log file we found out this error inside:
Critical Database full error on SQL Server instance 'XXXXXXX' in database 'WSS_Content'. Additional error information from SQL Server is included below. Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' 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.
This error means that the WSS_Content database has run out of disk space. This can either mean that you are actually out of disk space or that you have disabled the autogrow option for the WSS_Content database.
After giving more disk space to the WSS_Content database, the files were uploading normally.
Disclaimer
This is a personal weblog. The opinions expressed here represent my own and not those of my employer. The steps are provided “as is” without a warranty of any kind.