Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SharePoint Products and Technologies >> SharePoint - Business Data Catalog

I am getting error when Crawling

Hi,

I am facing two problems:

The first problem is that I am able to import the application definition file successfully but when I am going to use the entity, I could not find that application and entity in the "Business Data Type Picker".

I have checked all the permission with the application and entity.

The second problem is that when I crawled and view the Crawl Log, I found "This item was deleted because the crawler did not encounter it during the last full crawl." but two records are crawled successfully.

Any help will be highly appreciated.

Thanks.

[978 byte] By [MuhammadMasood] at [2008-2-5]
«« Microsoft Access Database Synchronizer (ADS) RTW
»» System.Reflection.MethodBase.GetCurrentMethod()
# 1

Please find the application definition xml, for the above post.

<?xml version="1.0" standalone="yes"?>

<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="bdcmetadata.xsd" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog" Type="Database" Version="1.0.0.0" Name="PublisherApplication">

<Properties>

<Property Name="WildcardCharacter" Type="System.String">%</Property>

</Properties>

<LobSystemInstances>

<LobSystemInstance Name="PublisherInstance">

<Properties>

<Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>

<Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>

<Property Name="RdbConnection Data Source" Type="System.String">muhammad-masood</Property>

<Property Name="RdbConnection Initial Catalog" Type="System.String">pubs</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="0" Name="tblTitle">

<Identifiers>

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

</Identifiers>

<Methods>

<Method Name="ListBookTitle">

<Properties>

<Property Name="RdbCommandText" Type="System.String">Select title_id, title, notes from dbo.titles</Property>

<Property Name="RdbCommandType" Type="System.Data.CommandType">Text</Property>

</Properties>

<Parameters>

<Parameter Direction="Return" Name="prm.tblTitle">

<TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="TypeDescriptor.tblTitle.DataReader" IsCollection="true">

<TypeDescriptors>

<TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="TypeDescriptor.tblTitle.DataRecord">

<TypeDescriptors>

<TypeDescriptor TypeName="System.String" IdentifierName="title_id" Name="title_id" />

<TypeDescriptor TypeName="System.String" Name="title" />

<TypeDescriptor TypeName="System.String" Name="notes" />

</TypeDescriptors>

</TypeDescriptor>

</TypeDescriptors>

</TypeDescriptor>

</Parameter>

</Parameters>

</Method>

<Method Name="GetTitle">

<Properties>

<Property Name="RdbCommandText" Type="System.String">Select title_id, title, notes from dbo.titles where title_id = @p_TitleID</Property>

<Property Name="RdbCommandType" Type="System.Data.CommandType">Text</Property>

</Properties>

<FilterDescriptors>

<!-- Only MOSS 2007 Supports Comparison type -->

<FilterDescriptor Type="Comparison" Name="FilterDescriptor.TitleID" />

<!-- For Beta There is an equalent "ExactMatch" instead of Comparison type -->

<!--

<FilterDescriptor Type="ExactMatch" Name="EmployeeID" />

-->

</FilterDescriptors>

<Parameters>

<Parameter Direction="In" Name="prm.TitleID">

<TypeDescriptor TypeName="System.String" IdentifierName="title_id" AssociatedFilter="FilterDescriptor.TitleID" Name="prm.TitleID.TypeDescriptor">

<DefaultValues>

<DefaultValue MethodInstanceName="MethodInstance.GetTitle.SpecificFinder" Type="System.String">%</DefaultValue>

</DefaultValues>

</TypeDescriptor>

</Parameter>

<Parameter Direction="Return" Name="prm.tblTitle">

<TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="prm.tblTitle.TypeDescriptor.DataReader" IsCollection="true">

<TypeDescriptors>

<TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="prm.tblTitle.TypeDescriptor.DataRecord">

<TypeDescriptors>

<TypeDescriptor TypeName="System.String" IdentifierName="title_id" Name="title_id" />

<TypeDescriptor TypeName="System.String" Name="title" />

<TypeDescriptor TypeName="System.String" Name="notes" />

</TypeDescriptors>

</TypeDescriptor>

</TypeDescriptors>

</TypeDescriptor>

</Parameter>

</Parameters>

<MethodInstances>

<MethodInstance Name="MethodInstance.GetTitle.SpecificFinder" Type="SpecificFinder" ReturnParameterName="prm.tblTitle" ReturnTypeDescriptorName="prm.tblTitle.TypeDescriptor.DataReader" ReturnTypeDescriptorLevel="0" />

</MethodInstances>

</Method>

<Method Name="ListTitleIDs">

<!-- Method for enabling business data search. The method

returns a list of IDs. Business Data Catalog will use the

SpecificFinder method on each of these IDs when indexing

the prodocuts.-->

<Properties>

<Property Name="RdbCommandText" Type="System.String">SELECT title_id FROM titles</Property>

<Property Name="RdbCommandType" Type="System.String">Text</Property>

</Properties>

<Parameters>

<Parameter Name="prm.TitleIDs" Direction="Return">

<TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="prm.TitleIDs.TypeDescriptor.DataReader">

<TypeDescriptors>

<TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="prm.TitleIDs.TypeDescriptor.DataRecord">

<TypeDescriptors>

<TypeDescriptor TypeName="System.String" IdentifierName="title_id" Name="title_id">

<LocalizedDisplayNames>

<LocalizedDisplayName LCID="1033">Title ID</LocalizedDisplayName>

</LocalizedDisplayNames>

</TypeDescriptor>

</TypeDescriptors>

</TypeDescriptor>

</TypeDescriptors>

</TypeDescriptor>

</Parameter>

</Parameters>

<MethodInstances>

<MethodInstance Name="MethodInstance.ListTitleIDs.IDEnumerator" Type="IdEnumerator" ReturnParameterName="prm.TitleIDs" />

</MethodInstances>

</Method>

</Methods>

</Entity>

</Entities>

</LobSystem>

MuhammadMasood at 2007-9-6 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Data Catalog...
# 2

Let's get the first one out the way, for an entity to be used in the Data List web part it needs a Finder method defining and labeled with the Finder methodinstance tags

Nick

NickSwan at 2007-9-6 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Data Catalog...
# 3


The "Business Data Type Picker" only picks entities those have Finder method instance.

Only one Finder method instance can be in the entity.

I m very thankful to Nick (MVP).

Thanks.

MuhammadMasood at 2007-9-6 > top of Msdn Tech,SharePoint Products and Technologies,SharePoint - Business Data Catalog...
SharePoint Products and Technologies
SharePoint - Business Data Catalog

SharePoint Products and Technologies Hot Topic

SharePoint Products and Technologies New Topic

SharePoint Products and Technologies

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified