Power Pivot Data Refresh - Access Denied

Question

I am getting the following error from the Data Refresh on a Power Pivot Report:

<nativehr>0x80070005</nativehr><nativestack></nativestack>Access
denied.

In the ULS logs I get some more information:

File exception: System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>Access denied.   

at Microsoft.SharePoint.Library.SPRequest.GetFileLock(String bstrUrl, String bstrWebRelDocUrl, Int32 lockType, String lockId, Int32 minutes)   

at Microsoft.SharePoint.SPFile.Lock(SPLockType lockType, String lockId, TimeSpan timeout)

And this one seems interesting:

EXCEPTION: System.UnauthorizedAccessException: <nativehr>0x80070005</nativehr><nativestack></nativestack>Access denied.   

at Microsoft.SharePoint.SPFile.Lock(SPLockType lockType, String lockId, TimeSpan timeout)   

at Microsoft.AnalysisServices.SharePoint.Integration.Redirector.CacheManager.UploadFileToSharePoint(FileStream fStream, String destUrl, DateTime& newfileTimestamp, DateTime timeStampOnWorkload)   

at Microsoft.AnalysisServices.SharePoint.Integration.Security.ImpersonationHelper.TryRunAsUser(String login, String domain, IntPtr pwd, MethodToRun method, String& sid)   

at Microsoft.AnalysisServices.SharePoint.Integration.Security.ImpersonationHelper.TryRunAsUser(SecureStoreCredentialsWrapper creds, MethodToRun method, String& sid)   

at Microsoft.AnalysisServices.SharePoint.Integration.Security.ImpersonationHelper.TryRunAsUser(SPServiceContext serviceContext, SecurityConfiguration config, String runAsUser, String ssApplicationID, MethodToRun method)   

at Microsoft.AnalysisServices.SharePoint.Integration.Redirector.CacheManager.ImageSave(SPServiceContext serviceContext, SPFile spFile, String databaseID, DateTime timeStampOnWorkload, SecurityConfiguration secConfig, String runAsUser, String SSApplicationID, DateTime& timestampOnUpdatedFile)   

at Microsoft.AnalysisServices.SharePoint.Integration.DataRefreshService.ProcessingJob(Object parameters)

This error cropped up after a password reset. 

I have not found any information on the error on the interwebs and it is not clear exactly what is getting access denied.  Any help you could provide would be appreciated.

Answer 1

Alright I fixed this myself.  It was an operational gaffe but might be usefull for others so I will post the fix here:

This doc : http://msdn.microsoft.com/en-us/library/ff773327.aspx led me to the solution.

The section labeled "Configure a new account (Step 3): Grant Contribute permissions to the account" had the answer. 

I suspected but wasn’t positive that when I configured this for the first time I had used the farm admin account as the unattended creds.  By design I wanted to use a separate account but that account might not have been ready when I set this up originally.  The password was expiring for the account that I had planned on using as the unattended account so I reset the password and updated it in the SSS.  This broke with access denied because the unattended account had not been granted contribute access to the reports.  Thus the access denied.  It must have been working before b/c I was still using the farm admin account from when I first set this up.  Granting the correct account contribute rights to the site resolved this issue.

Answer 2

Great, thanks for sharing the information, which is useful for other communities who have the same issue.

---

Challen Fu

TechNet Community Support