Problems trying to export the project list to excel via Project Server 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-2580685%22%20slang%3D%22en-US%22%3EProblems%20trying%20to%20export%20the%20project%20list%20to%20excel%20via%20Project%20Server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2580685%22%20slang%3D%22en-US%22%3E%3CP%3EWe're%20having%20problems%20trying%20to%20export%20the%20project%20list%20to%20excel%20via%20Project%20Server%202016.%20The%20logs%20criticize%20lack%20of%20permission%20in%20the%20registry%2C%20but%20I%20haven't%20been%20able%20to%20catch%20an%20access%20denied%20exception%20through%20procmon%20so%20far%20to%20identify%20which%20keys%20to%20registry%20are%20being%20accessed%20at%20the%20time%20of%20the%20error.%20However%2C%20when%20comparing%20permissions%20between%20working%20farms%2C%20I%20made%20some%20permission%20tweaks%2C%20but%20nothing%20went%20right.%3C%2FP%3E%3CP%3EI%20tried%20to%20redo%20the%20SharePoint%20permissions%20by%20running%20the%20command%20%22psconfig%20-cmd%20secureresources%22%2C%20but%20it%20didn't%20work%20either.%3C%2FP%3E%3CP%3EI%20made%20sure%20that%20the%20account%20that%20runs%20the%20application%20pool%20and%20the%20one%20that%20maintains%20the%20SharePoint%20services%20were%20in%20the%20local%20security%20group%20WSS_WPG.%3C%2FP%3E%3CP%3EErro%3A%3C%2FP%3E%3CP%3E%22Application%20error%20when%20access%20%2F_layouts%2F15%2FPWA%2FPJExport%2F%3CA%20href%3D%22http%3A%2F%2Fexportgridexcel.aspx%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EExportGridExcel.aspx%3C%2FA%3E%2C%20Error%3DRequested%20registry%20access%20is%20not%20allowed.%3CBR%20%2F%3Eat%20System.ThrowHelper.ThrowSecurityException(ExceptionResource%20resource)%3CBR%20%2F%3Eat%20Microsoft.Win32.RegistryKey.OpenSubKey(String%20name%2C%20Boolean%20writable)%3CBR%20%2F%3Eat%20Microsoft.Win32.Registry.GetValue(String%20keyName%2C%20String%20valueName%2C%20Object%20defaultValue)%3CBR%20%2F%3Eat%20MS.Utility.EventTrace.IsClassicETWRegistryEnabled()%3CBR%20%2F%3Eat%20MS.Utility.EventTrace..cctor()%22%3C%2FP%3E%3CP%3E%22Getting%20Error%20Message%20for%20Exception%20System.TypeInitializationException%3A%20The%20type%20initializer%20for%20'MS.Utility.EventTrace'%20threw%20an%20exception.%20---%26gt%3B%20System.Security.SecurityException%3A%20Requested%20registry%20access%20is%20not%20allowed.%3CBR%20%2F%3Eat%20System.ThrowHelper.ThrowSecurityException(ExceptionResource%20resource)%3CBR%20%2F%3Eat%20Microsoft.Win32.RegistryKey.OpenSubKey(String%20name%2C%20Boolean%20writable)%3CBR%20%2F%3Eat%20Microsoft.Win32.Registry.GetValue(String%20keyName%2C%20String%20valueName%2C%20Object%20defaultValue)%3CBR%20%2F%3Eat%20MS.Utility.EventTrace.IsClassicETWRegistryEnabled()%3CBR%20%2F%3Eat%20MS.Utility.EventTrace..cctor()%20-%3CBR%20%2F%3E--%20End%20of%20inner%20exception%20stack%20trace%20---%3CBR%20%2F%3Eat%20MS.Utility.EventTrace.EasyTraceEvent(Keyword%20keywords%2C%20Event%20eventID)%3CBR%20%2F%3Eat%20System.IO.Packaging.Package.Open(Stream%20stream%2C%20FileMode%20packageMode%2C%20FileAccess%20packageAccess%2C%20Boolean%20streaming)%3CBR%20%2F%3Eat%20DocumentFormat.OpenXml.Packaging.OpenXmlPackage.CreateCore(Stream%20stream)%3CBR%20%2F%3Eat%20DocumentFormat.OpenXml.Packaging.SpreadsheetDocument.Create(Stream%20stream%2C%20SpreadsheetDocumentType%20type%2C%20Boolean%20autoSave)%3CBR%20%2F%3Eat%20Microsoft.Office.Project.PWA.ApplicationPages.ExportGridExcelPage.Render(HtmlTextWriter%20writer)%3CBR%20%2F%3Eat%20System.Web.UI.Control.RenderControlInternal(HtmlTextWriter%20writer%2C%20ControlAdapter%20adapter)%3CBR%20%2F%3Eat%20System.Web.UI.Page.ProcessRequestMain(Boolean%20includeStagesBeforeAsyncPoint%2C%20Boolean%20includeStagesAfterAsyncPoint)%3CBR%20%2F%3Eat%20System.Web.UI.Page.ProcessRequest(Boolean%20includeStagesBeforeAsyncPoint%2C%20Boolean%20includeStagesAfterAsyncPoint)%3CBR%20%2F%3Eat%20System.Web.UI.Page.ProcessRequest()%3CBR%20%2F%3Eat%20System.Web.UI.Page.ProcessRequest(HttpContext%20context)%3CBR%20%2F%3Eat%20System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()%3CBR%20%2F%3Eat%20System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep%20step)%3CBR%20%2F%3Eat%20System.Web.HttpApplication.ExecuteStep(IExecutionStep%20step%2C%20Boolean%26amp%3B%20completedSynchronously)%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2580685%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2721571%22%20slang%3D%22en-US%22%3ERe%3A%20Problems%20trying%20to%20export%20the%20project%20list%20to%20excel%20via%20Project%20Server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2721571%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20am%20facing%20the%20same%20issue%20here%20on%20an%20environment%20upgraded%20from%202010%20-%26gt%3B2013-%26gt%3B2016-%26gt%3B2019%2C%20users%20are%20not%20able%20to%20export%20the%20project%20center%20for%20example%2C%20and%20when%20checking%20the%20ULS%20log%2C%20it%20the%20same%20error%20%22requested%20registry%20access%20is%20not%20allowed%22%3C%2FP%3E%3CP%3Eany%20one%20can%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111214%22%20target%3D%22_blank%22%3E%40casousajr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

