SharePoint - Business Data Catalog Forum

SpecificFinder error from Business Data Item web part

Thu, 29 Oct 2009 12:55:53 Z

I am getting the following error when I try to use my SpecificFinder from the Business Data Item web part. I attached a simplified version of my ADF that repro's the issue below.

Could not find fields to insert all the Identifier Values to correctly execute a SpecificFinder MethodInstance with Name 'PersonSpecificFinderInstance'. Ensure input Parameters have TypeDescriptors associated with every Identifier defined for this Entity.

I am staring at this and I just don't see the problem. I checked all the TypeDescriptors and I think I have <IdentifierName> defined for the <Identifier>. This seems like one of the "too close to the code to see the obvious" issues.

Thanks,
curt

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.XSD" Type="Database" Version="1.0.0.0" Name="HimcoPeople" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog \\ad1hfdhmc903\c$\PROGRA~1\MICROS~1\12.0\Bin\bdcmetadata.xsd">
<Properties>
    <Property Name="WildcardCharacter" Type="System.String">%</Property>
</Properties>
<LobSystemInstances>
    <LobSystemInstance Name="HimcoPeople">
      <Properties>
        <Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>
        <Property Name="AuthenticationMode" Type="System.String">RevertToSelf</Property>
        <Property Name="RdbConnection Data Source" Type="System.String">sqlDEVidpi\interactive</Property>
        <Property Name="RdbConnection Initial Catalog" Type="System.String">WorkArea</Property>
        <Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property>
        <Property Name="RdbConnection Pooling" Type="System.String">false</Property>
      </Properties>
    </LobSystemInstance>
</LobSystemInstances>
<Entities>
    <Entity EstimatedInstanceCount="600" Name="Person">
      <Properties>
        <Property Name="Title" Type="System.String">DomainId</Property>
      </Properties>
      <Identifiers>
        <Identifier Name="DomainId" TypeName="System.String"/>
      </Identifiers>
      <Methods>
        <Method Name="GetPerson">
          <Properties>
            <Property Name="RdbCommandText" Type="System.String">
    <![CDATA[
     SELECT Name, DomainId
     FROM People.[V_Person]
     WHERE DomainId = @DomainId
    ]]>
   </Property>
            <Property Name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
          </Properties>
          <FilterDescriptors>
            <FilterDescriptor Type="Comparison" Name="DomainId" />
          </FilterDescriptors>
          <Parameters>
            <Parameter Direction="In" Name="@DomainId" DefaultDisplayName="DomainId">
              <TypeDescriptor TypeName="System.String" Name="DomainId" />
            </Parameter>
            <Parameter Direction="Return" TypeReflectorTypeName="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbTypeReflector" Name="Person">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="PersonDataReader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="PersonDataRecord">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String" Name="Name">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="System.String" Name="DomainId" IdentifierName="DomainId">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">DomainId</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Name="PersonSpecificFinderInstance" Type="SpecificFinder" ReturnParameterName="Person" ReturnTypeDescriptorName="PersonDataReader" ReturnTypeDescriptorLevel="0"/>
          </MethodInstances>
        </Method>
        <Method Name="GetPersonList">
          <Properties>
            <Property Name="RdbCommandText" Type="System.String">
    <![CDATA[
     SELECT Name, DomainId
     FROM People.[V_Person]
     WHERE
      DomainId LIKE @DomainId
    ]]>
   </Property>
            <Property Name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
          </Properties>
          <FilterDescriptors>
            <FilterDescriptor Name="DomainId" Type="Wildcard" />
          </FilterDescriptors>
          <Parameters>
            <Parameter Name="@DomainId" Direction="In">
              <TypeDescriptor Name="DomainId" TypeName="System.String" AssociatedFilter="DomainId" >
                <DefaultValues>
     <DefaultValue Type="System.String" MethodInstanceName="PersonFinderInstance" >%</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction="Return" TypeReflectorTypeName="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbTypeReflector" Name="Person">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="PersonDataReader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="PersonDataRecord">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String" Name="Name">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">Name</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="System.String" Name="DomainId" IdentifierName="DomainId">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">DomainId</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Name="PersonFinderInstance" Type="Finder" ReturnParameterName="Person" ReturnTypeDescriptorName="PersonDataReader" ReturnTypeDescriptorLevel="0"/>
          </MethodInstances>
        </Method>
        <Method Name="GetPersonEnumerator">
          <Properties>
            <Property Name="RdbCommandText" Type="System.String"><![CDATA[SELECT DomainId FROM People.[V_Person]]]></Property>
            <Property Name="RdbCommandType" Type="System.Data.CommandType">Text</Property>
          </Properties>
          <Parameters>
            <Parameter Direction="Return" TypeReflectorTypeName="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.Db.DbTypeReflector" Name="Person">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="PersonDataReader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="PersonDataRecord">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String" IdentifierName="DomainId" Name="DomainId">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">DomainId</LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Name="PersonIdEnumeratorInstance" Type="IdEnumerator" ReturnParameterName="Person" ReturnTypeDescriptorName="PersonDataReader" ReturnTypeDescriptorLevel="0"/>
          </MethodInstances>
        </Method>
      </Methods>
    </Entity>
</Entities>
</LobSystem>

BDC with WCF Service

Tue, 17 Nov 2009 09:12:55 Z

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.

Web service not working with the BDC - Please help!

Tue, 01 Dec 2009 15:35:12 Z

I have written a simple web service in PERL and am trying to get it working with the BDC. More specificly the MS Application Definition Designer tool errors when executing either my Finder or Specific Finder instances.

My web service receives a string, writes to a log file and returns a different string.

When executing my 'Specific Finder' method instance from within the MS ADD tool, I receive the error, "Index was out of range, Must be non-negitive and less than the size of the collection". The string parameter which I pass is written to the log file so at least I know communication is happening in one direction.

When executing my 'Specific Finder' method instance from within the MS ADD tool, I receive the error, "Backend system adapter returned a structure incompatible with the corresponding metadata (MethodInstance, Parameter or TypeDescriptor)". The log file is written to, indicating that my web service script is being executed.

I'm able to see the communication between the MS Application Definition Designer tool and my PERL web service as follows...

Sent by MS Application Definition Designer tool:

POST /cgi-bin/tester.cgi HTTP/1.1

User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client 

+
Protocol 2.0.50727.1433)

Content-Type: text/xml; charset=utf-8

SOAPAction: ""

Host: services.camdev.cw.com

Content-Length: 553



<?xml version="1.0" encoding="utf-8"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" 

+
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="

+
http://services.camdev.cw.com/Services" xmlns:types="http://services.

+
camdev.cw.com/Services/encodedTypes" xmlns:xsi="http://www.w3.org/200

+
1/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

    <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/enc

+
oding/">

    <tns:testing>

        <tester xsi:type="xsd:string">foo</tester>

    </tns:testing>

    </soap:Body>

</soap:Envelope>

Returned by my PERL web service

HTTP/1.1 200 OK

Date: Mon, 30 Nov 2009 18:06:00 GMT

Server: Apache/2.2.4 (Debian) DAV/2 SVN/1.4.4 PHP/5.2.3-1+b1 mod_ssl/2

+
.2.4 OpenSSL/0.9.8e mod_perl/2.0.3 Perl/v5.8.8

SOAPServer: SOAP::Lite/Perl/0.60

Content-Length: 551

Keep-Alive: timeout=15, max=100

Connection: Keep-Alive

Content-Type: text/xml; charset=utf-8



<?xml version="1.0" encoding="UTF-8"?>

<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instanc

+
e" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:S

+
OAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http:/

+
/www.w3.org/2001/XMLSchema" SOAP-ENV:encodingStyle="http://schemas.xm

+
lsoap.org/soap/encoding/">

  <SOAP-ENV:Body>

    <namesp1:testingResponse xmlns:namesp1="http://services.camdev.cw.

+
com/Services">

       <Returned xsi:type="xsd:string">Back at ya</Returned>

    </namesp1:testingResponse>

  </SOAP-ENV:Body>

</SOAP-ENV:Envelope>

here is my wsdl file:

<?xml version="1.0" encoding="UTF-8" ?> 

- <!--  WSDL for http://services.camdev.cw.com created by Pod::WSDL ve

+
rsion: 0.05 on Mon Nov 30 16:44:41 2009 

  --> 

- <wsdl:definitions targetNamespace="http://services.camdev.cw.com/Ser

+
vices" xmlns:impl="http://services.camdev.cw.com/Services" xmlns:wsdl

+
soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:wsdl="http://schem

+
as.xmlsoap.org/wsdl/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/

+
encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns1="h

+
ttp://services.camdev.cw.com/Services">

- <wsdl:message name="testingRequest">

- <wsdl:part name="tester" type="xsd:string">

  <wsdl:documentation>abc</wsdl:documentation> 

  </wsdl:part>

  </wsdl:message>

- <wsdl:message name="testingResponse">

- <wsdl:part name="testingReturn" type="xsd:string">

  <wsdl:documentation>xyz</wsdl:documentation> 

  </wsdl:part>

  </wsdl:message>

- <wsdl:portType name="ServicesHandler">

- <wsdl:operation name="testing" parameterOrder="tester">

  <wsdl:input message="impl:testingRequest" name="testingRequest" /> 

  <wsdl:output message="impl:testingResponse" name="testingResponse" /

+
> 

  </wsdl:operation>

  </wsdl:portType>

- <wsdl:binding name="ServicesSoapBinding" type="impl:ServicesHandler"

+
>

  <wsdlsoap:binding style="rpc" transport="http://schemas.xmlsoap.org/

+
soap/http" /> 

- <wsdl:operation name="testing">

  <wsdlsoap:operation soapAction="" /> 

- <wsdl:input name="testingRequest">

  <wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encodi

+
ng/" namespace="http://services.camdev.cw.com/Services" use="encoded"

+
 /> 

  </wsdl:input>

- <wsdl:output name="testingResponse">

  <wsdlsoap:body encodingStyle="http://schemas.xmlsoap.org/soap/encodi

+
ng/" namespace="http://services.camdev.cw.com/Services" use="encoded"

+
 /> 

  </wsdl:output>

  </wsdl:operation>

  </wsdl:binding>

- <wsdl:service name="ServicesHandlerService">

- <wsdl:port binding="impl:ServicesSoapBinding" name="Services">

  <wsdlsoap:address location="http://services.camdev.cw.com" /> 

  </wsdl:port>

  </wsdl:service>

  </wsdl:definitions>

and my ADF xml file which was created by the MS ADD tool based on my WSDL 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/Business

+
DataCatalog BDCMetadata.xsd" Type="WebService" Version="1.0.0.0" Name

+
="WebServiceLobSystem" xmlns="http://schemas.microsoft.com/office/200

+
6/03/BusinessDataCatalog">

- <Properties>

  <Property Name="WsdlFetchUrl" Type="System.String">http://services.c

+
amdev.cw.com/cgi-bin/tester.wsdl</Property> 

  <Property Name="WebServiceProxyNamespace" Type="System.String">BDC</

+
Property> 

  </Properties>

- <LobSystemInstances>

- <LobSystemInstance Name="WebServiceLobSystem_Instance">

- <Properties>

  <Property Name="LobSystemName" Type="System.String">WebServiceLobSys

+
tem</Property> 

  <Property Name="WebServiceAuthenticationMode" Type="Microsoft.Office

+
.Server.ApplicationRegistry.SystemSpecific.WebService.HttpAuthenticat

+
ionMode">PassThrough</Property> 

  </Properties>

  </LobSystemInstance>

  </LobSystemInstances>

- <Entities>

- <Entity EstimatedInstanceCount="10000" Name="Entity11">

- <Identifiers>

  <Identifier TypeName="System.String" Name="testerID" /> 

  </Identifiers>

- <Methods>

- <Method Name="testing">

- <Parameters>

- <Parameter Direction="In" Name="tester">

  <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, 

