Wednesday, November 24, 2010

Sharepoint Schema version error

At a client, the Team Foundation server 2010 environment was working fine until suddenly the Sharepoint stopped working. In the event log, I found the following error message:

The schema version ( of the database SharePoint_AdminContent_d3718c5d-5516-41e1-ba7d-6e5a3c21ba75 on DatabaseServerX is not consistent with the expected database schema version ( on ApplicationServerY. Connections to this database from this server have been blocked to avoid data loss. Upgrade the web front end or the content database to ensure that these versions match.

I found out that Windows Update had installed some patches which upgraded the Sharepoint application front end to a higher version. Unfortunately this made the front-end and the underlying database incompatible.

I fixed the problem by executing the following commands on the application server:

   1:  stsadm -o upgrade -inplace -url <central admin url> 
   3:  iisreset

No comments: