Recently I got an error where a web couldn’t be created in SharePoint Server 2007 with Service Pack 2.

Reviewing Event Viewer and ULS Log pointed me in the right direction with a SQL Server deadlock…

Error description

This is the error message I got when I tried to create a site:

Event log message was: 'Failed to initialize some site properties for Web at Url: [URL]'. Exception was: 'Microsoft.SharePoint.SPException: Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT)) ---> System.Runtime.InteropServices.COMException (0x80004004): Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

After reviewing the ULS log I found an error message pointing me to the final solution:

Unexpected query execution failure, error code 1205. Additional error information from SQL Server is included below. "Transaction (Process ID 121) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."

Solution

You need to install Service Pack 3 for SQL Server 2005 which contains a fix for resolving this issue.

Microsoft support: http://support.microsoft.com/kb/953948/EN-US

Note: I have seen the same error message where this solution is not applicable because of a minor difference regarding the error message. Please carefully review your log files to check if this solution fits your needs or not.