+
Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="tes

+
terID" Name="tester" /> 

  </Parameter>

- <Parameter Direction="Return" Name="Return">

  <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, 

+
Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Return" /> 

  </Parameter>

  </Parameters>

- <MethodInstances>

  <MethodInstance Type="SpecificFinder" ReturnParameterName="Return" R

+
eturnTypeDescriptorName="Return" ReturnTypeDescriptorLevel="0" Name="

+
SpecificFinderTesterInstance" /> 

  <MethodInstance Type="Finder" ReturnParameterName="Return" ReturnTyp

+
eDescriptorName="Return" ReturnTypeDescriptorLevel="0" Name="FinderTe

+
sterInstance" /> 

  </MethodInstances>

  </Method>

  </Methods>

  </Entity>

  </Entities>

  </LobSystem>

Can anyone PLEASE PLEASE tell me what data the BDC (or theMS ADD tool) is expecting, once I know this, I can change my webservice to return the correct data?

Wildcard FilterDescriptor

Tue, 01 Dec 2009 14:43:04 Z

I added a couple filters to my BDC but am not having much luck getting the wildcard FilterDescriptor to work. When I perform a search, 'is equal to' is the search that will return any results. 'starts with,' 'ends with' and 'contains' all return no results no matter what I search for. Any idea what I'm missing??? Below is the Finder method I'm using. Thanks!

        <Method Name="GetEmployee">
          <Properties>
            <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
            <Property Name="RdbCommandText" Type="System.String">
              SELECT [EmployeeID]
              ,[FirstName] + ' ' + [LastName] as Name
              ,[FirstName]
              ,[LastName]
              FROM [ITDEmployee].[dbo].[tblEmployee] where [LastName] like @LastName and [FirstName] like @FirstName
            </Property>
          </Properties>
          <FilterDescriptors>
            <FilterDescriptor Type="Wildcard" Name="Last Name">
              <Properties>
                <Property Name="UsedForDisambiguation" Type="System.Boolean" >true</Property>
              </Properties>
            </FilterDescriptor>
            <FilterDescriptor Type="Wildcard" Name="First Name">
              <Properties>
                <Property Name="UsedForDisambiguation" Type="System.Boolean" >true</Property>
              </Properties>
            </FilterDescriptor>
          </FilterDescriptors>
          <Parameters>
            <Parameter Direction="In" Name="@LastName">
              <TypeDescriptor TypeName="System.String" Name="LastName" AssociatedFilter="Last Name">
                <DefaultValues>
                  <DefaultValue MethodInstanceName="GetEmployeeFinder_Instance" Type="System.String">%</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction="In" Name="@FirstName">
              <TypeDescriptor TypeName="System.String" Name="FirstName" AssociatedFilter="First Name">
                <DefaultValues>
                  <DefaultValue MethodInstanceName="GetEmployeeFinder_Instance" Type="System.String">%</DefaultValue>
                </DefaultValues>
              </TypeDescriptor>
            </Parameter>
            <Parameter Direction="Return" Name="@Employee">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="Reader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Record">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="EmployeeID" Name="EmployeeID" />
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Name" />
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="FirstName" />
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="LastName" />
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="Finder" ReturnParameterName="@Employee" ReturnTypeDescriptorName="Reader" ReturnTypeDescriptorLevel="0" Name="GetEmployeeFinder_Instance" />
          </MethodInstances>
        </Method>

BDC - Is there a way to Export data shown in BDC to Excel

Thu, 27 Sep 2007 19:23:59 Z

I know BDC is to get data from an external database, but is there an OOB funtionality that allows you to export BDC data filtered in SharePoint site to Excel...

If not I can do it as an Action Item (i guess!)

Any lead would be of great help

Thank you

SharePoint 2007 (CRM 4) Why does the "Check Names" button not return results yet the "Browse" button does?

Mon, 31 Aug 2009 15:44:22 Z

I have created a BDC for CRM 4.

In SharePoint I add an Account field to a list and when I use the "Check Names" button, I always get "No exact match was found"!

If I use the Browse button I can retrieve the data (although I can't leave the field as null and return all records and I can't seem to use a wildcard - not sure if I should expect records to be returned by clicking the search button with no search string??).

What drives the "Check Names" data? Enterprise Search is in the process of being configured so that might be the driver and explain this behaviour.

How to Implement Sharepoint BDC within my Sales Portal

Tue, 01 Dec 2009 09:10:23 Z

How to Implement Sharepoint BDC(Business Data Catalog) within my Sales Portal. Any Blogs or any suggestions or links that can help me on this.

Fox OLEDB Provider crashes Application Designer (BDC)

Fri, 18 Sep 2009 18:04:37 Z

I am trying to access some data stored on a Fox Database by using App Designer to connect to it. After trying to use ODBC and seeing that MS consider this driver deprecated and suggests using OLE DB instead I downloaded this provider for Visual Fox Pro and try to connect to the DB.
Everything was going fine on Adding a LOB system, typing the conn string for OLE DB and when I hit Connect I even could see the table list and Add tables by dragging them to the workspace. My guess here was that the provider and conn string were fine since I could actually see the DB objects, but when I hit the OK button and the App Designer should take me to the tree-view Metadata Objects window and let me do my work, instead it just crashes big time!

The error says Application Definition Designer has stopped working with this Details:

Description:
Stopped working

Problem signature:
Problem Event Name:    CLR20r3
Problem Signature 01:    applicationdefinitiondesigner
Problem Signature 02:    1.0.0.0
Problem Signature 03:    49ac68fa
Problem Signature 04:    mscorlib
Problem Signature 05:    2.0.0.0
Problem Signature 06:    498d1a92
Problem Signature 07:    dc
Problem Signature 08:    5
Problem Signature 09:    A4DH5WWIWWW1YJTMP0C0KV4ZWCALU4IN
OS Version:    6.0.6001.2.1.0.274.10
Locale ID:    1033

