Solved

SharePoint 2010 - SharePoint: Business Data Connectivity Service Application Not Accessible

Posted on 2014-04-02
2
401 Views
Last Modified: 2014-04-03
I created the following SCOM alert this morning for our sharepoint app server "SharePoint: Business Data Connectivity Service Application Not Accessible Resolution state: New" I confirmed the BCD services were running. I tried to look at the Sharepoint log for the time frame the error accured but not see why this message was generated.

- Everything seems to be working fine and nothing has changed in our enviroment.

1) How can I "test" to make sure th BCD service is working correctly to make sure this error doesn not happen again.

2) I still would like to know what caused it to be trigger in the first place.
0
Comment
Question by:compdigit44
2 Comments
 
LVL 15

Accepted Solution

by:
colly92002 earned 500 total points
ID: 39974634
If you want to test BCS works then the most obvious thing to do is find a site that uses it and see if that is functioning correctly.

Failing that, check Central Admin, Services on Server, and check that Business Data Connectivity Service  is in the"Started" state.  Then check Service Applications and make sure the proxy for the service exists.  Click on that and you should see all the configured BCS connections.  The name of each connection has a drop down menu and you can drill into the types, and create/upgrade an app page for the BCS type.   If you go to the page it creates and you get an error you can look this up in the ULS logs using somethign like the "ULS Log Viewer" app you can get form codeplex, but remember any error reported here is more likely to be a misconfiguration of the specific BCS connection rather than the server.  Frankly if you can get this far its probably working fine.

Finally, if you are still not convinced you can use Sharepoint designer in a test site to create a new BCS connection.  See here for a walkthrough: http://blog.karstein-consulting.com/2011/02/23/walkthrough-create-a-simple-bcs-connection-with-sharepoint-designer-2010/


To find out what triggered the error in the first place use the ULS Log View and search for errors it generated.  Sharepoint generates a ton of diagnostics and it can be difficult to find these errors without a correlation ID.  

The most likely problem in a farm environment would be a temporary loss of connectivity between the servers on the farm (perhaps a DC reset?) that meant the network failed temporarily.
0
 
LVL 19

Author Comment

by:compdigit44
ID: 39974843
Great information and I learned something new as well...

Thanks Again
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 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

27 Experts available now in Live!

Get 1:1 Help Now