Solved

Sharepoint 2010 Connecting an external list

Posted on 2013-01-24
7
1,049 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

813 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