I have tried this on Windows server 2003 32bit and on Windows Server 2008 64bit and it happens exactly the same way. I even tried this with ODBC driver, is the same!
The connection String I'm using is:

Provider=vfpoledb
; Data Source=C:\DBFFox\Sfm\myVFPDB.dbc
; Mode=ReadWrite|Share Deny None; Collating Sequence=MACHINE;

I need to access this data from this BD and wouldn't like to use another way since we're doing this for a number of databases (Access, Sybase, MSSQL...) using BDC and would like to be standard. Is this possible? What is wrong with this driver/provider? Are there alternatives to access this data?

Thank you.

meta column, business data picker no search

Fri, 27 Nov 2009 13:56:26 Z

I have imported the following stuff:
There are more types but I don't think you guy's are interested in that.
What happens in the "Account" picker at a metadata column is the dropdown does not contain items and search does not work.

    <Entity EstimatedInstanceCount="0" Name="Account">
      <Properties>
        <Property Name="Title" Type="System.String">name</Property>
      </Properties>
      <Identifiers>
        <Identifier TypeName="System.String" Name="[accountid]" />
      </Identifiers>
      <Methods>
        <Method Name="Getdbo.[FilteredAccount]">
          <Properties>
            <Property Name="RdbCommandText" Type="System.String">Select [accountid],[accountnumber],[name],[address1_line1],[address1_line2],[address1_line3],[address1_city],[address1_stateorprovince],[address1_postalcode],[address1_country],[emailaddress1],[primarycontactid],[primarycontactidname],[telephone1],[businesstypecodename],[creditlimit],[creditonholdname],[customersizecodename],[customertypecodename],[description],[emailaddress2],[emailaddress3],[fax],[industrycodename],[numberofemployees],[revenue],[statecodename],[statuscodename],[tickersymbol],[websiteurl],[donotbulkemailname],[donotbulkpostalmailname],[donotemailname],[donotfaxname],[donotphonename],[donotpostalmailname],[donotsendmarketingmaterialname] From dbo.[FilteredAccount]</Property>
            <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
          </Properties>
          <Parameters>
            <Parameter Direction="Return" Name="dbo.[FilteredAccount]">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="dbo.[FilteredAccount]DataReader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="dbo.[FilteredAccount]DataRecord">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String" IdentifierName="[accountid]" Name="accountid">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">
                            Account ID
                          </LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="System.String" Name="name">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">
                            Account Name
                          </LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="Finder" ReturnParameterName="dbo.[FilteredAccount]" ReturnTypeDescriptorName="dbo.[FilteredAccount]DataReader" ReturnTypeDescriptorLevel="0" Name="dbo.[FilteredAccount]Finder" />
          </MethodInstances>
        </Method>
        <Method Name="dbo.[FilteredAccount]SpecificFinder">
          <Properties>
            <Property Name="RdbCommandText" Type="System.String">Select [accountid],[accountnumber],[name],[address1_line1],[address1_line2],[address1_line3],[address1_city],[address1_stateorprovince],[address1_postalcode],[address1_country],[emailaddress1],[primarycontactid],[primarycontactidname],[telephone1],[businesstypecodename],[creditlimit],[creditonholdname],[customersizecodename],[customertypecodename],[description],[emailaddress2],[emailaddress3],[fax],[industrycodename],[numberofemployees],[revenue],[statecodename],[statuscodename],[tickersymbol],[websiteurl],[donotbulkemailname],[donotbulkpostalmailname],[donotemailname],[donotfaxname],[donotphonename],[donotpostalmailname],[donotsendmarketingmaterialname] From dbo.[FilteredAccount] Where (accountid=@accountid)</Property>
            <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
          </Properties>
          <Parameters>
            <Parameter Direction="In" Name="@accountid">
              <TypeDescriptor TypeName="System.String" IdentifierName="[accountid]" Name="[accountid]" />
            </Parameter>
            <Parameter Direction="Return" Name="dbo.[FilteredAccount]">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="dbo.[FilteredAccount]DataReader">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="dbo.[FilteredAccount]DataRecord">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String" IdentifierName="[accountid]" Name="accountid">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">
                            Account ID
                          </LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="System.String" Name="name">
                        <LocalizedDisplayNames>
                          <LocalizedDisplayName LCID="1033">
                            Account Name
                          </LocalizedDisplayName>
                        </LocalizedDisplayNames>
                      </TypeDescriptor>
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="SpecificFinder" ReturnParameterName="dbo.[FilteredAccount]" ReturnTypeDescriptorName="dbo.[FilteredAccount]DataReader" ReturnTypeDescriptorLevel="0" Name="dbo.[FilteredAccount]SpecificFinder" />
          </MethodInstances>
        </Method>
        <Method Name="dbo.[FilteredAccount]IDEnumerator">
          <Properties>
            <Property Name="RdbCommandText" Type="System.String">Select [accountid] from dbo.[FilteredAccount]</Property>
            <Property Name="RdbCommandType" Type="System.Data.CommandType, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">Text</Property>
          </Properties>
          <Parameters>
            <Parameter Direction="Return" Name="dbo.[FilteredAccount]IDs">
              <TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="dbo.[FilteredAccount]IDs">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="dbo.[FilteredAccount]">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String" IdentifierName="[accountid]" Name="accountid" />
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="IdEnumerator" ReturnParameterName="dbo.[FilteredAccount]IDs" ReturnTypeDescriptorName="dbo.[FilteredAccount]IDs" ReturnTypeDescriptorLevel="0" Name="dbo.[FilteredAccount]EnumeratorInstance" />
          </MethodInstances>
        </Method>
      </Methods>
    </Entity>

Adding managed property from BDC

Mon, 30 Nov 2009 15:59:48 Z

I created a managed property from business data. The application has spaces in it so the mapping looks like Microsoft Dynamics CRM.Account.name(Text)
No I do not get any results with this propery (after full crawl) and I don't want to mess around to much (it is the official site) so I want to know for sure, is it possible the spaces are messing this up? It shows some examples but not the right one...

Using Infopath Form with BDC to create database driven application

