locked
Error while accessing the External list in sharepoint 2010. RRS feed

  • Question

  • Hi all,

    When i am trying to access the External list created in sharepoint 2010 getting following error message

    Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

    Correlation ID:8bf3a54c-927c-44a9-84e9-64b4a0e64c90

    i verified the ULS log and found following error message

    Error while executing web part: Microsoft.BusinessData.Infrastructure.BdcException: The shim execution failed unexpectedly - Access is denied.. ---> Microsoft.Office.SecureStoreService.Server.SecureStoreServiceException: Access is denied.

    at Microsoft.Office.SecureStoreService.Server.SecureStoreServiceApplicationProxy.Execute[T](String operationName, Boolean validateCanary, ExecuteDelegate`1 operation)

    at Microsoft.Office.SecureStoreService.Server.SecureStoreServiceApplicationProxy.GetRestrictedCredentials(Guid rawPartitionId, String applicationId)

    at Microsoft.Office.SecureStoreService.Server.SecureStoreProvider.GetRestrictedCredentials(String appId)

    at Microsoft.SharePoint.BusinessData.Infrastructure.WindowsAuthenticator.ExecuteAfterLogonUser(Object[] args, ISecureStoreProvider ssoProvider, String ssoApplicationId, Boolean useSensitiveSsoCreds)

    at Microsoft.SharePoint.BusinessData.Infrastructure.WindowsAuthenticator.ExecuteAfterLogonUser(Object[] args, ISecureStoreProvider ssoProvider, String ssoApplicationId)

    at Microsoft.SharePoint.BusinessData.SystemSpecific.Db.DbConnectionManager.GetConnection()

    at Microsoft.SharePoint.BusinessData.Syste

    mSpecific.Db.DbSystemUtility.ExecuteStatic(IMethodInstance methodInstance, ILobSystemInstance lobSystemInstance, Object[] args, IExecutionContext context)

    at Microsoft.SharePoint.BusinessData.Runtime.DataClassRuntime.ExecuteInternalWithAuthNFailureRetry(ISystemUtility systemUtility, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IParameterCollection nonReturnParameters, Object[] overrideArgs)

    at Microsoft.SharePoint.BusinessData.Runtime.DataClassRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs) -

    -- End of inner exception stack trace ---

    at Microsoft.SharePoint.BusinessData.Runtime.DataClassRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs)

    at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.ExecuteInternal(IDataClass thisDataClass, ILobSystemInstance lobSystemInstance, ILobSystem lobSystem, IMethodInstance methodInstanceToExecute, IMethod methodToExecute, IParameterCollection nonReturnParameters, Object[]& overrideArgs, IFilterCollection filters)

    at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.ExecuteFiltered(IEntity this, IFilterCollection filterCollection, IMethodInstance methodInstanceToExecute, ILobSystemInstance lobSystemInstance)

    at Microsoft.SharePoint.BusinessData.Runtime.EntityRuntime.<FindFiltered>b__3(IEntity e, IMethodInstance mi, IFilterCollection fc, ILobSystemInstance lsi)

    at Microsoft.SharePoint.BusinessData.Runtime.EntityInstanceEnumeratorFactory.CreateEntityInstanceEnumerator(IEntity entity, IMethodInstance methodInstance, IFilterCollection filters, ILobSystemInstance lobSystemInstance, ExecutionCallBack executionCallBack)

    at Microsoft.SharePoint.BusinessData.MetadataModel.Static.Entity.FindFiltered(IFilterCollection filterCollection, String finderName, ILobSystemInstance lobSystemInstance)

    at Microsoft.SharePoint.SPListDataSource.GetEntityInstanceEnumerator(XmlNode xnMethodAndFilters)

    at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstancesInternal(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)

    at Microsoft.SharePoint.SPListDataSource.GetFilteredEntityInstances(XmlDocument xdQueryView, Boolean fFormatDates, Boolean fUTCToLocal, String firstRowId, Boolean fBackwardsPaging, String& bdcidFirstRow, String& bdcidNextPageRow, List`1& lstColumnNames, Dictionary`2& dictColumnsUsed, List`1& mapRowOrdering, List`1& lstEntityData)

    at Microsoft.SharePoint.SPListItemCollection.EnsureEntityDataViewAndOrdering(String& bdcidFirstRow, String& bdcidNextPageFirstRow)

    at Microsoft.SharePoint.SPListItemCollection.EnsureListItemsData()

    at Microsoft.SharePoint.SPListItemCollection.get_Count()

    at Microsoft.SharePoint.WebControls.SPDataSourceView.ExecuteSelect(DataSourceSelectArguments selectArguments, String aggregateString, Boolean wantReturn, BaseXsltListWebPart webpart, SPListItem& listItem, SPListItemCollection& listItems, String[]& fieldList)

    at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigatorInternal()

    at Microsoft.SharePoint.WebControls.SingleDataSource.GetXPathNavigator()

    at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform(Boolean bDeferExecuteTransform)

    I followed the below link for the creation of secure sore application

    1) http://blogs.msdn.com/sridhara/archive/2010/01/27/setting-up-bcs-with-secure-store-application-impersonation.aspx
    2) verified the user access
    3) user account is not blocked
    4) verified the database access to the user
    5) Refreshed the Key, iis reset of the server
    6) Verified the Credentials and permissions of the Target Application ID.
    7) Verified the permission of External Content type and lists

    But still i am getting the error message.

    Do anyone have idea on this.

    Thanks!
    Sunitha

    Wednesday, August 8, 2012 8:32 AM

Answers

  • Hi Sunitha,

    Can you delete the Secure Store Application and re-create it (steps 7 to 14). However this time please set the Target Application Type as User instead of Group. Other than suggesting this, i really can't imagine what else could have gone wrong earlier.

    Regards,

    Nauzad Kapadia.


    Please "Mark as Answer" if a post has answered your question or "Vote as Helpful" if it was helpful in some way. Here's why

    • Marked as answer by star.wars Friday, August 17, 2012 10:55 AM
    Thursday, August 9, 2012 10:50 AM

All replies

  • Hi sunitha,

    Can you provide more infomation related to your BDC Model and ECT.

    Have you created is using Visual Studio or SD. Is it connecting to a database or a web service? If it's a database are you using integrated security to connect to the database?

    Regards,

    Nauzad Kapadia


    Please "Mark as Answer" if a post has answered your question or "Vote as Helpful" if it was helpful in some way. Here's why

    Wednesday, August 8, 2012 8:59 AM
  • HI Nauzad,

    Thanks for the reply.

    I have created the ECT using SD and imported it to the Sharepoint, the setting of BDC Model and ECT done as per the link below

    http://blogs.msdn.com/sridhara/archive/2010/01/27/setting-up-bcs-with-secure-store-application-impersonation.aspx.

    Its connecting to a database, yes i am using the integrated security to connect to the database.

    Thanks!

    Sunitha

    Wednesday, August 8, 2012 9:08 AM
  • Hi Sunitha,

    Does the ECT work if you don't try to use Secure Store application?

    Also can you start a profiler trace to see what is the account under which a connection to the database is being established?

    Regards,

    Nauzad Kapadia.


    Please "Mark as Answer" if a post has answered your question or "Vote as Helpful" if it was helpful in some way. Here's why

    Wednesday, August 8, 2012 9:34 AM
  • Hi Nauzad,

    How can i check whether the ECT works without using the Secure Store application?

    I verified the Database connection establishment, it using the correct user account to access.

    Thanks!

    Sunitha

    Wednesday, August 8, 2012 11:06 AM
  • Hi Sunitha,

    To connect without using the Secure Store application, you can open the ECT using SharePoint Designer and click on the External System link.

    In the Connection Properties dialog box, change the Authention Mode property to User Identity.

    If this works, then the problem is in the configuration of the Secure Store application.

    Regards,

    Nauzad Kapadia


    Please "Mark as Answer" if a post has answered your question or "Vote as Helpful" if it was helpful in some way. Here's why

    Wednesday, August 8, 2012 11:40 AM
  • Hi Nauzad,

    I tried the above option and it works. After changing the Authention Mode property to User Identity, what's the next step i have to follow to view the list without having the configuration of the Secure store application.

    Thanks

    Sunitha

    Thursday, August 9, 2012 7:21 AM
  • Hi Sunitha,

    So now we have identified that the problem is with the Secure Store Application that you have created.

    So to make sure that you have configured it correctly, can you provide exact answers to the following questions -

    1. What was the user account you use to log into SharePoint.

    2. What infomation did you specify step 13 of the blog post that you had followed. Basically for debugging, the credential owner should match the answer to question 1 and the Windows user name should be specified in correct format (domain\user) and that user should have permissions to connect to the database.

    Regards,

    Nauzad Kapadia.


    Please "Mark as Answer" if a post has answered your question or "Vote as Helpful" if it was helpful in some way. Here's why

    Thursday, August 9, 2012 9:56 AM
  • Hi Nauzad,

    For both the questions i am using the user account called GDFN\IPL_Content_Dev and connecting the database using the same account.

    Thanks!

    Sunitha

    Thursday, August 9, 2012 10:39 AM
  • Hi Sunitha,

    Can you delete the Secure Store Application and re-create it (steps 7 to 14). However this time please set the Target Application Type as User instead of Group. Other than suggesting this, i really can't imagine what else could have gone wrong earlier.

    Regards,

    Nauzad Kapadia.


    Please "Mark as Answer" if a post has answered your question or "Vote as Helpful" if it was helpful in some way. Here's why

    • Marked as answer by star.wars Friday, August 17, 2012 10:55 AM
    Thursday, August 9, 2012 10:50 AM