SharePoint 2013 BCS with WCF data source: Unknown Error occurred. Unable to load one or more of the requested types.


This is a common error that you would have faced, while adding a WCF service endpoint to BCS through SharePoint Designer 2013, connected to Office 365. The complete error would look like this:

Unknown Error occurred. Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

This is an error observed while connecting to a WCF data source through SharePoint Design 2013. Ensure that your WCF service endpoint is working perfectly.

Fix:

STEP 1: Open the “SPDESIGN.exe.config” file from SharePoint Designer folder ()

STEP 2: Update the file with the following configuration:

<?xml version=”1.0″ ?>
<configuration>
<startup>
<requiredRuntime version=”v2.0.50727″ />
<supportedRuntime version=”v2.0.50727″ />
</startup>
<runtime>
<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>
<dependentAssembly>
<assemblyIdentity name=”Microsoft.BusinessData” publicKeyToken=”71e9bce111e9429c” culture=”neutral” />
<bindingRedirect oldVersion=”16.0.0.0-65535.65535.65535.65535″ newVersion=”15.0.0.0″/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>

STEP 3: Save the file and run SharePoint Designer once again.

STEP 4: Try adding your WCF data source once again. Voila! you should see it work now…:)

The fix is just telling SPD to run BCS on version 15.0.0.0, if its gets a reference to version 16.0.0.0. I guess our Office 365 online considers SharePoint 2013 version as 16, instead of 15. Forward thinking…quite understandable…:)

Hope this helps!

 

 

4 thoughts on “SharePoint 2013 BCS with WCF data source: Unknown Error occurred. Unable to load one or more of the requested types.

  1. I was running the 32 bit version of SPD and inserting the runtime section (recommended above) did not change the error. I tried removing the new runtime section and had the same result as Andrew (broken SPD). I uninstalled SPD and reinstalled but this time the 64bit (not sure what difference that makes but previously I had office 2013 installed as 32 bit so SPD was installed 32 bit to match the office install). I tried adding the runtime section with the 64bit and no change (same error). I am wondering if by chance the runtime version has been updated since the time of this blog or if there are any other adjustments needed to make this solution work. I was so hopeful that this was going to mean the SUCCESSFUL conclusion of a very long journey.

  2. When I change to same as this. I got an error: “The Business Connectivity Metadata Store is currently unavailable”.
    This error was happened when I use the version ‘click to run’ from Office 365 portal. so I have to download and installed the standalone version to resolved this issues.

    my config file is:

    Do you have any suggestion?

    Thanks

Feel free to leave a reply here...

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