Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Importing data into User Profiles from BDC Web Service connection

  Asked By: Luz    Date: Jan 23    Category: Sharepoint    Views: 2036

I searched the 'net and found basically 1 full thread on this, and it didn't directly apply so I'm hoping someone out there can help me.

I have a web service connection set up in my BDC and it has both Finder and Specific Finder methods. This all works fine, and I even use this definition in a few BDC web parts. I now want to supplement the User Profile data that I get from Active Directory with information from this BDC connection. I set up the New Connection under User Profiles and Properties under SharedServices. I mapped this connection using a 1:1 mapping and in the field titled "Return items identified by this profile property" I listed the EmployeeID property from the User Profile (a custom property I created which is fully populated right now from AD)...since this is the expected parameter for the web method in the BDC. So one would think on each call to the BDC, it would execute the Specific Finder method and pass in the value that's on the user profile for the EmployeeID property. Correct? Keep in mind that I can execute both finder methods in the BDC Definition Editor and get data back without error.

I then mapped some User Profile Properties to the fields available in this new connection, such as Work Phone. All seems pretty easy, right? I ran my import and the AD import was flawless. When the BDC import started after that, I contined to get this error:

spsimport://$$nonmaster$$?ourdomain/ig9 <---this is an AD user id, the same happens for every single person

Exception occured when calling into BIL connector for import from non master data source. Please check Microsoft Office sharePoint Server ULS log for exception details.

In the URL log, I see this error:

Profile Import: Exception occured when importing user: 'ourdomain\ig9'. System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.Office.Server.UserProfiles.BDCConnector.ImportUser(String accountName)

I don't understand why that is happening. Based on what I have listed above, do I have something incorrectly configured?



1 Answer Found

Answer #1    Answered By: Chelsey Watts     Answered On: Jan 23

I figured this out on my own. If you run across this in your work, just make sure that the credentials that are running your user  Profile Import(s) have access to the SQL Server tables, the BDC and all relevant BDC entities (assigning permissions to the BDC doesn't automatically take care of entities within the BDC unless you specifically tell it to apply  to all descendants).

There's not a lot of knowledge out there yet about this kind of stuff, so you may end up finding the answer on your own before you ever get a single  reply to user forums.