Wed, 15 Oct 2008 21:10:39 Z

Hi All,

Using BDC we can display a list of entity in BDC Data List web part and a user can see the details of a particular entity using Business Data Item web part.

I wonder if we can use an InfoPath froms for updating and/or inserting of an entity and associate it with the BDC Data list web part as an action. Has anyone implemented a such solution?

I have created an InfoPath form to Submit the data to a web service (to create a record of an entity) and deploy it itself using XMLFormViewer web part, and it works fine. I wonder if we can attach the InfoPath forms with BDC Data List web part and that way one could easily create CRUD (Create, Read, Update and Delete) of an entity using BDC and InfoPath together inside MOSS.

I think MOSS is a great tool to create a Publishing Portal application, content managemment, office applications etc.. but not a good option to create a database driven application (CRUD of database entities). Please correct me if I am wrong here.

Looking forward to answers/comments.

Hitesh

Business Data List has no Business Data Type available in the picker

Mon, 09 Nov 2009 22:46:50 Z

I created an ADF file. I import the file into sharepoint. I set the permissions. I go to the page and add a Business Data List. I modifiy the shared web properties. I go into the Business Data Type Picker and I have nothing available to select. I search and still cant find it. Can anyone tell me why this is blank?????

Mapping site / customer metadata

Fri, 20 Nov 2009 11:49:38 Z

Hi,

I'm currently in the process of setting up customer portals for our own customers to sign into. The idea is that these portals will be automatically created based on a site template, and customers are able to log in via a FBA site.

Now on each site, I will have some libraries and stuff. Also, I need a BDC part to show the customers data from our CRM project. So I need a way to feed the BDC webpart the customer code for retrieving the record.

I've now implemented it like this: the customer code is the relative path of the site. So when the customers code is CONTOSO, then the site would become https://customers.company.com/CONTOSO. I wrote a webpart which takes the correct part the of the URL and provides it as a filter template. This works fast and good, but my programmer heart is telling me this is a filthy solution.

Another problem is that I have to aggregate data from multiple customer sites, like tasks and such. Offcourse, in the overview, my manager would like to see to which customer the task is bound. I can do that by stripping down the site address, but i'm not quite sure if that's the way to go. I could also write a feature which fills a 'Customer' column, but again I would need to feed that somehow.

I'm probably not the only one wanting these kinds of things, so I was curious about ways to solve this.

MCTS in Web Application Development in .NET 2.0

Reset BDC Item

Thu, 26 Nov 2009 13:00:54 Z

I have a BDC Related List (Machines) web part which is connected to a BDC list webpart (Customers). When I select a Customer and then a machine of this customer, the two Data Item Webparts on the page show the Details (Customer details, Machine Details) of the entry.
But if I search again for a new customer and select it, the Machine Detail Webpart still shows the "old" information of the previously selected entry.
Is there any way to reset for example all the "Data Item"-Webparts on a page? Or can we send a default Parameter to all the webparts on a page when clicking on the Searchbutton?

Thank you in advance

Can I choose specific entities to be included in a content source?

Thu, 26 Nov 2009 11:47:58 Z

Hello,

I created a content source for my BDC application but it takes too long to crawl.

Imagine 2 entities: Contact and Addresses. People will always search for contacts not addresses. I will customize the result page so that it does show the contact addresses of the specific contact. So I don't really need to be able to search for addresses.

So, could I limit the number of entities in the content source?

application definition designer is crashing

Thu, 18 Jun 2009 20:54:21 Z

Hi :

I tried to add a table to application definition designer after I was connected to the database. It gave me an error System.collection.genreic.keyNotFoundException. I am using oledb to connect to my database. The database itself is a sql server 2000.

any idea?

Thanks

Mathematical calculation using BDC SELECT satement

Fri, 20 Nov 2009 16:37:40 Z

I have following select statement in the BDC,

SELECT ((SELECT UNIT_SCALE as UNIT_SCALE1 FROM UNITS WHERE (UNIT=:UserUnit))/(SELECT UNIT_SCALE as UNIT_SCALE2 FROM UNITS WHERE (UNIT=:DBUnit))) as SCALE FROM dual;

<FilterDescriptors>	
						<FilterDescriptor Type="Wildcard" Name="UserUnit" />						<FilterDescriptor Type="Wildcard" Name="DBUnit" />
					</FilterDescriptors>
					<Parameters>
						<Parameter Direction="In" Name=":UserUnit">
						<TypeDescriptor TypeName="System.String" Name="UNIT" AssociatedFilter="UserUnit"></TypeDescriptor>						</Parameter>
						<Parameter Direction="In" Name=":DBUnit">
						<TypeDescriptor TypeName="System.String" Name="UNIT" AssociatedFilter="DBUnit"></TypeDescriptor>
						</Parameter>									<Parameter Direction="Return" Name="&quot;CHEMREG&quot;.&quot;UNITS&quot;">
						<TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="&quot;CHEMREG&quot;.&quot;UNITS&quot;DataReader">
						<TypeDescriptors>
						<TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="&quot;CHEMREG&quot;.&quot;UNITS&quot;DataRecord">
						<TypeDescriptors>
					<TypeDescriptor TypeName="System.Decimal" Name="UNIT_SCALE1" />
	<TypeDescriptor TypeName="System.Decimal" Name="UNIT_SCALE2" />
	<TypeDescriptor TypeName="System.Decimal" Name="SCALE" />										</TypeDescriptors>
						</TypeDescriptor>
						</TypeDescriptors>
						</TypeDescriptor>
						</Parameter>
					</Parameters>

I get "ORA-00911: invalid character" error.

Please help.

Problem with BDC in forms authentication

Wed, 07 Oct 2009 13:45:22 Z

Hi,
I had devleoped BDC web part. It works fine with NTLM authentication.
But gives an error message "Access denied" for FBA users. But when I add the FBA users to BDC list (Central Admin > SSP > Business Data Catalog >Business Data Catalog Permissions) it works fine. But I dont think it i s good practice to all all the 1000s of FBA users to the BDC permissions.

