.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

Remote Debugging error while creating business data connectivity model

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :SharePoint

Hi Everyone,

                  I have a scenario where I have to get the data from two of the stored proc's in the SQL Server and create an assocation between those models.I cannot use Sharepoint designer as there is no relationship existing between those two entities.So,I have used visual studio business data connectivity model to fulfill this requirement.I created the model with filter descriptors,input parameters and all and related those as suggested by MSDN and used LINQ to SQL to pull the actual stored procedure into the readlist and readitem methods.My issue here is,when I debug this project,I am receiving an error message tht says "remote procedure cannot be debugged.this usually indicates debugging hasn't been enabled".Then I changed the debug entry in the web.config to true to solve this issue.But,still I received the same error...what do you think might be stopping me from going ahead..ur suggestions and tips helps me a lot..


Thanks all..


View Complete Post

More Related Resource Links

Error selecting "Business Data Connectivity" service application in MSS 2010 with WCF hotfix on W8R

I'm getting "BDC Metadata Store is Currently Unavailable" when navigating to the External Content Types object in SPD 2010. Hot fix is installed.  No errors in the eventlog? 

External List Error - Access denied by Business Data Connectivity


Hello Community,

Background: In SPS 2010 I created an External Content Type that is displaying the Customers table from a Customers database in SQL Server 2008. (I also added myself as the DBO for that database.) I configured the ECT to authenticate with the User's Identity and to also use the Secondary Secure Store Application ID "contoso\administrators". I then added both these accounts to the Business Data Connectivity Service and granted them all four permission sets. I configured the ECT Operations to perform all operations, and I filtered the return by limiting it to a 100 items.  Using the Create List and Form wizard I then created an External List from the ECT. 

Problem: When I display the External List in the browser I get this error - Access denied by Business Data Connectivity.

I have read several blogs about this issue (which seems to be common) but I still can't resolve it.  Can anyone help?



Tom Molskow - SharePoint Architect -

Business Data Error: System.OverFlowException


I have a Business Data Catalog file I've uploaded to connect to our back end Firebird DBMS through ODBC.

The SharePoint server is MOSS 2007 x64. The web front end server(s) all have an x64 Firebird Engine and ODBC driver with verified connectivity to Firebird.

When I use one of the methods, I can see connections being made to our Firebird server and the query being passed. I know the query returns results (it's a stored procedure with no parameters), but I get the following error "An error occurred while retrieving data from MROTest1. Administrators, see the server log for more information" in IE. If I look in the server logs, I see (12\Hive\Logs)

Exception handed to HandleRuntimeException.HandleException System.OverflowException: Arithmetic operation resulted in an overflow.     at System.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb, Int32& cbActualOut)

Creating .NET Assemblies That Aggregate Data from Multiple External Systems for Business Connectivit

This article describes a quick, four-step process for creating a .NET assembly that BCS can use to retrieve external data for SharePoint Server 2010 by using Visual Studio 2010.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Sample: Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint

Download sample code as you learn to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Video: Getting Started SharePoint 2010: Creating .NET Framework Types for a Business Connectivity Se

This demonstration shows how to use Visual Studio 2010 to create Business Data Connectivity projects that incorporate external data into SharePoint solutions. (Length: 8:33)

Video: Creating Business Connectivity Services Applications in SharePoint 2010

This video drills into creating simple no-code BCS solutions from out-of-box capabilities of SharePoint Designer 2010 to more advanced, complex, custom BCS solutions using Visual Studio. (Length: 9:37)

Video: Creating SharePoint 2010 Business Connectivity Services (BCS) Applications

In this video you will learn about the types of applications that you can create using the BCS. (Length: 8:05)

Module 6: Accessing External Data with Business Connectivity Services in SharePoint 2010

SharePoint 2010 provides a new set of technologies known as Business Connectivity Services for retrieving, editing, updating, and deleting data from external systems.

Creating Custom Business Connectivity Services Connectors Using SharePoint Server 2010

Learn how to create a Business Connectivity Services (BCS) custom connector to integrate data sources into SharePoint Server 2010.

Business Data Connectivity Services Problem

I'm having problems getting Business Data Services to work. When I go into: Central Administration -> Service Applications -> Business Data Connectivity Services I get the error 'keyset does not exist' I've been doing some reading and come to the conclusion it's something to do with authentication? We use NTLM authentication and I'm wondering if we need to set up sharepoint to use kerberos. Does anybody know about this problem? Thanks

SharePoint Designer 2010: Business data connectivity metadata store is unavailable

Running SharePoint Server 2010 RTM. Fresh install in production not via the wizard but a vanilla install and bringing services up one by one. Just brought up the Business Data Connectivity Service. Other services currently up are Managed Metadata Service and User Profile Service. Two web applications with services deployed to both web applications. The scenario below holds true when connecting to a site on either web application. 1) Open a site, i.e., root portal site, in SharePoint Designer 2010 2) Click External Content Types. Error returned: "The Business Data Connectivity Metadata Store is currently unavailable" is returned. 3) Click Ok then click New | External Content Type. Error returned "THe server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults...". The Business Data Connectivity Service status in Central Administration is Started. Any ideas?

Urgent: The business data connectivity metadata store is currently unavailable SP designer

Hi,   I am getting the following error when runnind SP designer and referencing external content types.   The BDC service is running on the server, however if I click the link to configure the service I get:   The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error. and in the event log: The BDC Service application BDCTest is not accessible. The full exception text is: The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error. An exception occurred when trying to issue security token: The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.   Can anyone please help?        

Error while creating Termstore using Object Model

Hi, I'm creating term store Group using object model using the below mentioned code:- string TermStore = drManagedMetadataGroups["Term Store"].ToString(); string GroupName = drManagedMetadataGroups["Group Name"].ToString(); string Description = drManagedMetadataGroups["Description"].ToString(); string GroupManagers = drManagedMetadataGroups["Group Managers"].ToString(); string Contributors = drManagedMetadataGroups["Contributors"].ToString(); try { //Type importManagerType = typeof(ImportManager); //Type[] parameterTypes = new Type[1] { typeof(TermStore) }; //ConstructorInfo constInfo = importManagerType.GetConstructor(BindingFlags.NonPublic | BindingFlags.Instance, null, CallingConventions.ExplicitThis, parameterTypes, null); //if (constInfo != null) //{ TaxonomySession session = new TaxonomySession(web.Site); TermStore ts = session.TermStores[TermStore]; //ts.AddTermStoreAdministrator(@"test-account-01\d39373g"); //logger.LogToOperations(string.Format("Added managed metadata group administrator '{0}' to '{1}'", GroupName, TermStore), EventLogEntryType.Information); if (!M

Bussiness Data Connectivity Service error

Hi I created Bussiness data connectivity service application. I also started this application. When I click on this application I am getting an error message like "The requested service, 'http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc/actas' could not be activated. See the server's diagnostic trace logs for more information. Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: e6a7c44d-9956-4966-9eb5-016235d7126c Date and Time: 9/15/2010 8:53:09 AM  Go back to site " Please let me know the solution of this error. Thank you,
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