Prev: change IP addresses of all Portal farm components
Next: corrupt excel file on sharepoint
From: kishore on 15 Mar 2010 08:21
I am using BDC profile import. While BDC profile import is in progress, if i start crawling parallelly, the time taken for BDC profile import is increased drastically..

If anyone knows how to overcome this issue, my snenerio is to initiate Profile Import and Crawling and reduce the time duration for BDC import..

Cheers
Kishore



Peter wrote:

You don't need to create a new property called WorkMailID.
16-May-07

You don't need to create a new property called WorkMailID. Just make
sure that you specify WorkEmail in "Return items identified by this
profile property:" in the user profile import connection UI. Also
make sure that WorkEmail is properly populated in the profiles.

The problem of not being able to map fields from Master connection
could be a symptom of a different problem. You do have a master data
source right?

I'd suggest that after checking to see that the settings are correct,
you run another import, and look at the log files in the LOGS folder.
It should have more details on the exceptions that's being thrown by
MOSS/BDC.

Hope this helps.


On May 16, 8:04 am, Frenchy <frechy#sans...(a)msn.com> wrote:
ays
pp
le
ed.
not
he
ured
ill
eAD
nder"
and
inessDataCatalog
log"
tring">%</Property>
der"
Source"
al Catalog"
rated Security"
ng"
eAD">
ame=3D"System.String" />
CommandText" Type=3D"System.String">Select
eAD
CommandType"
e=3D"Comparison" Name=3D"WorkMailID" />
=3D"In" Name=3D"@GeneratedMinWorkMailID">
or TypeName=3D"System.String" IdentifierName=3D"WorkMailID"
=3D"In" Name=3D"@GeneratedMaxWorkMailID">
or TypeName=3D"System.String" IdentifierName=3D"WorkMailID"
=3D"Return" Name=3D"dbo.TableAD">
or TypeName=3D"System.Data.IDataReader, System.Data,
4e089"
Descriptors>
<TypeDescriptor TypeName=3D"System.Data.IDataRecord, System.Data,
4e089"
<TypeDescriptors>
<TypeDescriptor TypeName=3D"System.String"
<TypeDescriptor TypeName=3D"System.String" Name=3D"cn" />
<TypeDescriptor TypeName=3D"System.String" Name=3D"given=
Name" />
<TypeDescriptor TypeName=3D"System.DateTime" Name=3D"whe=
nCreated" />
<TypeDescriptor TypeName=3D"System.String" Name=3D"sAMAc=
countName" />
<TypeDescriptor TypeName=3D"System.Int32" Name=3D"TOTO" =
/>
</TypeDescriptors>
</TypeDescriptor>
eDescriptors>
tor>
=3D"dbo.TableADFinder" Type=3D"Finder"
=3D"dbo.TableADSpecificFinder" Type=3D"SpecificFinder"

Previous Posts In This Thread:

On Tuesday, May 15, 2007 10:00 AM
frechy#sansca wrote:

MOSS 2007 : BDC as user profile import
Hello all,

I'd like to use a Business Data Catalog to extend the user profils. I read a
lot of articles and tried to follow each steps but It doesn't seems to work :(

So here's the problem.

I created a simple table in sql 2005, 2 columns; EMailAdr(nchar 150) which
is my primary key and Car (nchar 150).

In MOSS 2007 I a bdc (using bdc meta man), I tested in a webpart (bdc list)
and It works.
Then I added an import connection in my SSP for the User profiles.
In the 1-1 relation, I specified the 'workEmail' and clicked OK.
Finally, I added a property, mapped to my Car column.

I started a full import and viewed the profiles.

There's the new property at the bottom, but nothing displayed :(

It seems the 1-1 relation isn't working, or I forgot something...

But there's no way to see where's the problem.

Can someone help me? Or tell-me how I could find the problem...

Thanks,

Fran??ois

On Tuesday, May 15, 2007 8:56 PM
Peter wrote:

Re: MOSS 2007 : BDC as user profile import
Hi,

If you are using 1:1 mapping, you need to define an identifier in your
entity, and your entity needs to have a SpecificFinder method. Does
your entity have an identifier?

You can check the log file and look for logs related to Business Data
Catalog. That will definitely tell you what is wrong.

Hope this helps.

Regards,
Peter



On May 15, 10:00 am, Frenchy <frechy#sans...(a)msn.com> wrote:
d a
rk :(
t)

On Wednesday, May 16, 2007 3:20 AM
frechy#sansca wrote:

Hi,I generated the xml file with bdc meta man.
Hi,

I generated the xml file with bdc meta man.

Here's some part of the xml;

<Identifiers>
<Identifier Name="WorkMailID" TypeName="System.String" />
</Identifiers>

<Property Name="RdbCommandText" Type="System.String">Select
WorkMailID,cn,givenName,whenCreated,sAMAccountName,TOTO From dbo.TableAD
Where (WorkMailID>=@GeneratedMinWorkMailID) and
(WorkMailID<=@GeneratedMaxWorkMailID)</Property>

<MethodInstance Name="dbo.TableADSpecificFinder" Type="SpecificFinder"
ReturnParameterName="dbo.TableAD"
ReturnTypeDescriptorName="dbo.TableADDataReader"
ReturnTypeDescriptorLevel="0" />


I think that every thing is in place.
Sorry if the question is stupide but where can I go to see the logs?
When I go to
Shared Services Administration: SharedServicesDefault > User Profile and
Properties > View import log
There's nothing special, except some green dot with

spsimport://levillage?$$dl$$?cn=shadow,ou=ou fo...
Crawled PEOPLE_DL_IMPORT 5/15/2007 11:25 AM


Thanks,

Fran??ois


------------
<?xml version="1.0" standalone="yes"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog
BDCMetadata.XSD"
xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog"
Type="Database" Version="1.0.0.0" Name="TestLOBSystem">
<Properties>
<Property Name="WildcardCharacter" Type="System.String">%</Property>
</Properties>
<LobSystemInstances>
<LobSystemInstance Name="TestInstance">
<Properties>
<Property Name="DatabaseAccessProvider"
Type="System.String">SqlServer</Property>
<Property Name="AuthenticationMode"
Type="System.String">PassThrough</Property>
<Property Name="RdbConnection Data Source"
Type="System.String">devfla</Property>
<Property Name="RdbConnection Initial Catalog"
Type="System.String">Test</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="dbo.TableAD">
<Identifiers>
<Identifier Name="WorkMailID" TypeName="System.String" />
</Identifiers>
<Methods>
<Method Name="Getdbo.TableAD">
<Properties>
<Property Name="RdbCommandText" Type="System.String">Select
WorkMailID,cn,givenName,whenCreated,sAMAccountName,TOTO From dbo.TableAD
Where (WorkMailID>=@GeneratedMinWorkMailID) and
(WorkMailID<=@GeneratedMaxWorkMailID)</Property>
<Property Name="RdbCommandType"
Type="System.Data.CommandType">Text</Property>
</Properties>
<FilterDescriptors>
<FilterDescriptor Type="Comparison" Name="WorkMailID" />
</FilterDescriptors>
<Parameters>
<Parameter Direction="In" Name="@GeneratedMinWorkMailID">
<TypeDescriptor TypeName="System.String" IdentifierName="WorkMailID"
AssociatedFilter="WorkMailID" Name="WorkMailID" />
</Parameter>
<Parameter Direction="In" Name="@GeneratedMaxWorkMailID">
<TypeDescriptor TypeName="System.String" IdentifierName="WorkMailID"
AssociatedFilter="WorkMailID" Name="WorkMailID" />
</Parameter>
<Parameter Direction="Return" Name="dbo.TableAD">
<TypeDescriptor TypeName="System.Data.IDataReader, System.Data,
Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
Name="dbo.TableADDataReader" IsCollection="true">
<TypeDescriptors>
<TypeDescriptor TypeName="System.Data.IDataRecord, System.Data,
Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
Name="dbo.TableADDataRecord">
<TypeDescriptors>
<TypeDescriptor TypeName="System.String"
IdentifierName="WorkMailID" Name="WorkMailID" />
<TypeDescriptor TypeName="System.String" Name="cn" />
<TypeDescriptor TypeName="System.String" Name="givenName" />
<TypeDescriptor TypeName="System.DateTime" Name="whenCreated" />
<TypeDescriptor TypeName="System.String" Name="sAMAccountName" />
<TypeDescriptor TypeName="System.Int32" Name="TOTO" />
</TypeDescriptors>
</TypeDescriptor>
</TypeDescriptors>
</TypeDescriptor>
</Parameter>
</Parameters>
<MethodInstances>
<MethodInstance Name="dbo.TableADFinder" Type="Finder"
ReturnParameterName="dbo.TableAD"
ReturnTypeDescriptorName="dbo.TableADDataReader"
ReturnTypeDescriptorLevel="0" />
<MethodInstance Name="dbo.TableADSpecificFinder" Type="SpecificFinder"
ReturnParameterName="dbo.TableAD"
ReturnTypeDescriptorName="dbo.TableADDataReader"
ReturnTypeDescriptorLevel="0" />
</MethodInstances>
</Method>
</Methods>
</Entity>
</Entities>
</LobSystem>

On Wednesday, May 16, 2007 7:43 AM
Peter wrote:

Re: MOSS 2007 : BDC as user profile import
The log files are in this folder in the MOSS Server: <drive>\Program
Files\Common Files\Microsoft Shared\web server extensions\12\LOGS

Is WorkMailID an existing user profile property that is mapped to the
master source (e.g., Active Directory)? If you view one user profile,
is this field populated at all? BDC is using this value to retrieve
the rows from SQL. If it is NULL, the LOB won't return anything.

Hope this helps.


