Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

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

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
compdigit44
Asked:
compdigit44
1 Solution
 
colly92002Commented:
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
 
compdigit44Author Commented:
Great information and I learned something new as well...

Thanks Again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now