.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

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

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#
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.  "

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.

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.

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


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

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 ?






Create View in an External List that Gets a Field from Another External Content Type via Foreign Key


I currently have two tables in a SQL Server 2k8 database: Locations and Customers

The fields in the Locations table are:

  • LocationName
  • StreetAddress
  • City
  • State
  • ZIP
  • CusotmerID (foreign key joined to Customers table)

The fields in the Customers table are:

  • ID (primary key)
  • CustomerName
  • CurrentBalance

Through SharePoint Designer, I have both tables set up as External Content Types of the same names as the tables and have created External Lists for each External Content Type. All CRUD operations are working perfectly. I added the proper Assocaiation and I've set CustomerName to be the Title of the Customers External Content Type. I can currently use a picker for CustomerID in the Locations List and CustomerName is displayed properly. Also, the default DispForm also correctly displays the CustomerName for any single Location record.

However, I would like to modify the default ReadList so the foreign key (CustomerID) will show the Title field of Customers (CustomerName). However, I am running into trouble finding out how to do this.

Any help with this issue would be greatly 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 ?

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!

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?


How to create a custom content type with own custom view ,add, edit and delete form in sharepoint fo


How to create a custom content type with own custom view ,add, edit and delete form in sharepoint foundation server 2010 using visual studio 2010?

I donot want to use default form "form.aspx".

we can use my custom form in place of "form.aspx"?

Error: There are no items to show in this view. SharePoint Designer 2010


Hi, i got this error while editing a sharepoint subsite in SharePoint Designer 2010. We are using SharePoint 2010, Office 2010, Windows 7 and SharePoint Designer 2010 x32.

When i now open my subsite in SharePoint Desinger i cant see any Lists and Libraries, no Workflows and no Site Pages. I get these messages:

"There are no items to show in this view."
"The Document Library view connot be displayed for this Web site."

All the Libraries and Files still exist and i can view the sites still in browser. I see them at "all files". But i cant edit anything or change things.

Does anybody know that issue? What can i do to fix that?

Best regards

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!


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

Error: Updating Site Content Type Failed - InfoPath 07/SharePoint 07


I have been working with InfoPath07 and SharePoint Moss 07 for two years.  I have recieved the Updating Content Type error in the past which I got around by creating new library's. This was over a year ago and happened only a couple times.

Recently, my dept did a database migration.  About 3 weeks prior to the migration I started having troubles with publishing InfoPath.

First issue, it would take about three hours for my form to go through to the form/document library.  Sometimes they would publish, other times I would get Updating Content Type Failed.

Now that our databases have been migrated, I don't have to wait three hours to get my error.  I get my error on (1)existing forms that just needed interface updated (no changes to forms content), (2) existing forms that have no content at all, (3) and brand new forms that have never existed, with no content.

I have tried:

  • Deleting some content (fields)
  • Deleting all content
  • Deleting the entire library and starting fresh (including any content types in Central Admin or workflows associated)
  • Creating a brand new form with no content type

I have been researching and trying to figure this issue out for at least three months. I am still getting this error with every form I publish to update the forms library; howe

error with "Create new content" type Translation Management Library


I added the Translation Management feature today, using the following command line:

stsadm -o activatefeature -name TransMgmtlib -url http://mysite

everything seemed to work fine, as no error occurred at this stage, and when I go to my top level site settings, click on "Site libraries and lists", then "create new content" I now see "Translation Management" as an option.

I select this type, click Create, complete the first part of the 'wizard' (Name and Description, etc.), then I'm on step 2 and this is where the error occurs. 

  1. The Workflow select box is disabled, and from the articles I've read this should be usable.
  2. More critically, when I complete this form and click Next, I get a server error:

    Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. 

I've googled around, and tried updating various items in my web.config and machine.config, but I cannot find the solution. A lot o

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