I would like to know what is the best practice to achieve BDC for FBA users.
Note:
The SSP has been extended for FBA users.

How to embed a web application code in MOSS 2007 as a BDC web part?

Mon, 23 Nov 2009 09:16:07 Z

Hi All,

I have created a web application which contains lots of .aspx, .ascx files etc.
Now, I want to use this web application in MOSS as a bdc web part. I won't be able to rewrite the code to use it as a bdc web part.

Is there any way to embedd this code directly in MOSS as a bdc web part?
I mean to say when I drag n drop the web part, my web application will be visible in web part zone. There I can use or retrieve or insert data in database using web application.

I don't want to call this web application using any url. I want to completely embed the code as a web part.

Can anyone suggest how to achieve this task?

Thanks in advance.

Regards.

Cannot connect to dabase instance in Business Data List webpart.

Tue, 24 Nov 2009 07:05:30 Z

Im having trouble when using business data list webpart in Sharepoint.

'Unable to connect to AdventureWorksDW_Instance.'

In my Event Logs, this is the error:

Could not open connection using 'data source=MSSQL;initial catalog=AdventureWorksDW;integrated security=True;persist security info=false' in App Domain '/LM/W3SVC/243996052/ROOT-1-129034982946432768'. The full exception text is: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

How can I fix this problem?

Error when executing a MethodInstance from BDC Editor

Tue, 24 Nov 2009 05:45:13 Z

Hello friends,

I am pretty new to BDC concept in Sharepoint. I have a Java Web service which uses SOAP12 protcol. When executed from third party tool SOAPUI, it gives back the result, which is basically ArrayOfString and inside which you have strings..... But, when i execute the same method instance from BDC editor, it says 'Unable to Connect to remote server'. I have necessary rights. I am part of Farm Admistrators & site collection administrators group as well in sharepoint. Please help me resolve this issue. Let me know if you need more details with respect to the problem.

Thanks in advance.

Sravan Kasyap

BDC Definition Editor Install Error

Mon, 23 Nov 2009 17:40:28 Z

I'm trying to install the BDC Definition Editor from the latest SharePoint SDK (1.5) and I'm getting errors which cause the installation to abort. I've tried both the setup.exe and running the MSI package directly, neither seem to get past the error. Here's the related installation log details just before the rollback:

DEBUG: Error 2769: Custom Action _0ADE9416_9717_41CD_96D3_242A073CE3F3.install did not close 1 MSIHANDLEs.

I'm using Vista Enterprise Edition (32-bit) and have VS 2008 and SQL 2008 installed. Has anyone else experienced this issue with the custom action identified above?

-Glen

Error : The filter process could not be started. The system is most likely low on resources ...."

Thu, 19 Nov 2009 12:03:54 Z

While improting user profile data in sharepoint i am getting this error :

The filter process could not be started. The system is most likely low on resources, or the filter process binary was modified. If the resources are available, check the search binaries with an antivirus program. The filter process could not be started. The system is most likely low on resources, or the filter process binary was modified. If the resources are available, check the search binaries with an antivirus program.

I scanned the system with two different anti-virus apps but didn’t find any virus, also there is no resource shortage in this system as given in the error message. I have custom profile properties also getting imported which was working fine till last week, I removed BDC related things from this system still the same error is coming. probably only change in Sharepoint is that i did is MOSS SP2 Upgrade in this system. is there anyone who knows about this issue.

BDC Definition Editor - New Web Method in webservice for existing LOB System

Tue, 15 Apr 2008 22:10:58 Z

Anyone knows if it is possible to refresh/reload the LOB system (using BDC Defintion editor) so that new Web Methods added to the underlying web service can be added as new methods to an existing LOB system?

Currently if I add new web methods to the webservice they will not be listed as available "Web Methods" for creating new methods. Then I usuallty edit the xml and inserts the new method manually before reimporting to the BDC definition Editor. Is there a better way?

BDC Filter

Tue, 17 Nov 2009 22:50:31 Z

i have created a Business Data List with all the data coming in. what I am looking to do is create filters for the columns but if filters are not used for all of the data to populate the list. How do I go about doing this. Every time I create filters all the data is removed from the list. Thanks in advance

Displaying Images

Thu, 12 Nov 2009 17:06:29 Z

We are attempting to use the BDC to display employee info from an external SQL Server db. One of the fields we need to display is an Image type. Will this field be displayed as an image by the BDC?

Cannot filter on specific BDC field in the list toolbar

Tue, 22 Sep 2009 18:47:11 Z

A list is displaying secondary BDC field of both string and decimal types. For some reason the string types do not allow filtering on the field from the list toolbar dropdown, the decimal types do allow filtering. Strangely enough, another library in the same site collection (so with the same BDC definition) does allow filtering on some string type BDC fields, but not on all fields.

I also noticed that the fields / columns that do not allow in place filtering are also not available in a calculated column.

Any suggestions to resolve this would be appreciated.

Jeroen

Making BDC with SSO work with Forms based authentication

Tue, 19 Aug 2008 08:07:38 Z

We are struggling with how to correctly set up BDC to work with FBA (forms based authentication). The scenario is as follows:

We have built a BDC definition for MS CRM 3.0 and are using standard BDC webparts to show some custom entities from CRM. The BDC connects directly to the CRM database, so we set up SSO (single sign-on) to provide mapping to an SQL account with read access to the database (all domain accounts are mapped to use the same SQL user in SSO). This part is working just fine.

Now we need to set up dual authentication to enable external users to view the same info. The site is extended and the new zone is configured to authenticate using Forms Based Authentication. But how do we map FBA users within SSO? Apparently you can only map an domain group within the page "Manage Account Information for an Enterprise Application Definition" in central admin.

Any help or input to getting the external users access to the BDC info is appreciated. All external users will have the same access rights (no need to map rights per user basis).

Thanks in advance
Thomas N. Sørensen

BDC & WebService - IDEnumerator Problems

Mon, 02 Nov 2009 19:56:39 Z

