.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

Error Creating External Content Type using Sharepoint Designer 2010

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :SharePoint
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.

View Complete Post

More Related Resource Links

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.

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.  "

Error creating Read Item or Read List operation in Sharepoint Designer 2010

In terms of high-level requirements, I need to pull in lists from a couple of different web apps.  To do this, I’m using SPD 2010 to create an External Content Type for the list of interest.  I’m able to create a SOAP Service or WCF Service connection just fine.  However, when I try to create the external content type and create a Read Item Operation on one of the GetList or any other Get* (or other Update methods for that matter) methods, I get the following error:"The method that your operation is based on has parameters with complex types that do not have default parameterless constructor.  This kind of data source methods cannot be used in Business Data Catalog."I tried defining an operation on the “AddAttachment” method, and that worked just fine.  I also tried providing default values to the listName and viewName parameters when creating the SOAP Service connection, but still get the error.  Same issue with a WCF Service connection as well. Does anyone know if this is a 2010 issue, or am I approaching this requirement incorrectly?  What are other approaches for connecting to lists that reside in a different web app than yours? 

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.

Error When Creating on External Content Type



- 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 ?






Sharepoint Designer crashing when trying to add new External Content Type


When I try to create a new External Content Type, the Sharepoint Designer crashes

I've installed the WFC fix before installing Sharepoint 2010 beta, that got rid of the initial problem I had with the message "The Business Data Connectivity Metadata Store is currently unavailable."

I've tried recreating the BDC (delete and create unter Manage Service Applications, but that didn't help.

Any suggestions?




Stopped working

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: spdesign.exe

Problem Signature 02: 14.0.4514.1004

Problem Signature 03: 4abf183b

Problem Signature 04: mscorlib

Problem Signature 05:

Problem Signature 06: 4a27471d

Problem Signature 07: 4212

Problem Signature 08: a9

Problem Signature 09: System.TypeInitialization

OS Version: 6.1.7600.

Locale ID: 2055


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 ?

SharePoint 2010 External Content Type and InfoPath 2010 - Numeric data type fields missing in InfoPa


Connected SQL data table to SP 2010 ECT from SQL table.  The SQL table has several fields that have a type of "numeric(3,0)".  The SP 2010 list shows all fields form SQL.  When we open up InfoPath Designer and reference the SP List data (from SQL) all of our numer fields are missing from the available fields list.

I amd going to try another data type but that hardly feels like a solution.  If anyone has any ideas please let me know!

sharepoint designer 2010 error when creating a new template


Hi all, I'll provide a little background detail in the hope that maybe I'm approaching the task the wrong way or my  method is better done via other ways?

I work in a education establishement, we already have our branding on the 2003 version and having recently seen some of the impressive work done in 2007 so wanted to implement branding on the new 2010 version.

Through using one of the basic sharepoint services 2010 templates I wanted to try a little basic re-branding to start off with and see how simplified the process would be, I already have Designer 2010 installed.

A test subsite was created under the 2010 'root' area and opened up in designer 2010. I could immediately see the main areas containing any logo and other branding features was greyed out so effectively editing of master pages was disabled. This was overcome by a little research and finding out I had to enable editing of master pages / templates through the site admin area. I was immediately given access to all master pages (default.master, starter.master and v4.master - which I understand 4v is actually the 'main' master page used?

Here is where the problems begin.....I'm using designer 2010 but each time I create a page based on a master template layout, designer provides the error message 'Sharepoint Designer:

error in sharepoint 2010 designer while saving:"Content in the embedded form may be changed by the t

I am doing development  in sharepoint 2010 and facing this very weird problem.
If I create a site page with the sharepoint look and feel for that site and try to save the site page,i am getting this error:**"Content in the embedded form may be changed by the the server to remove unsafe content.Do you want to reload your page to see the results of the save? "** and when i say reload,the server removes some parts of my page, e.g onclick event of html,asp buttons.

This error just comes for any sharepoint site page,e.g i took a copy of 'How To Read Library' page just edited the text part of taht page,and when i try to save this error again comes up.

However,if i create a simple aspx page with only htmltags like head body,then thr is no problem ,everything works great. But sharepoint look and feel pages are giving troubles while saving.

has anybody seen this earlier,what could be the reason for this?


SharePoint Designer 2010 workflow specified in Content Type retention policy not starting



I have a SharePoint Designer 2010 resuable workflow that uses the "Start Approval Process" Task Action. This workflow needs to run after a document has been declared a record. So I have a Content Type that has an Information Management Policy (IMP) attached to it. And I have 2 retention stages specified in the IMP. The first retention stage action is to run the workflow. And this Content Type is associated with the Document Library containing the records. But for some reason, the SPD workflow never gets triggered. The document has been successfully declared as a record. I also see in the document's "Compliance Details" screen, the "Scheduled Occurrence Date" is set to the proper date, but the workflow never got started on that date. I tried it with different dates that I set in the document, to ensure that the workflow runs on "Scheduled Occurence" dates such as 11/19/2010, 11/20/2010 to no avail.

What am I missing? Any help/suggestions would be greatly appreciated as always.

Best regards,
Kiran K

How exactly does a SharePoint 2010 External Content type / list work?



I'm trying BCS on an SQL table which contains about 300,000 rows. Following is what I've observed:

1. A "SELECT * FROM <TABLE>" query fired on the SQL Table using SQL Management Studio returns all the result in 12 seconds
2. The same data when accessed by browsing the default view of external list (to which an External Content Type (ECT) built over the same SQL table in SharePOint Designer 2010 is attached) takes about 3:14 minutes

If I edit the ECT (using SharePoint Designer) and set limit as 100,000, it takes about 49 seconds to load, and further reduction in limit reduces the time to load.

My questions are:

1. What is it that causes so much delay in accessing the rows, as SQL delivers them in 12 seconds? Can anyone please help me understand the BCS / ECT architecture- how it accesses data, etc.
2. Can I implement paging in ECTs created using SharePoint Designer 2010?

Any help shall highly be appreciated. Thans in advance!


Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Video: Creating Workflows in SharePoint Designer 2010

This demonstration shows how to create a powerful list workflow with code-style logic by using SharePoint Designer 2010. (Length: 8:15)

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)

Error - when creating externalContentType by SharePoint designer


Hello ,

- I have create a web Service by VisualStudio .

- Then I Publish it to IIS .Then I test it and eveything is fine .

-  I open SharePoint designer . Then Create ExternalContentType.

- I choose DataSourceType : wcf service .

- I set "ServiceMetaDataUrl" and "ServiceEndpointUrl"  :  http://serverIp:portNumber/service.asmx.

when Press ok  . I get the following error   "There was an error generationg xml document" .

How Can I solve this error .



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