Configuring the WSS adapter in BizTalk 2010

February 1, 2012 at 4:36 pm Leave a comment

Microsoft SharePoint Server 2010 has had a tremendous acceptance worldwide. According to a report from the "Global 360" survey group, deployments of the SharePoint platform have increased by 500% over the course of just six months. This has made more common scenarios in which BizTalk must interact with a SharePoint Foundation 2010 document library.

Integrating BizTalk 2010 and SharePoint Foundation 2010 is very easy, configuring the WSS adapter is a straightforward operation that almost always is done without a glitch. Yesterday I was setting up this adapter as part of the tasks involving the deployment of a BizTalk application when this error showed up:



I wasn’t able to apply the proper configuration of the WSS adapter because it detected the SharePoint Foundation 2010 site as improperly configured. This struck me as very odd because I have just made sure the site was working ok.


Something else must be the cause of the problem so I went to the SharePoint 2010 Central Administration and in Review problems and solutions found out the following warning:



As you can see the main reason why the BizTalk WSS adapter wasn’t recognizing the SharePoint Foundation 2010 sites was because their databases where running in a older version than the SharePoint binaries.

This usually happens when you install a SharePoint service pack o cumulative update and you forget to update the corresponding databases. There are several ways to do so, two of the more usual are:

1) Run the SharePoint Products Configuration Wizard


2) Open an elevated command prompt, navigate to the 14 hive and execute the following:

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures


I personally prefer the command approach because I have more control of the operation performed and the feedback generated.

Once I upgraded the SharePoint databases I got back to the WSS Adapter Configuration and was able to set it up without a problem.



Remember, every time you apply a service pack, hot fix or cumulative update in SharePoint 2010 you must upgrade the databases.


Entry filed under: BizTalk, SharePoint. Tags: , , .

User Agent definition when consuming web services using HTTP in BizTalk 2010 BizTalk 2010 BAM Tools Installation Woes

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

February 2012
« Jan   Mar »


%d bloggers like this: