InfoPath Dev

Environment: SharePoint 2010 enterprise and InfoPath 2010. I have an external content type that queries a SugarCRM database. Additionally, a list queries that external content type and returns results as expected. I am working on an InfoPath form that needs to access that data via an External Item Picker. Unfortunately, I receive the following vague and useless error: "An error occurred while obtaining business data by using the Picker web service. Contact your system administrator."

I have temporarily set permissions on the external content type such that all authenticated users can access it. (This is in a development environment with dummy SugarCRM data).



Central admin reports the following:

External Content Type Information
Name : SugarCRMContact
Display Name : SugarCRM.BDC.SugarCRM.SugarCRMContact
Namespace : SugarCRM.BDC.SugarCRM
Version : 1.0.0.32
External System : SugarCRMLobSystem
BDC Model : SugarCRMModel
Crawlable : No
Default Action : None



SharePoint Designer reports that I have ReadList and ReadItem as External Content Type Operations.



I have set the following in the External Item Picker Properties control:

ECT Namespace: SugarCRM.BDC.SugarCRM
ECT Name: SugarCRMContact
System Instance Name: SugarCRMLobSystem
Finder name: ReadList
Display Field Name: ContactID
Refresh on Open: Checked
Picker Mode: Connect to External Data Source through SharePoint


I am at a loss as to what could cause this error. Any leads?

Hi,

This is because of the permissions  being set for the BDC Service.  Try publishing the form to the server and access thru browser. It should work.

--

Thanks,

Shan.