Search code examples
biztalksharepoint-onlinebiztalk-2016

BizTalk 2016 and Windows SharePoint Services troubleshooting


I am supposed to update SharePoint list with information from BizTalk 2016. I am aiming at using Windows SharePoint Services adapter and CSOM. I have enabled Windows Identity Foundation (after installing BizTalk) on the BizTalk server.

I get the following error when send port runs:

The Windows SharePoint Services site was not found. The URL "http://xxx.sharepoint.com/sites/yyy/" points to a SharePoint object for which there is no Windows SharePoint Services site.

I have enabled tracing of WIF (but I get no logs):

<system.diagnostics>  
 <sources>  
  <source name="System.IdentityModel" switchValue="Verbose">  
   <listeners>  
    <add name="xml" type="System.Diagnostics.XmlWriterTraceListener" initializeData="C:\logs\WIF.xml" />  
   </listeners>  
  </source>  
 </sources>  
 <trace autoflush="true" />
</system.diagnostics>

I have tried both supplying credentials in send port configuration, and by running specific host with specific domain account. Same error.

Windows Firewall is disable on the BizTalk machine.


Solution

  • My scenario was that customer recently asked for the update to sharepoint online list. So, I needed to activate WIF AFTER BizTalk installation. In my trials to solve this I also installed latest CU6 and did a repair on the installation, too. But same problem.

    I got a powershell script to use to test connectivity and verify SharePoint online list's accessability, to exclude the adapter itself and limit the scope of the problem. Running the script, there was a problem finding classes in the Microsoft.SharePoint.Client.dll assembly. Apparently, something was missing on the machine!

    I installed SharePoint Client SDK on the machine, and - eureka - i got to the next error message!

    Seems like you do need to install additional assemblies to Windows SharePoint Services Adapter, even though the documentation says otherwise. Possibly, this is due to activating WIF AFTER BizTalk installation.

    On to the next (misleading) error message!