Let's start here. Due to specific constraints of my environment I cannot connect directly to the database. In leu of these I am using an additional layer via WebServices.

I have 3 methods in my webservice...

GetPartNumbers_IDEnumerator()
GetPart_SpecificFinder()
GetParts (Finder)

As far as the WebService goes, GetPartNumbers_IDEnumerator() returns an ArrayOfString(Collection) with string elements containing only the ID's. See below

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://intranet1/WebServices/">
  <string>01210801         00 </string>
  <string>02050902         00 </string>
  <string>02050903         00 </string>
  <string>100014           03 </string>
  <string>100020           03 </string>
</ArrayOfString>

GetPart_SpecificFinder() returns below...

<GSSPart>
  <PartNumber>102233           00</PartNumber>
  <PartDescription>WELDED REAR SHELF ASSY 150    </PartDescription>
  <Exists>true</Exists>
</GSSPart>

GetParts() returns...

<ArrayOfGSSPart>
  <GSSPart>
  <PartNumber>100014           03 </PartNumber>
  <PartDescription>CLIP                          </PartDescription>
  <Exists>true</Exists>
</GSSPart>
<GSSPart>
  <PartNumber>100020           03 </PartNumber>
  <PartDescription>BOTTOM TRANSFER PLATE (BE)    </PartDescription>
  <Exists>true</Exists>
</GSSPart>
</ArrayOfGSSPart>

Using ApplicationDefinitionDesigner, when Executing the IDEnumerator method, I get the error,
"Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index."

I know what the error means, but I don't know why I'm getting it. I'm assuming it has something to do with my ADF, but I don't know what.

However, the Finder and Specific Finder methods work fine.

Any ideas welcome. Including my ADF.

<?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="GSS_VJobHeader_PartDescription" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
  <Properties>
    <Property Name="WsdlFetchUrl" Type="System.String">http://intranet1/WebServices/GSS_VJobHeader_PartDescription.asmx?wsdl</Property>
    <Property Name="WebServiceProxyNamespace" Type="System.String">BDC</Property>
    <Property Name="WildcardCharacter" Type="System.String">%</Property>
  </Properties>
  <LobSystemInstances>
    <LobSystemInstance Name="GSS_VJobHeader_PartDescription_Instance">
      <Properties>
        <Property Name="LobSystemName" Type="System.String">GSS_VJobHeader_PartDescription</Property>
        <Property Name="WebServiceAuthenticationMode" Type="Microsoft.Office.Server.ApplicationRegistry.SystemSpecific.WebService.HttpAuthenticationMode">PassThrough</Property>
      </Properties>
    </LobSystemInstance>
  </LobSystemInstances>
  <Entities>
    <Entity EstimatedInstanceCount="10000" Name="GetPartsResult">
      <Identifiers>
        <Identifier TypeName="System.String" Name="PartNumber" />
      </Identifiers>
      <Methods>
        <Method Name="GetPartNumbers_IDEnumerator">
          <Parameters>
            <Parameter Direction="Return" Name="Return">
              <TypeDescriptor TypeName="System.String[], mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="ArrayOfString" DefaultDisplayName="GetPartNumbers_IDEnumeratorResult">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="PartNumber" Name="string" />
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="IdEnumerator" ReturnParameterName="Return" ReturnTypeDescriptorName="ArrayOfString" ReturnTypeDescriptorLevel="0" Name="GetPartNumbers_IDEnumeratorResultInstance" />
          </MethodInstances>
        </Method>
        <Method Name="GetPart_SpecificFinder">
          <Parameters>
            <Parameter Direction="In" Name="Part">
              <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="PartNumber" Name="Part" />
            </Parameter>
            <Parameter Direction="Return" Name="Return">
              <TypeDescriptor TypeName="BDC.GSSPart,GSS_VJobHeader_PartDescription" Name="GSSPart" DefaultDisplayName="Return">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="PartNumber" Name="PartNumber">
                    <Properties>
                      <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                    </Properties>
                  </TypeDescriptor>
                  <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="PartNumber" Name="PartDescription">
                    <Properties>
                      <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                    </Properties>
                  </TypeDescriptor>
                  <TypeDescriptor TypeName="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Exists" />
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="SpecificFinder" ReturnParameterName="Return" ReturnTypeDescriptorName="GSSPart" ReturnTypeDescriptorLevel="0" Name="GetPart_SpecificFinderResultInstance" />
          </MethodInstances>
        </Method>
        <Method Name="GetParts">
          <FilterDescriptors>
            <FilterDescriptor Type="Wildcard" Name="Part" />
          </FilterDescriptors>
          <Parameters>
            <Parameter Direction="In" Name="Part">
              <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="PartNumber" AssociatedFilter="Part" Name="Part" />
            </Parameter>
            <Parameter Direction="Return" Name="Return">
              <TypeDescriptor TypeName="BDC.GSSPart[],GSS_VJobHeader_PartDescription" IsCollection="true" Name="ArrayOfGSSPart" DefaultDisplayName="GetPartsResult">
                <TypeDescriptors>
                  <TypeDescriptor TypeName="BDC.GSSPart,GSS_VJobHeader_PartDescription" Name="GSSPart">
                    <TypeDescriptors>
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="PartNumber" Name="PartNumber">
                        <Properties>
                          <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IdentifierName="PartNumber" Name="PartDescription">
                        <Properties>
                          <Property Name="ShowInPicker" Type="System.Boolean">true</Property>
                        </Properties>
                      </TypeDescriptor>
                      <TypeDescriptor TypeName="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="Exists" />
                    </TypeDescriptors>
                  </TypeDescriptor>
                </TypeDescriptors>
              </TypeDescriptor>
            </Parameter>
          </Parameters>
          <MethodInstances>
            <MethodInstance Type="Finder" ReturnParameterName="Return" ReturnTypeDescriptorName="ArrayOfGSSPart" ReturnTypeDescriptorLevel="0" Name="GetPartsResultInstance" />
          </MethodInstances>
        </Method>
      </Methods>
    </Entity>
  </Entities>
</LobSystem>

