Solved

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

Posted on 2013-02-04
5
1,075 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
  • 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

705 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

22 Experts available now in Live!

Get 1:1 Help Now