An exception of type Microsoft.SharePoint.SPException was thrown. Additional exception information: Exception from HRESULT: 0x80131904

Question

_{Thursday, August 5, 2010 11:21 AM}

I get the following exception when running Configuration Wizard of Sharepoint 2010.

"An exception of type Microsoft.SharePoint.SPException was thrown.  Additional exception information: Exception from HRESULT: 0x80131904"

When I check the event viewer or Sharepoint Logs, it shows that it was not able to create a site "/". This was because of another earlier error of "Unknown SQL Exception 206 occurred. Operand type clash: bit is incompatible with uniqueidentifier".

This blog http://blog.furuknap.net/2009/09/shared-sql-server-for-sharepoint-watch.html explains why Sharepoint throws this error. However, the solution provided does not work as I had no other databases on my machine.

After trying out few other options, I finally decided to uninstall all the language packs and Sharepoint and re-install them again. Now Sharepoint fails at Step 3, that is creating new configuration database, every time I try to create a new farm. I even tried to setup a new farm on a separate sql instance but that also did not work. I then even uninstalled SQL Server and re-installed it but again no gain.

It looks like somewhere in the registry or elsewhere, Sharepoint has stored some reference and is simply not allowing to create/connect to a farm.

Any suggestions on getting past this error? (ofcourse, without re-installing the OS)

All replies (2)

_{Saturday, August 7, 2010 6:30 AM ✅Answered}

Hi Manoj Mantri,

First, please check the PSCDiagnostics log files, which are located on the drive on which SharePoint Foundation is installed, in the %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\14\LOGS folder, then post the exact error information into the forum.

Second, check whether the ServerLanguage registry exists according to the following steps:

1.) Open Registry Editor

2.) Expand HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0

3.) Create a new Key under 14.0 called ServerLanguage

4.) Right-click ServerLanguage, select new String value and give it a name of 1033

Note: 1033 is valid for US English.  To determine the appropriate language value for other languages, see the following web site:  http://technet.microsoft.com/en-us/library/cc824907.aspx

5.) Close the Registry Editor

6.) Re-run the "SharePoint Products and Technologies Configuration Wizard"

Could you tell us your deployment scenario? For example, a single server with SQL server or multiple servers for a three-tier farm?

Third, try to use PSConfig.exe command-line options to complete SharePoint Server Configuration. For example, you can use psconfig.exe command with [-create] to create the database.

For more information about PSConfig.exe command-line options, please refer to the following article:

http://blogs.technet.com/b/chris_hernandez/archive/2007/10/08/using-psconfig-exe-command-line-options-to-complete-sharepont-server-configuration.aspx

Note: make sure you have sufficient permission. You can refer to http://technet.microsoft.com/en-us/library/ee662513.aspx to check your accounts.

Regards, Rock Wang Microsoft Online Community Support

_{Wednesday, July 13, 2011 8:48 PM}

this is also generated by an invalid filter value. I got this when i was trying to setup a value for my filtered view and i was using "closed" as the value for my workflow status filter option where it should have been an integer value of something like "27". Crazy stupid method they used but here's the post where i resolved my issue:

http://social.msdn.microsoft.com/Forums/en-US/sharepointworkflow/thread/f5de7947-f49b-420a-b8d8-d44ad6b7769f

See this post on how to find the custom integer value for your custom workflow status value.