Solved

SharePoint 2010 / SQL 2008 error message Event ID: 8031 every 5 minutes

Posted on 2013-02-04
5
1,116 Views
Last Modified: 2013-02-05
I keep getting the following error in SharePoint.  I can't seem to figure out how to find it withing SQL 2008

I have seen articles stating to do a query but I have no clue how



Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          2/4/2013 3:30:00 PM
Event ID:      8031
Task Category: Topology
Level:         Error
Keywords:      
User:          domain\mssqlserver
Computer:      SharepointSvr.domain.LOCAL
Description:
An exception occurred while updating addresses for connected app {7ca944c0-1867-4178-ba71-88112329f815_31f334ea-7d72-4cf9-bb7e-71e12b6f2e7c}. The uri endpoint information may be stale. System.InvalidOperationException: The requested application could not be found.
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ProcessCommonExceptions(Uri endpointAddress, String operationName, Exception ex, SPServiceLoadBalancerContext context)
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ExecuteOnChannel(String operationName, CodeBlock codeBlock)
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.GetEndPoints(Guid serviceId)
   at Microsoft.SharePoint.SPConnectedServiceApplicationAddressesRefreshJob.Execute(Guid targetInstanceId)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
    <EventID>8031</EventID>
    <Version>14</Version>
    <Level>2</Level>
    <Task>13</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2013-02-04T20:30:00.164185000Z" />
    <EventRecordID>591730</EventRecordID>
    <Correlation ActivityID="{38115968-D8FE-49A9-9C6B-17FF7F0A7263}" />
    <Execution ProcessID="10232" ThreadID="6696" />
    <Channel>Application</Channel>
    <Computer>SRV-2.domain.LOCAL</Computer>
    <Security UserID="S-1-5-21-3165647494-6301258-4010299772-1109" />
  </System>
  <EventData>
    <Data Name="string0">7ca944c0-1867-4178-ba71-88112329f815_31f334ea-7d72-4cf9-bb7e-71e12b6f2e7c</Data>
    <Data Name="string1">System.InvalidOperationException: The requested application could not be found.
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ProcessCommonExceptions(Uri endpointAddress, String operationName, Exception ex, SPServiceLoadBalancerContext context)
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.ExecuteOnChannel(String operationName, CodeBlock codeBlock)
   at Microsoft.SharePoint.SPTopologyWebServiceApplicationProxy.GetEndPoints(Guid serviceId)
   at Microsoft.SharePoint.SPConnectedServiceApplicationAddressesRefreshJob.Execute(Guid targetInstanceId)</Data>
  </EventData>
</Event>
0
Comment
Question by:yoyoma788
[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
  • 3
5 Comments
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 38852925
Hi,
one of the service applications seems to be moved/unavailable.
Please follow the steps mentioned here:
http://mobile.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_27252819.html

HTH
Rainer
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 38852959
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 38852962
Ah....same thing as the solution Rainer posted....
0
 

Author Comment

by:yoyoma788
ID: 38853002
I'm stuck at the New Query in SQL

not sure how to run a query I guess.
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 38853021
Were you able to connect in SQL Manager and see your databases?  If so, right click on the SharePoint Config db and choose New Query.  Then just type the query on the right and hit "execute".
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

733 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