본문 바로가기

Troubleshoot

Sharepoint 2010 Web Analytics Trigger Workflows Timer Job [Access is Denied (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))]

Sharepoint 2010 Web Analytics 데이터가 쌓이지 않아 중앙관리 모니터링 –> 작업 기록에서 확인 해 보니 Web Analytics Trigger Workflows Timer Job에서 아래와 같은 오류가 발생되고 있었습니다.

 

 

 

ULS Log 메시지를 확인 해 보니 아래와 같은 상태였습니다.

08/29/2012 17:08:46.76	OWSTIMER.EXE (0x0FC0)	0x1004	SharePoint Foundation	Monitoring	nasq	Medium	Entering monitored scope (Timer Job WebAnalyticsWorkflowTrigger)	716083d1-3583-4472-a5fb-775128a4deda	
08/29/2012 17:08:46.76	OWSTIMER.EXE (0x0FC0)	0x1004	SharePoint Foundation	Database	4ohp	High	Enumerating all sites in SPContentDatabase Name=WSS_Content_eeea48bfe6244deab7631f143a198559.	716083d1-3583-4472-a5fb-775128a4deda	
08/29/2012 17:08:46.76	OWSTIMER.EXE (0x0FC0)	0x1004	SharePoint Foundation	Database	4ohq	Medium	Site Enumeration Stack:    at Microsoft.SharePoint.Administration.SPSiteCollection.get_Names()     at Microsoft.SharePoint.Administration.SPAllSitesJobDefinition.Execute(SPContentDatabase contentDatabase, SPJobState jobState)     at Microsoft.Office.Server.WebAnalytics.WebAnalyticsWorkflowTriggerJobDefinition.Execute(SPContentDatabase contentDatabase, SPJobState jobState)     at Microsoft.SharePoint.Administration.SPContentDatabaseJobDefinition.Execute(SPJobState jobState)     at Microsoft.SharePoint.Administration.SPTimerJobInvokeInternal.Invoke(SPJobDefinition jd, Guid targetInstanceId, Boolean isTimerService, Int32& result)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)	716083d1-3583-4472-a5fb-775128a4deda	
08/29/2012 17:08:46.76	OWSTIMER.EXE (0x0FC0)	0x1004	SharePoint Foundation	General	8e2s	Medium	Unknown SPRequest error occurred. More information: 0x80070005	716083d1-3583-4472-a5fb-775128a4deda	
08/29/2012 17:08:46.76	OWSTIMER.EXE (0x0FC0)	0x1004	SharePoint Foundation	Timer	6398	Critical	The Execute method of job definition Microsoft.Office.Server.WebAnalytics.WebAnalyticsWorkflowTriggerJobDefinition (ID 326c241d-3be9-40d6-87cc-e36a1d31dd59) threw an exception. More information is included below.  액세스가 거부되었습니다. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))	716083d1-3583-4472-a5fb-775128a4deda	
08/29/2012 17:08:46.76	OWSTIMER.EXE (0x0FC0)	0x1004	SharePoint Foundation	Timer	72ae	Unexpected	Exception stack trace:    at Microsoft.SharePoint.Library.SPRequest.GetAllWebsOfSite(String bstrUrl, Object& pvarWebs, Object& pvarWebIds, Object& pvarParentWebs, Object& pvarLangs, Object& pvarTitles, Object& pvarUIVersions, Object& pvarFlags, Object& pvarWebTemplates, Object& pvarConfigurations, Object& pvarMasterUrls, Object& pvarCustomMasterUrls)     at Microsoft.SharePoint.SPSite.SPWebCollectionProvider.GetWebsData(String[]& strNames, String[]& strServiceRelUrls, Guid[]& guidWebIds, Int32[]& nLanguages, String[]& strTitles, String[]& strDescriptions, String[]& strCreationTimes, String[]& strModifiedTimes, Boolean[]& bUserIsWebAdmins, Int32[]& nWebTemplates, Int16[]& nProvisionConfigs, Int16[]& nMeetingCounts, Int32[]& nUIVersions, Int32[]& nFlags, String[]& strMasterUrls, String[]& strCustomMasterUrls)     at Microsoft.SharePoint.SPWebCollection.EnsureWebsData()     at Microsoft.SharePoint.SPBaseCollection.GetEnumerator()     at Microsoft.Office.Server.WebAnalytics.WebAnalyticsWorkflowTriggerJobDefinition.ProcessSite(SPSite siteToProcess, SPJobState jobState)     at Microsoft.SharePoint.Administration.SPAllSitesJobDefinition.Execute(SPContentDatabase contentDatabase, SPJobState jobState)     at Microsoft.Office.Server.WebAnalytics.WebAnalyticsWorkflowTriggerJobDefinition.Execute(SPContentDatabase contentDatabase, SPJobState jobState)     at Microsoft.SharePoint.Administration.SPContentDatabaseJobDefinition.Execute(SPJobState jobState)     at Microsoft.SharePoint.Administration.SPTimerJobInvokeInternal.Invoke(SPJobDefinition jd, Guid targetInstanceId, Boolean isTimerService, Int32& result)	716083d1-3583-4472-a5fb-775128a4deda	
08/29/2012 17:08:46.76	OWSTIMER.EXE (0x0FC0)	0x1004	SharePoint Foundation	Monitoring	b4ly	Medium	Leaving Monitored Scope (Timer Job WebAnalyticsWorkflowTrigger). Execution Time=5.05387946787877	716083d1-3583-4472-a5fb-775128a4deda	

 

