Sign in
 
HomeSharePoint Server 2010SharePoint Foundation 2010LibraryForums
SharePoint Products > SharePoint Products and Technologies Forums > SharePoint - Business Data Catalog (pre-SharePoint 2010) > BDC with WCF Service
Ask a questionAsk a question
Search Forums:
 

QuestionBDC with WCF Service

  • Tuesday, November 17, 2009 9:12 AMashtek Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi,

    I am using BusinessDataList web part in MOSS 2007 to call a WCF service. This WCF is created using the BizTalk WCF Publishing Wizard (BTS 2006) (using BasicHttp). This wcf service returns a simple xml with 3 nodes.
    I have created the App Definition File (ADF) using MS App Definition Editor.
    When I open the page in MOSS, I get the following error -
    =============================================================================
    An error occurred while retrieving data from <instance name>. Administrators, see the server log for more information.
    =============================================================================

    When I execute the instance from definition editor, it returns the result (shows the output columns, but not the data). I have added both Finder & Specific Finder. When the MOSS page loads I can see the request coming to BizTalk and the response xml returned from BizTalk.

    I can attach the ADF file if required.
    Any idea? Thanks in advance.
     

All Replies

  • Friday, November 20, 2009 12:18 PMScot HillierMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    1
    Sign In to Vote
    My guess is you are having a double-hop issue where the identity of the request is lost. Check and see what account is actually making the request in the web service.

    Scot
     
  • Wednesday, November 25, 2009 7:16 AMashtek Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Thank you for your reply. I was working on an alternate solution using custom webparts and just completed it.

    Since MOSS is an asp.net site, aspnet account is making the request to the wcf service (note that wcf service has anonymous access enabled)

    When I execute a Finder method instance in Application Definition Designer, it throws the error:
    "Backend system adapter returned a structure incompatible with the corresponding metadata (MethodInstance, Parameter or TypeDescriptor)"

    But I can see the service returning a valid xml with data (Debugging with a breakpoint in HAT in BizTalk shows the xml file being returned)

    When the MOSS page with BDC loads, I see the same error in the error log.

    I suspect that this is something to do with the application definition file (ADF).

    Any ideas?
     
  • Wednesday, November 25, 2009 7:29 AMashtek Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Just saw this article
    http://msdn.microsoft.com/en-us/library/dd787912(BTS.10).aspx

    Issue 3: An array of simple type returned by the WCF service is not displayed

    Explanation: If the data returned by the WCF service is an array of simple type, Microsoft Office SharePoint Server does not display the data. Moreover, when you execute a method instance in Business Data Catalog Definition Editor that returns an array of simple type, the following error message is displayed: “Backend system adapter returned a structure incompatible with the corresponding metadata (MethodInstance, Parameter or TypeDescriptor).”

    Resolution: No resolution. It is a known limitation with Microsoft Office SharePoint Server and Business Data Catalog Definition Editor.

    My wcf service returns an XML data data data

    <Root>
      <node1>data</node1>
      <node2>data</node2>
      <node3>data</node3>
    </Root>

    I think this is not an array of simple type.
    Any suggestions?
     
  • Tuesday, December 01, 2009 4:04 PMmonkie Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    I am having a similar problem (see here).

    Try using Wireshark to see exactly what is being sent and returned via http to and from your webservice.
    This might help you to debug a little further.



     
  • Friday, December 04, 2009 2:27 AMWen He Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Hi, 

    My experience is that I would always have to hand-code ADF from the MS App Definition Editor. If you could attach the ADF, that would be helpful.

    Wen

    Wen He (http://sharepointhawaii.com/wenhe)

    Wen
     
  • Friday, December 04, 2009 10:14 AMashtek Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    ADF FIle
    =====

    <?xml version="1.0" encoding="utf-8" standalone="yes"?>
    <LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="WebService" Version="1.0.0.0" Name="WCFPOGetDetail" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
      <Properties>
        <Property Name="WsdlFetchUrl" Type="System.String">http://blrkec141543d.ad.infosys.com/SAPMOSSInteropDemo/SAPMOSSInteropDemo_GetPODetail_GetPODetail_Recv_Port_WCF.svc</Property>
        <Property Name="WebServiceProxyNamespace" Type="System.String">BDC</Property>
      </Properties>
      <LobSystemInstances>
        <LobSystemInstance Name="WCFPOGetDetail_Instance">
          <Properties>
            <Property Name="LobSystemName" Type="System.String">WCFPOGetDetail</Property>
            <Property Name="WebServiceAuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.WebService.HttpAuthenticationMode">PassThrough</Property>
          </Properties>
        </LobSystemInstance>
      </LobSystemInstances>
      <Entities>
        <Entity EstimatedInstanceCount="10000" Name="GetPODetail">
          <Identifiers>
            <Identifier TypeName="System.String" Name="PONumber" />
          </Identifiers>
          <Methods>
            <Method Name="Opn_SendRecv_BAPI_PO_GETDETAIL">
              <Parameters>
                <Parameter Direction="In" Name="PO_GETDETAIL_Request">
                  <TypeDescriptor TypeName="BDC.PO_GETDETAIL_Request,WCFPOGetDetail" Name="PO_GETDETAIL_Request">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="BDC.PO_GETDETAIL_RequestPONumber,WCFPOGetDetail" Name="PONumber">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="PONumber" Name="Value" />
                        </TypeDescriptors>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="BDC.PO_GETDETAIL_RequestVendorName,WCFPOGetDetail" Name="VendorName">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Value" />
                        </TypeDescriptors>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="BDC.PO_GETDETAIL_RequestCurrency,WCFPOGetDetail" Name="Currency">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Value" />
                        </TypeDescriptors>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </Parameter>
                <Parameter Direction="Return" Name="Return">
                  <TypeDescriptor TypeName="BDC.PO_GETDETAIL_Response,WCFPOGetDetail" Name="Return">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="BDC.PO_GETDETAIL_ResponsePONumber,WCFPOGetDetail" Name="PONumber">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Value" />
                        </TypeDescriptors>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="BDC.PO_GETDETAIL_ResponseVendorName,WCFPOGetDetail" Name="VendorName">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Value" />
                        </TypeDescriptors>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="BDC.PO_GETDETAIL_ResponseCurrency,WCFPOGetDetail" Name="Currency">
                        <TypeDescriptors>
                          <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Value" />
                        </TypeDescriptors>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </Parameter>
              </Parameters>
              <MethodInstances>
                <MethodInstance Type="Finder" ReturnParameterName="Return" ReturnTypeDescriptorName="Return" ReturnTypeDescriptorLevel="0" Name="Finder" />
              </MethodInstances>
            </Method>
          </Methods>
        </Entity>
      </Entities>
    </LobSystem>