BDC paging using Web Service

Thu, 12 Nov 2009 05:52:46 Z

Hi,

Does BDC methods support to implement paging in web method of to retrive only selected data instead of all at once in another word How BDC intact with web service to implement paging?

I have to extract the data from salesforce to intract with sharepoint. The finder web methods return huge records that stop the execution of processing (time out).

Many thanks in advance
-Madhukar

BDC + Permissions to Sharepoint group

Wed, 01 Apr 2009 12:17:49 Z

I have a site defined to use forms authentication. In the site the (forms)users are added to the site's Viewers group.

Now I have to setup BDC permissions to the Viewers group in shared service provider. I go to SharedServices > Manage Permissions > Add Users/Groups and type Viewers to Users/Groups textbox and click "Check names". The name gets underlined so Moss seems to recognize the group ok. However after selecting some permission checkboxes and pressing Save it throws error:
The specified user or domain group was not found.
Please press the back button of the browser,fix the error and try the operation again

Ok, so it's not a domain group but how can I give a group of forms users permissions without explicitly declaring each and everyone in the BDC permissions, ie. can I use already defined sharepoint user group (ie.Viewers) somehow? Declaring users one by one works ok, but it's quite a lot of work to add permissions to every ADF's entity and method manually and reimport every time a user gets added to the system.

Best regards
Tommi

How Security works for Enterprise Search using BDC web service?

Tue, 06 Oct 2009 09:46:38 Z

Folks, I am going to start implementing a search integration by means of BDC Web service (I want to search some data that are exposed by means of a web service).
Now I am wondering if the SharePoint crawls the data and index it at the SharePoint site, then how the security will work onto the search result? For example, some user might not able to see certain search results. But if they searchs for them, how SharePoint search will restrict them from viewing those?

I really wanted to know how this security mechanism actually works in the context of BDC web service. If anyone of know could you please be so kind to share the knowledge or point me to some online resource where I can read the details..?

Any help would be greatly appreciated!!

- Moim Hossain [Please mark as answer if this post helps you]

Unable to retrieve BDC entities to SharePoint site

Sat, 31 Oct 2009 13:50:08 Z

Hi All,

I have used 'Microsoft.Office.Server.ApplicationRegistry.MetadataModel.ApplicationRegistry' in my code for Loading the BDC applications to a dropdown in MOSS 2007 site. It worked fine and BDC applications and entities were loaded to the dropdowns.

Now I have migrated the site to SharePoint 2010 and it gives the following warning :

'Microsoft.Office.Server.ApplicationRegistry.MetadataModel.ApplicationRegistry' is obselete: 'O12 Application Registry API is deprecated. Please Use BusinessData.'

However I am able to build the code in VS. But the BDC applications are not loaded to the dropdown.

Can someone suggest me on what I have to do?

Thanks in advance :)

Making BDC web parts available in "MY sites"

Mon, 02 Nov 2009 17:31:57 Z

BDC web parts arent showing up in my list of web parts available to be added to a My Site. I understand how to use BDC with user profiles, but the public profile view is unattractive, and I have a requirement to modify it. I really just need to add BDC web parts to the System account profile page, so that the changes aggregate through the organization. Any help?

Accessing Data via BDC

Thu, 24 Sep 2009 16:32:20 Z

I've created an application definition file and imported it into the BDC. Now I have a Business Data List Web part and I want to access the data.
What do I do in the Business Data List Web Part to be able to access the data?

Is there any free open source tools to create an ADF file for BDC in sharepoint

Fri, 13 Nov 2009 06:52:48 Z

Hi All,

I want to create an ADF file for BDC....i want to know if there are any free open source tools for creating ADF files. Thank you.

Business Data List

Fri, 13 Nov 2009 14:58:59 Z

I created a Business Data List off of a BDC I created called CustomerAlerts. In the Edit View The I have retreive all items selected, the columns to be shown only show one column. in the table I have ten. How do I get the other columns to show up. In the Business Data Item all the fields show up. Does anyone have any clue on this? Thanks in Advance

Problem accessing Data using BDC

Thu, 12 Nov 2009 19:23:22 Z

I was trying to publish the user profile from the AD but some of the attributes are not in AD so I thought of make use of BDC.

My question here is _

1. Do I need to download the "sample database AdventureWorks" ?

What I did is without "sample database AdventureWorks"

2. I created database called EmployeeInformation and created table called "EmployeeData"
3.Then created ADF using "Microsoft Business Data Catalog Definition Editor tool "

4. Imported application definition

5. Added Business data list Web part

6. No luck always get "Unable to connect to EmployeeInformation_Instance

Any suggestion is appreciated.

Thank you
BijNep

Mapping Profile fields to Custom Connection (BDC)

Mon, 02 Nov 2009 17:04:11 Z

We are running our primary profile import from AD and this is working. I have some additional attributes that are exposed through the BDC (via aweb service call). The BDC application is available and working, and domain users has permissions. I've created a Custom Connection to expose the data from the BDC.

When I attempt to map the profile field to the custom connection though I see the following on the left column

"Note: The selection of directory service properties is disabled because the portal is in an untrusted domain or no directory service import is configured yet."

I'm familiar with that problem for the main import, where the Farm Admin account credentials have to be supplied. In this case both Domain Users and Authenticated Users have permission and there is no place to set the account to use on the Custom Connection configuration.

SharePoint Developer | Administrator | Evangelist -- Twitter -- Blog - http://nextconnect.blogspot.com

After Installation of SP2: No sorting & grouping of Business Data Columns?

Wed, 02 Sep 2009 15:26:01 Z

Hi,

after the installation of the MOSS 2007 Service Pack 2, columns of type "Business Data" (that represent data of type System.String) are not sortable resp. groupable anymore when creating views in Document Libraries. Data is displayed correctly, but you cannot make a sort/filter/group on the column anymore.

Before the installation of this famous service pack, I had no problems using the sorting and grouping of this columns.

Does anybody made the same experience or is there a workaround?

With kindly Regards,

Jm Aalen.