Event Viewer에서는 아래와 같이 나타나더군요.

The Execute method of job definition Microsoft.Office.Server.WebAnalytics.WebAnalyticsWorkflowTriggerJobDefinition (ID 326c241d-3be9-40d6-87cc-e36a1d31dd59) threw an exception. More information is included below.

액세스가 거부되었습니다. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
로그 이름:         Application
원본:            Microsoft-SharePoint Products-SharePoint Foundation
날짜:            2012-08-29 오후 5:37:01
이벤트 ID:        6398
작업 범주:         Timer
수준:            위험
키워드:           
사용자:           SYSTEM
컴퓨터:           AE-Dev.dev.com
설명:
The Execute method of job definition Microsoft.Office.Server.WebAnalytics.WebAnalyticsWorkflowTriggerJobDefinition (ID 326c241d-3be9-40d6-87cc-e36a1d31dd59) threw an exception. More information is included below.

액세스가 거부되었습니다. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
이벤트 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>6398</EventID>
    <Version>14</Version>
    <Level>1</Level>
    <Task>12</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2012-08-29T08:37:01.027698600Z" />
    <EventRecordID>506032</EventRecordID>
    <Correlation ActivityID="{BB93E47E-9E25-4170-9F68-C02FF2A001CE}" />
    <Execution ProcessID="4032" ThreadID="7680" />
    <Channel>Application</Channel>
    <Computer>AE-Dev.dev.com</Computer>
    <Security UserID="S-1-5-18" />
  </System>
  <EventData>
    <Data Name="string0">Microsoft.Office.Server.WebAnalytics.WebAnalyticsWorkflowTriggerJobDefinition</Data>
    <Data Name="string1">326c241d-3be9-40d6-87cc-e36a1d31dd59</Data>
    <Data Name="string2">액세스가 거부되었습니다. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))</Data>
  </EventData>
</Event>

 

해결 방법은 아래와 같습니다.

일단 Configure managed accounts의 계정은 dev\mossadmin 이였습니다.

 

헌데 서비스의 계정은 local system계정으로 돌고 있었습니다.

그래서 동일하게 dev\mossadmin으로 변경하였습니다.

 

 

그랬더니.. 에러 없이 잘 동작하는군요..

이상입니다.

감사합니다.