SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to get data form SqlServer2008 in SP2010 with the hep of BCS. I have created External List Successfully,but when I go to my Site I get 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. I have tried second approach on this link

I am not getting what is going wrong.

I am just trying to get 100 records Thanks in advance.

share|improve this question
Please, provide uls log message. Copy correlation id, go to`c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS` open most recent log file and filter records by this correlation. – Kai Jan 19 '12 at 11:29
Correlation ID:ecad187f-c0fb-4064-aca8-ff7d5086c092 I am new to SharePoint.. About Logs I couldn't find LOGS folder/file under "c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14"(I am not working on Server Machine) – Dnyanesh Deshpande Jan 19 '12 at 11:53
it's hard to say something without stack trace, or error message. – Kai Jan 19 '12 at 12:38
Correlation ID:87ed3586-9dbe-48e1-82ef-6032ba9d73ef – Dnyanesh Deshpande Jan 19 '12 at 13:45
01/19/2012 19:07:22.24 w3wp.exe (0x1D14) 0x321C Business Connectivity Services Business Data 9f5y Medium Calling GetMetadataObjectById with Id 2010 87ed3586-9dbe-48e1-82ef-6032ba9d73ef – Dnyanesh Deshpande Jan 19 '12 at 13:49

I think your BCS data doesnt have the enough permission... To set the permission.. Go to Central Admin>>>Business Data Connectivity Service>>>Your BCS Connection>>> Assign permission for it using the ribbon...

share|improve this answer
Thanks Paddy I checked for permission,permissions are already set..Still error is there – Dnyanesh Deshpande Jan 19 '12 at 11:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.