Solved

Sharepoint 2010 Connecting an external list

Posted on 2013-01-24
7
1,003 Views
Last Modified: 2013-02-10
I created an External Content Type in Sharepoint designer 2010 to a sql table. But when I try to access it through and external list in Sharepoint 2010. I get the following error.

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:4c6656aa-e838-46cd-bfa8-31aceff14693
0
Comment
Question by:Justin Perry
  • 4
  • 2
7 Comments
 
LVL 9

Expert Comment

by:kukdai
ID: 38815604
how you created the external content type does it have the read methods to render the content  in the external list.

Make sure you followed this way

http://blog.libinuko.com/2010/04/10/sharepoint-2010-how-to-create-external-content-type/

http://www.mstechblogs.com/sharepoint/en/how-to-step-by-step-creation-of-external-list-in-sharepoint-2010/
0
 

Author Comment

by:Justin Perry
ID: 38815797
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 38816155
Hi,
can you verify the ULS log and attach the details of the error (using the correlation id)?

To view the ULS Log there is a nice utility:
http://sharepointlogviewer.codeplex.com/

HTH
Rainer
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 9

Expert Comment

by:kukdai
ID: 38816213
go to your central admin and check for service application.

Select the bcs service application from the ribbon click on manage.

then it should list the lists of external content types in the current farm.

now click on the menu of the external content type and click on set permission.
Check if there, authenticated users has permission of execute on this content type or not.

if not provide them the permission to execute.
now try again.
another thing is try opening your external content type in SharePoint designer does it shows some records or not.
0
 

Author Comment

by:Justin Perry
ID: 38816358
This is the logs for the Correlation ID when I tried to load the page.
Logs.log
0
 

Accepted Solution

by:
Justin Perry earned 0 total points
ID: 38856857
I figured out that the list I was trying to bring over was over 2000 items. Once I added a filter the list work perfectly.
0
 

Author Closing Comment

by:Justin Perry
ID: 38872803
I figured out a solution
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now