On May 16, 3:20 am, Frenchy <frechy#sans...(a)msn.com> wrote:
sDataCatalog
g">%</Property>
ce"
atalog"
d Security"
=3D"System.String" />
andText" Type=3D"System.String">Select
andType"
"Comparison" Name=3D"WorkMailID" />
n" Name=3D"@GeneratedMinWorkMailID">
ypeName=3D"System.String" IdentifierName=3D"WorkMailID"
n" Name=3D"@GeneratedMaxWorkMailID">
ypeName=3D"System.String" IdentifierName=3D"WorkMailID"
eturn" Name=3D"dbo.TableAD">
ypeName=3D"System.Data.IDataReader, System.Data,
9"
riptors>
TypeDescriptor TypeName=3D"System.Data.IDataRecord, System.Data,
9"
<TypeDescriptors>
<TypeDescriptor TypeName=3D"System.String"
<TypeDescriptor TypeName=3D"System.String" Name=3D"cn" />
<TypeDescriptor TypeName=3D"System.String" Name=3D"givenName=
" />
<TypeDescriptor TypeName=3D"System.DateTime" Name=3D"whenCre=
ated" />
<TypeDescriptor TypeName=3D"System.String" Name=3D"sAMAccoun=
tName" />
<TypeDescriptor TypeName=3D"System.Int32" Name=3D"TOTO" />
</TypeDescriptors>
/TypeDescriptor>
criptors>
bo.TableADFinder" Type=3D"Finder"
bo.TableADSpecificFinder" Type=3D"SpecificFinder"

On Wednesday, May 16, 2007 8:04 AM
frechy#sansca wrote:

Thank you for the loggs.In fact WorkMailID is the primary key of my sql table.
Thank you for the loggs.

In fact WorkMailID is the primary key of my sql table. When I add my bdc
connection import, I specify in the 1-1 relation: WorkEmail, which is always
filled in the AD.

So If I've understood, he'll try to match the Work Email from AD with the
WorkMailID.
I haven't added a WorkMailID property in sharePoint. Do I have to?


In fact, when I add a property and I choose Master Connection, I can't mapp
to anything at the bottom...I though I could map to an AD property...

There's this text displayed at the bottom left...could It be the problem?

----------------
If you are using a high privilege account for profile import, you will be
able to read and import directory attributes that are not normally viewable
by all users, make sure the appropriate default privacy setting is selected.
Note: The selection of directory service properties may be disabled if the
shared service provider is in an untrusted domain or if profile import is not
configured.
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.
Security Note: If you are using a high privilege account to import, you will
be able to read and import directory attributes that are not normally
accessible by users.
-----------------------

Thanks again for the fast replies,


Fran??ois



"Peter" wrote:

On Wednesday, May 16, 2007 2:43 PM
Peter wrote:

You don't need to create a new property called WorkMailID.
You don't need to create a new property called WorkMailID. Just make
sure that you specify WorkEmail in "Return items identified by this
profile property:" in the user profile import connection UI. Also
make sure that WorkEmail is properly populated in the profiles.

The problem of not being able to map fields from Master connection
could be a symptom of a different problem. You do have a master data
source right?

I'd suggest that after checking to see that the settings are correct,
you run another import, and look at the log files in the LOGS folder.
It should have more details on the exceptions that's being thrown by
MOSS/BDC.

Hope this helps.


On May 16, 8:04 am, Frenchy <frechy#sans...(a)msn.com> wrote:
ays
pp
le
ed.
not
he
ured
ill
eAD
nder"
and
inessDataCatalog
log"
tring">%</Property>
der"
Source"
al Catalog"
rated Security"
ng"
eAD">
ame=3D"System.String" />
CommandText" Type=3D"System.String">Select
eAD
CommandType"
e=3D"Comparison" Name=3D"WorkMailID" />
=3D"In" Name=3D"@GeneratedMinWorkMailID">
or TypeName=3D"System.String" IdentifierName=3D"WorkMailID"
=3D"In" Name=3D"@GeneratedMaxWorkMailID">
or TypeName=3D"System.String" IdentifierName=3D"WorkMailID"
=3D"Return" Name=3D"dbo.TableAD">
or TypeName=3D"System.Data.IDataReader, System.Data,
4e089"
Descriptors>
<TypeDescriptor TypeName=3D"System.Data.IDataRecord, System.Data,
4e089"
<TypeDescriptors>
<TypeDescriptor TypeName=3D"System.String"
<TypeDescriptor TypeName=3D"System.String" Name=3D"cn" />
<TypeDescriptor TypeName=3D"System.String" Name=3D"given=
Name" />
<TypeDescriptor TypeName=3D"System.DateTime" Name=3D"whe=
nCreated" />
<TypeDescriptor TypeName=3D"System.String" Name=3D"sAMAc=
countName" />
<TypeDescriptor TypeName=3D"System.Int32" Name=3D"TOTO" =
/>
</TypeDescriptors>
</TypeDescriptor>
eDescriptors>
tor>
=3D"dbo.TableADFinder" Type=3D"Finder"
=3D"dbo.TableADSpecificFinder" Type=3D"SpecificFinder"


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Custom Validation Using the Enterprise Library
http://www.eggheadcafe.com/tutorials/aspnet/9af7ac1a-d7f3-4e00-9aec-33ef1ec7d1a3/wpf-custom-validation-usi.aspx
 | 
Pages: 1
Prev: change IP addresses of all Portal farm components
Next: corrupt excel file on sharepoint