[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Sharepoint 2010 Connecting an external list

Posted on 2013-01-24
7
Medium Priority
?
1,172 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
 
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
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

649 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