Re: SecureStoreCredentials Error while Consuming the External List in InfopathForm

Jim Cantwell — Fri, 21 Dec 2012 21:14:59 GMT

Are you using the External Item Picker, or just a standard List data connection to the SharePoint list?

And does the form work when actually deployed, and not in preview mode?

SecureStoreCredentials Error while Consuming the External List in InfopathForm

Venu585 — Tue, 18 Dec 2012 08:57:08 GMT

Hi,

We have created a External List using BCS in Sharepoint 2010 website

Successfully populated the data from Database table to Sharepoint List.

Now we need access this External List ( customer master list ) in our infopath forms (Full Trust)

On form load in preview it is failing with the error.

Error:

The query cannot be run for the following DataObject: FigaroPaymentDetails
The SOAP response indicates that an error occurred:

http://<servername>:port/_layouts/SecureStoreSetCredentials.aspx?TargetAppId=BDC

we have set permissions to All Authenticated users on ExternalContentType, and Secure Store Service: "Target Application ID"

Everything is working good in Sharepoint List, Why can't i access the List Data in Infopath Form.

Please any ideas,

Regards

Venu585