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

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

Error When Creating on External Content Type

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :SharePoint


- I have a  SharePoint site . Then I Open my Site by SharePoint designer .

- When I press on "ExternalContentType" to create a new one  , but the following Error appeared :

     "There is no Business data connectivity service associated with the current web context" .

     How Can I solve this problem ?






View Complete Post

More Related Resource Links

Error Creating External Content Type using Sharepoint Designer 2010

I am trying to create an external content type using Sharepoint Designer 2010. I ran SD on my local machine and connected to a site on some other machine running Sharepoint Server 2010. The Db on which I want to create my ECT resides on my local machine. When I try to use User Identity to connect to my local Db server, it gives me the error that login failed for user <my domain username>. I have both sql server and windows authentication mode login enabled on my sql server. Any help in this regard is appreciated.

Error during creating External Content Type



I am having Sharepoint 2010 Enterprise RTM Trial on Windows Server 2008 SP2 with SQL server 2008 enterprise installed. I have another machine (mac2) on the domain having another Database  on SQL Server 2005. I want to use business connectivity services for External Content types for making a connection with mac2 database  . I have followed the following article:


In step 3 of the above mentioned article, i have failed to connect with User Identity selected....

Can anybody help me out with this ?

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Workflow for External Content Type (Associated List) Gives Error


Hello Community.

Background: I have created an external content type, and then an external list from the content type.  Next I created a custom list with the same metadata fields as the external list.  All this works as it should with no issues.  Finally  created a simple 1 step workflow that is designed to update the external list with the data provided in the custom list. 

Problem: When I run the workflow I get the error below:

The workflow could not update the item in the external data source. Make sure the user has permissions to access the external data source and update items. Unknown error
 12/3/2010 8:39 AM Error  System Account

Has anyone seen this before and if so how did you resolve it?



Tom Molskow - SharePoint Architect - Linked-In - SharePoint Gypsy

when i tried to create new external content type in sharepoint designer in ribbon it show error like

when i tried to create new external content type in sharepoint designer in ribbon it show error like  "  The server was unable to process the request due to an internal error, for more information about the error, either turn on includeexceptiondetailsinfaults (tither from servcebehaviorattribute or from the <servicedebug> configuration behavior) on the server in order to send the exception infromation back to the client, or turn on tracing as per the microsoft .net framework 3.0 sdk documentation and inspect the server trace losgs.  "

BCS Updater Method in External Content type


HI, I have a List (External Content type ) with CRUD methods written.for example. Employee with fields






If want to update only Remarks field and want to display the other fields.(other field should not be editable). How can i do it throught VS2010. If I made those fields readOnly and preupdaterField true. those fields not displays while editing. I want to show those fields but not to edit. any suggestions????

2)while displaying (ReadList )if I want to display only EmpName and EmpID.How can i do it?


or please try to give some links about all the properties for a Type Decriptor and how they are related with CRUD methods.



Insert Image column in External content type

Hi,   I've created an external content type. It pulls in data from SQL Server Database. I need to have the first column as an image based on the value of one of the columns. Could anyone please suggest how to add a column so represent an image in external list.   Regards, Zia

BCS : How to set permissions to an external content type's method

guys, Environment: sp 2010, BCS using SPD I have created an external content type from a LOB sql server 2008 DB, created list and form pages, created read, update, delete, edit methods( all the default operations that SPD shows), from the list page i am able to read and write data back the LOB DB also successfully. Also i know there are permissinos that i can set on the external content type but the problem that i am facing is that i dont see any place\ option where i can assign\ restrict permissions of the content type's method to a certain SP group from neither CA nor SPD i.e if i want a certain group to have only execute permissions only on READ method. Would be great if anyone can tell me if at all this is possible. thanks sameer

Content Type Deployment Error


I got this error

Error occurred in deployment step 'Activate Features': The content type with Id [GUID] defined in feature [GUID] was found in the current site collection or in a subsite.

Any ideas???


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

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

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?



Creating a Site Column that Looks up an External List causes error when saving site as a template.


I'm not sure what the best practice is here, but I'm having a major issue trying to save sites as templates and I think I narrowed it down as to what the issue is.

When I try to save a site as a template, it creates the solution package, but it doesn't activate it.  When I try to activate it manually, I get the following error:

Feature definition with Id e9431ed5-27b1-4c33-9eeb-81b4ace9d372 failed validation, file 'test1ListInstances\ElementsFields.xml', line 481, character 231: The 'SystemInstance' attribute is not allowed.

I opened up the solution package and looked at the ElementsFields.xml file.  I traced the line to this:

<Field Type="BusinessData" DisplayName="Acme People Name" Required="FALSE" EnforceUniqueValues="FALSE" Group="Custom Columns" ID="{55b3bbba-a7e3-4698-9946-648a6b726e9e}" SourceID="{026904fd-f2d0-4e57-a239-c6da838458fa}" StaticName="Acme_x0020_People_x0020_Name" Name="Acme_x0020_People_x0020_Name" SystemInstance="ACME" EntityNamespace="http://????????:28241" EntityName="People" BdcField="FullName" Profile="" HasActions="True" SecondaryFieldBdcNames="0" RelatedF

Creating Content Type in a Hub and creating lists based on this content type



I am building a prototype of a Sharepoint app and I am new to this technology. We have a need for a piece with News items. Someone comes to a sharepoint site and adds a news piece there. This news content piece needs to be approved and to do that approver goes to a staging environment where they can see this news post in proper context (of how it would look in production) and can approve it. If they reject it, news piece never gets propagated to pro environment which also subscribes to this content type.  What I did was I created content type hub with a "News" content type in a Content Type hub and subscribed other sites to this hub. I can see this content type in subscribing sites.

I have following questions regarding this problem:

- Is it the right architecture for such a task?

- I am trying to create a list which would manage adding and editing of news items but I can't find any option to bind a custom list with content type, I can add site columns to a list but I am not able to base a list on a content type.

Thanks for your input.

Problem while creating task with custom content type in sharepoint workflow


Hi all,

I am trying to create task with custom content type in sharepoint statemachine workflow. But it is showing "Error Occured" after task creation code is excecuted. can anyone tell me what is the problem.

Task Content type


  <ContentType  ID="0x01080100A707C0079E8547c0A87515457DB90629"
      Description="Workflow Task"
      <FieldRef ID="{9da97a8a-1da5-4a77-98d3-4bc10456e700}" Name="MyComments" DisplayName="MyComments"  />
      <XmlDocument NamespaceURI="http://schemas.microsoft.com/sharepoint/v3/contenttype/forms/url">
        <FormUrls xmlns="

Infopath External Content Type Pickers


Greetings ,

i have two external content types (manager, worker) defined in sharepoint 2010. On my infopath 2010 form i have 2 external content type pickers. Now each of these pickers works fine on its down and returns me the full list of all managers or workers, but what i want to do is connect the two. So when the end user attempts to select an employee it would only show employees who have a manager_id equal to what was put in the previous external content type picker(manager).

Could this be achieved by using a combo of Association and filters?







hikin, bikin, coding machine
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