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:

image

image

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.

image

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:

image

image

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

image

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

image

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.

image

image

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

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


February 2012
M T W T F S S
« Jan   Mar »
 12345
6789101112
13141516171819
20212223242526
272829  

Categories


%d bloggers like this: