.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

can't open the list that created from external content types

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#

Hi all,

  I created a external content types file from SQL DB (Northwind), the table is order details, original I created "all operations" then post to list. but when I go back the web site to open this list, I got error message like this :

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:00d1bb01-90b6-4bde-992d-9368199cad64

  so I think maybe this table belong to detail and table include 2 field for primary key, so I delete and re-created to readitem & Readlist then post to web site again.

but I got same error again. does anybody can help me to resolved this issue ?

ps. I used same DB to created order, product and post to Web site, it's working correct.



View Complete Post

More Related Resource Links

Video: External Content Types and Business Connectivity Services for SharePoint 2010

This video discusses the concept of external content types for Business Connectivity Services. (Length: 1:34)

Need to link multiple External Content List items to a single document metadata column

I have an external content list - for my purposes, the data isn't any fancier than a list of terms provided by a web service (read only - I don't need update/delete functionality). I want to be able to link any subset of those terms to a single document metadata column (in other words, I need it to work like a normal content list that is defined to allow multiple values in a column) but SharePoint doesn't let me do that on an ECL. I need the content list to be externally driven since more values are going to be added to an outside system over time, but I think it's possible that I may not need a full-fledged ECL list to make this work this way in SharePoint. Just to clarify: I don't need the metadata values in my documents to maintain a PERSISTENT link to the web service (if someone changes an underlying value in the web service DB, it doesn't need to be updated in the document table too). I just want SharePoint to offer up an updated set of source values from the web service if somebody goes in and edits the document metadata. Any ideas for how I can make this work?

Assigning a reusable workflow to all content types in a list in one operation?

When creating a reusable workflow I choose a base content type. I would really like to assign this workflow to the content type at site collection top level and get it to automatically work in all lists that include this content type, and also have it set to work for all children of this top level content type. It seems to me that I have to manually associate this workflow to all lists and content types? I am missing something here? Henning

"BDC Metadata Store is Currently Unavailable" when navigating to the External Content Types object i

After installing SharePoint 2010 Beta and Sharepoint Designer 2010, opening Designer and navigating to the External Content Types object results in the following error:"The Business Data Connectivity Metadata Store is currently unavailable."Anyone else having this experience?ThanksMark

Client Object Model : Transactional update of list and content types

