<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Data Connections</title><link>https://www.infopathdev.com:443/forums/44.aspx</link><description> </description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Troubles querying an External Content Type (SharePoint 2010) with the External Item Picker</title><link>https://www.infopathdev.com:443/forums/thread/67851.aspx</link><pubDate>Tue, 28 Jun 2011 22:45:20 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:67851</guid><dc:creator>Shankara</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/67851.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=67851</wfw:commentRss><description>&lt;p&gt;Hi,&lt;/p&gt;&lt;p&gt;This is because of the permissions&amp;nbsp;&amp;nbsp;being set for the BDC Service. &amp;nbsp;Try publishing the form to the server and access thru browser. It should work.&lt;/p&gt;&lt;p&gt;--&lt;/p&gt;&lt;p&gt;Thanks,&lt;/p&gt;&lt;p&gt;Shan.&lt;/p&gt;</description></item><item><title>Troubles querying an External Content Type (SharePoint 2010) with the External Item Picker</title><link>https://www.infopathdev.com:443/forums/thread/62869.aspx</link><pubDate>Thu, 06 Jan 2011 20:59:02 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:62869</guid><dc:creator>grizzljt</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/62869.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=62869</wfw:commentRss><description>&lt;strong&gt;Environment: &lt;/strong&gt;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: &amp;quot;An error occurred while obtaining business data by using the Picker web service.  Contact your system administrator.&amp;quot; &lt;br /&gt;&lt;br /&gt;

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).&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;



&lt;strong&gt;Central admin reports the following:&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;

External Content Type Information&lt;br /&gt;
Name : SugarCRMContact &lt;br /&gt;
Display Name : SugarCRM.BDC.SugarCRM.SugarCRMContact&lt;br /&gt;
Namespace : SugarCRM.BDC.SugarCRM&lt;br /&gt;
Version : 1.0.0.32 &lt;br /&gt;
External System : SugarCRMLobSystem &lt;br /&gt;
BDC Model : SugarCRMModel &lt;br /&gt;
Crawlable : No &lt;br /&gt;
Default Action : None &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;

 

SharePoint Designer reports that I have ReadList and ReadItem as External Content Type Operations.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;

 

&lt;strong&gt;I have set the following in the External Item Picker Properties control:&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;

ECT Namespace: SugarCRM.BDC.SugarCRM&lt;br /&gt;
ECT Name: SugarCRMContact&lt;br /&gt;
System Instance Name: SugarCRMLobSystem&lt;br /&gt;
Finder name: ReadList&lt;br /&gt;
Display Field Name: ContactID&lt;br /&gt;
Refresh on Open: Checked&lt;br /&gt;
Picker Mode: Connect to External Data Source through SharePoint&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;

 

I am at a loss as to what could cause this error.  Any leads?</description></item></channel></rss>