We're having problems trying to export the project list to excel via Project Server 2016. The logs criticize lack of permission in the registry, but I haven't been able to catch an access denied exception through procmon so far to identify which keys to registry are being accessed at the time of the error. However, when comparing permissions between working farms, I made some permission tweaks, but nothing went right.

I tried to redo the SharePoint permissions by running the command "psconfig -cmd secureresources", but it didn't work either.

I made sure that the account that runs the application pool and the one that maintains the SharePoint services were in the local security group WSS_WPG.

Erro:

"Application error when access /_layouts/15/PWA/PJExport/ExportGridExcel.aspx, Error=Requested registry access is not allowed.
at System.ThrowHelper.ThrowSecurityException(ExceptionResource resource)
at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
at Microsoft.Win32.Registry.GetValue(String keyName, String valueName, Object defaultValue)
at MS.Utility.EventTrace.IsClassicETWRegistryEnabled()
at MS.Utility.EventTrace..cctor()"

"Getting Error Message for Exception System.TypeInitializationException: The type initializer for 'MS.Utility.EventTrace' threw an exception. ---> System.Security.SecurityException: Requested registry access is not allowed.
at System.ThrowHelper.ThrowSecurityException(ExceptionResource resource)
at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
at Microsoft.Win32.Registry.GetValue(String keyName, String valueName, Object defaultValue)
at MS.Utility.EventTrace.IsClassicETWRegistryEnabled()
at MS.Utility.EventTrace..cctor() -
-- End of inner exception stack trace ---
at MS.Utility.EventTrace.EasyTraceEvent(Keyword keywords, Event eventID)
at System.IO.Packaging.Package.Open(Stream stream, FileMode packageMode, FileAccess packageAccess, Boolean streaming)
at DocumentFormat.OpenXml.Packaging.OpenXmlPackage.CreateCore(Stream stream)
at DocumentFormat.OpenXml.Packaging.SpreadsheetDocument.Create(Stream stream, SpreadsheetDocumentType type, Boolean autoSave)
at Microsoft.Office.Project.PWA.ApplicationPages.ExportGridExcelPage.Render(HtmlTextWriter writer)
at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)"

1 Reply

i am facing the same issue here on an environment upgraded from 2010 ->2013->2016->2019, users are not able to export the project center for example, and when checking the ULS log, it the same error "requested registry access is not allowed"

any one can help?

 @casousajr