I am using Silverlight client object model to code against Sharepoint. Essentially, what I want is that when a user clicks a button, An item needs to be added to a list and also a new content type has to be created. button1_click() { //1. Create an item in a list. //2.  Create a new content type. } Also this should be transactional:  only if item is added should the content type be added too, otherwise roll back both. (and vice-versa). My understanding of client object model is that we at the core we are talking to Sharepoint WCF services. So if I say, using(TransactionScope scope = new TransactionScope()) { ClientContext.ExecuteQueryAsync(); scope.Complete(); } can I assume that the updation will be transactional??

BCS : How to assign permissions on external content types so that it has the same permissions as the

  Environment : sharepoint 2010 Active directory authentication guys, I been assigned a new role of administrating sharepoint and been juggling with the best way to manage permissions in BCS. here is an overview I gave certain users edit\ execute\ selectable in clients\ set permissions on the BCS MetaData catalog. These users created the external System and external content types and created lists from these content types, all nice and good. But the problem i am facing now is the BCS list is inherirting permissions from the site ( which is how i want it) but whe these users try to access the BCS List they get the error message "Accces denied by BCS", i can fix this issue by assigning Active directory users\groups Execute\ selectable in client permissions on the extenal content type in BCS but i dont want to do it becasue i cannot select the same sharepoint groups that have permission for the BCS list from here, all i can select from here is AD users and groups. In short what i want to do is assign all those sharepoint groups which has access to the BCS list( which inherits it's permissions from the site) access to the external content type and i want to do this without duplicating the same permissions on external content type and the list. What would be the best way to do it. Sounds complicated but i guess this will be a frequent configuration. thanks samee

Folder inside the List shows Access Denied when try to open using Manage Content Structure

Hi All, We are facing this issue in one of our site, when accessing the folder from Manage content structure. Folder is inside a list which uses a folder content type. When we try to open this folder use manage content and structure it throws access denied. any idea how we can check this as we the permissions are properly inherited and all the folders are checked in . Please update what else we can check.   Thanks, Jasjeet SIngh

external content types DB2

Hello, how can i connect over external content types in SharePoint Designer 2010 to a DB2 database? Thanks for your answer.

SharePoint Designer External Content Types with WCF


I've created a basic WCF service using an edmx model and service class that only contains the code below (takes 10mins to set up). I followed this link as instructions http://msdn.microsoft.com/en-us/data/cc745957.aspx

public class GRef_Service : DataService<MasterDataDirectoryEntities>
  // This method is called only once to initialize service-wide policies.
  public static void InitializeService(IDataServiceConfiguration config)
    // TODO: set rules to indicate which entity sets and service operations are visible, updatable, etc.
    // Examples:
    config.SetEntitySetAccessRule("*" , EntitySetRights.AllRead);
    // config.SetServiceOperationAccessRule("MyServiceOperation", ServiceOperationRights.All);
    //config.SetServiceOperationAccessRule("GRef_Building", ServiceOperationRights.AllRead);


When I view it in my site

BCS Method Security / External Content Type Permissions / Custom List Security Provider / Security T


I have an external list setup with the usual CRUD methods.  The external SQL table is also being populated by another source.  I want to enable/disable deleting depending on whether the record was created from SharePoint.  I would also like the normal list permissions to work.  So if a user has permissions to delete on the list, they can only delete items created for SharePoint. 

Where should this logic be incorporated?  On the BCS Delete method, somewhere in the External Content Type or on the list instance?  Most examples I find relate to security trimming for search.  I'm only concerned about the delete method.

I'm sure there are multiple ways to accomplish this.  Which is the best?


Custom Action for specific External Content Type List


I have an External Content Type list instance feature in Visual Studio. Deploying the instance works fine. However, I can't create a custom action using RegistrationId="{$ListId:Lists/yourlistname;}" RegistrationType="List"

Even if I specify the list Id as follows RegistrationId="{8F595340-5D08-4287-8BF6-30D50989D2F4}" or RegistrationId="8F595340-5D08-4287-8BF6-30D50989D2F4" I get nothing.

However, RegistrationId="600" works fine, but for all External Content Type lists.

I added the custom action with SharePoint Designer and it works as expected. When I generate a site template and import it into Visual Studio, the custom action uses RegistrationId="{$ListId:Lists/yourlistname;}" RegistrationType="List"

Creating a new site based on the site template creates the custom action correctly. However, deploying just the custom action does not work (feature deploys, but no custom action appears). I also tried RegistrationId="0x0100D67E541CC4BB6A4A9D62D22657ECFF68" RegistrationType="ContentType" with no luck. The content type id was pulled from the list instance using the object model.

I have to tie the custom action to a specific list instance. Because the li

External content types are not working in SharePoint 2010 Web Front End in DMZ


I have discovered that my Web Front End server will try to connect directly to the SQL server I have listed in my external content type.  I am able to render the contenct properly on my SharePoint 2010 App server, but when I try to render the list on the DMZ server I receive Cannot connect to the LobSystem (External System).   Is there a way around this?  I would like my Web Front End to connect only to my SharePoint 2010 App tier which has access to all of the databases in my infrastructure.  The Web Front End only has access to the App tier.



BCS: Best practice of Toggling external content types between staging and production databases



Environment :
Sharepoint 2010
using BCS to point to external database
create two Secure Store Application ids , one with production credentails and another with staging credentails

I have several external content types (ECT) using an external system(ES) pointing to staging databases.
Now i want to change only one of my ECT to point to production DB but suprisingly the only way i could achieve this was by modifying the ES that all the other ECT are using, this is not practicaly because this makes all the ECTs point to production and not just the one that i want.

Question is how can i have different ES and how can i make only one ECT out of all the ones to point to production, i tried using the "Switch connected systems" but did not like it and below are the details:

Created a new ECT pointing to production which would show the ES being used in BCD services and then i  used the "Switch Connected Ssytems" option under designer to switch the staging ECT to the production ES. Dos the job but the problem is that if there are no ECT pointing to staging ES then it does not appear under BCS services which mean neither can i switch my ECT back to it nor would it be available when i am creating new ECT whch need to point to staging.

Hope i was clear, please suggest how to handle this sit

Edit form List for External content type



I've made a list based on an extenal content type and create an InfoPath form just for viewing details on list items (read only)

My problem is that  the page(displayifs.aspx) displaying this form doesn't have a title (it's blank) and I don't know how to change it.



Sorin Sandu

SharePoint Designer 2010 External Content Types Data Source Already Exists in Business Data Connecti


I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer.  Later I changed some column names in the table.  I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the Business Data Connectivity Metadata Store and it refers to a different data source.  Cannot complete operation generation.  Add a connection to this data source with a different name and try again." 

I re-created the Secure Store using a different name in SharePoint 2010 Central Administration.  I didn't find the option to choose the connection name in SharePoint 2010 Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.

External Content Type - Read List Operation - "Cannot find a collection element of a supported type.


I'm trying to define External Content Type Operations for an External Content Type. I can add a Connection, Type "WCF Service" no problem. And I can define a "New Read Item Operation" using that connection.

But I can't define a "Read List Operation". I get the following error message, in the Return Parameter Configuration: "Cannot find a collection element of a supported type..." it goes on to say - see the help documentation for supported types. I can't find any help documentation on this.

I've tried returning different types in the provider web service but keep getting the same error. What are the supported types the web service can return?

The reading I've done suggests that you can connect to a non-MS web service using a connection type of "WCF Service". Is this correct? If it is what's the best soap format the web service provider should use - Doc/Literal?



Duplicate Fields during list creation from content types and site columns


I am trying to create a List in Sharepoint 2010 using Site Columns and Content Types. It results in creating duplicate fields in the list for the Site Columns used. Here is the details description of what I was doing.

I have created two site columns 


<Field Type="Number" DisplayName="Start Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Group="QMS" ID="{A3F2D108-11B5-4B49-9633-338D27227E12}"
Name="StartCoordinate" Overwrite="TRUE" />

<Field Type="Number" DisplayName="End Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Group="QMS" ID="{06B927BB-C354-4A0A-AE88-9C14E55EAB27}"
Name="EndCoordinate" Overwrite="TRUE" />

Then added these to a new content type I

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend