Solved

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

Posted on 2014-04-02
2
411 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
[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
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 20

Author Comment

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

Thanks Again
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…

732 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