none
Project Server 2013 - Driver Priorities Page - Access Denied RRS feed

  • Question

  • Hello,

    We recently came accross an issue with the Driver Priorities page in Project Server 20113. It's working correctly for most of the prioritization except for one item.

    For some reason, when we click on this particular item, we receive an access denied message:

    Sorry, something went wrong

    You do not have sufficient permissions to view the specified page. Please contact your administrator for permissions to view this page.

    Here's the information that we found in the ULS logs (there's wasn't any errors in the Event Viewer logs):

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : Logging Correlation Data
    Message   : Name=Request (GET:http://contoso.epm.com:80/PWA/_layouts/15/PWA/PortfolioStrategy/
                DriverPriorities.aspx?prioritizationUid=7000bd43-8ec2-e411-80cb-0050560100b2)

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : Authentication Authorization
    Message   : Non-OAuth request. IsAuthenticated=True, UserIdentityName=0#.w|contoso\_sp_admin,
                ClaimsCount=50

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : Logging Correlation Data
    Message   : Site=/PWA

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : Security
    Message   : Entered GetIdentityEncodedClaims for Identity (name=0#.w|contoso\_sp_admin,
                isAuthenticated=True, authenticationType=Federation)

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : Project Server Database
    Message   : Successfully got the connection string (database name=[SP2013_Contoso_PWA],
                id=eb67bb86-b3ef-4c21-8e63-0108a0021053, type=Consolidated). Requested access
                level=ReadWrite: Data Source=CONTOSOSQL;Initial
                Catalog=SP2013_Contoso_PWA;Integrated Security=True;Enlist=False;Pooling=True;Min
                Pool Size=0;Max Pool Size=100;Connect Timeout=15

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : Files
    Message   : UserAgent not available, file operations may not be optimized.    at
                Microsoft.SharePoint.SPFileStreamManager.CreateCobaltStreamContainer(SPFileStreamStore
                spfs, ILockBytes ilb, Boolean copyOnFirstWrite, Boolean disposeIlb)     at
                Microsoft.SharePoint.SPFileStreamManager.SetInputLockBytes(SPFileInfo& fileInfo,
                SqlSession session, PrefetchResult prefetchResult)     at Microsoft.SharePoint.Coordina
                tedStreamBuffer.SPCoordinatedStreamBufferFactory.CreateFromDocumentRowset(Guid
                databaseId, SqlSession session, SPFileStreamManager spfstm, Object[] metadataRow,
                SPRowset contentRowset, SPDocumentBindRequest& dbreq, SPDocumentBindResults& dbres)    
                 at Microsoft.SharePoint.SPSqlClient.GetDocumentContentRow(Int32 rowOrd, Object
                ospFileStmMgr, SPDocumentBindRequest& dbreq, SPDocumentBindResults& dbres...

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : Files
    Message   : Spent 0 ms to bind 29798 byte file stream

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : Project Server Database
    Message   : Successfully got the connection string (database name=[SP2013_Contoso_PWA],
                id=eb67bb86-b3ef-4c21-8e63-0108a0021053, type=Consolidated). Requested access
                level=ReadWrite: Data Source=CONTOSOSQL;Initial
                Catalog=SP2013_Contoso_PWA;Integrated Security=True;Enlist=False;Pooling=True;Min
                Pool Size=0;Max Pool Size=100;Connect Timeout=15

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : Security
    Message   : Entered GetIdentityEncodedClaims for Identity (name=0#.w|contoso\_sp_admin,
                isAuthenticated=True, authenticationType=Federation)

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : General
    Message   : [bucketHash:342EC0DB] Exception occured in method 'Driver.ReadPrioritization'
                System.Data.ConstraintException: Failed to enable constraints. One or more rows
                contain values violating non-null, unique, or foreign-key constraints.     at
                System.Data.DataSet.EnableConstraints()     at
                System.Data.DataSet.set_EnforceConstraints(Boolean value)     at Microsoft.Office.Proje
                ct.Server.DataAccessLayer.DAL.SubDal.<>c__DisplayClasse.<FillTypedDataSet>b__c(IProject
                ServerSqlSession session)     at Microsoft.Office.Project.Server.Security.SecurityConte
                xt.RunAsProcess(CodeToRunElevated secureCode)     at Microsoft.Office.Project.Server.Da
                taAccessLayer.DAL.RetryableExecuteHandlerWithSession(IProjectServerSqlSession session,
                Action`1 actionHandler, Boolean allowRetry)     at Microsoft.Office.Project.Server...

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : Unified Logging Service
    Message   : Watson bucket parameters: Microsoft Project Server 2013, ULSException14, 070f6ea0
                "project server", 0f0011d9 "15.0.4569.0", ea364808 "system.data", 0400766f
                "4.0.30319.0", 52003c3b "mon aug 05 19:58:51 2013", 00001223 "00001223", 000000d8
                "000000d8", 2fb64168 "constraintexception", 00101621 "aeby7"

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : General
    Message   : Error is: GeneralUnhandledException. Details: General Unhandled Exception in
                _Driver.ReadPrioritization_ Attributes:  System.Data.ConstraintException: Failed to
                enable constraints. One or more rows contain values violating non-null, unique, or
                foreign-key constraints.     at System.Data.DataSet.EnableConstraints()     at
                System.Data.DataSet.set_EnforceConstraints(Boolean value)     at Microsoft.Office.Proje
                ct.Server.DataAccessLayer.DAL.SubDal.<>c__DisplayClasse.<FillTypedDataSet>b__c(IProject
                ServerSqlSession session)     at Microsoft.Office.Project.Server.Security.SecurityConte
                xt.RunAsProcess(CodeToRunElevated secureCode)     at Microsoft.Office.Project.Server.Da
                taAccessLayer.DAL.RetryableExecuteHandlerWithSession(IProjectServerSqlSession session,
                Action`1 actionHandler, Boolean allowRetry...

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : Project Web App
    Message   : [bucketHash:1FAE519D]  Microsoft.SharePoint.SPException: You do not have sufficient permissions to view the specified page. Please contact your administrator for permissions to view this page.    
                at Microsoft.Office.Project.PWA.ApplicationPages.DriverPrioritiesPage.PreparePrioritiz
                ationData()     at Microsoft.Office.Project.PWA.ApplicationPages.DriverPrioritiesPage.P
                JWebPage_OnLoad(EventArgs e)     at
                Microsoft.Office.Project.PWA.PJWebPage.OnLoad(EventArgs e)     at
                System.Web.UI.Control.LoadRecursive()     at
                System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean
                includeStagesAfterAsyncPoint) StackTrace:  at
                Microsoft.Office.Project.Server.Native.dll:
                (sig=93a6e527-19e5-455e-939e-122ba46eb4b7|2|microsoft.office.project...

    Timestamp : 2015-03-12 13:37:35
    Area      : Project Server
    Category  : Unified Logging Service
    Message   : Watson bucket parameters: Microsoft Project Server 2013, ULSException14, 070f6ea0
                "project server", 0f0011d9 "15.0.4569.0", e121efb2
                "microsoft.office.project.server.pwa.applicationpages", 0f001237 "15.0.4663.0",
                542b2d6c "tue sep 30 18:23:40 2014", 00000671 "00000671", 0000033d "0000033d",
                d229b6b2 "spexception:80131600", 001475c3 "afhxd"

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : General
    Message   : Application error when accessYou do not have sufficient permissions to view the specified page. Please contact your administrator for permissions to view this page.   
                at Microsoft.Office.Project.PWA.ApplicationPages.DriverPrioritiesPage.PreparePrioritiza
                tionData()     at Microsoft.Office.Project.PWA.ApplicationPages.DriverPrioritiesPage.PJ
                WebPage_OnLoad(EventArgs e)     at
                Microsoft.Office.Project.PWA.PJWebPage.OnLoad(EventArgs e)     at
                System.Web.UI.Control.LoadRecursive()     at
                System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean
                includeStagesAfterAsyncPoint)

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : Runtime
    Message   : Microsoft.SharePoint.SPException: You do not have sufficient permissions to view the specified page. Please contact your administrator for permissions to view this page. at Microsoft.Office.Project.PWA.Applicati
                onPages.DriverPrioritiesPage.PreparePrioritizationData()     at Microsoft.Office.Projec
                t.PWA.ApplicationPages.DriverPrioritiesPage.PJWebPage_OnLoad(EventArgs e)     at
                Microsoft.Office.Project.PWA.PJWebPage.OnLoad(EventArgs e)     at
                System.Web.UI.Control.LoadRecursive()     at
                System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean
                includeStagesAfterAsyncPoint)

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : General
    Message   : Getting Error Message for Exception System.Web.HttpUnhandledException (0x80004005):
                Exception of type 'System.Web.HttpUnhandledException' was thrown. --->
                Microsoft.SharePoint.SPException: You do not have sufficient permissions to view the specified page. Please contact your administrator for permissions to view this page. at Microsoft.Office.Project.PWA.Applicat
                ionPages.DriverPrioritiesPage.PreparePrioritizationData()     at Microsoft.Office.Proje
                ct.PWA.ApplicationPages.DriverPrioritiesPage.PJWebPage_OnLoad(EventArgs e)     at
                Microsoft.Office.Project.PWA.PJWebPage.OnLoad(EventArgs e)     at
                System.Web.UI.Control.LoadRecursive()     at
                System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean
                includeStagesAfterAsyncPoi...

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : General
    Message   :

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : Micro Trace
    Message   : Micro Trace Tags: 0 nasq,2 agb9s,6 aebez,0 ah91z,18 ak8dj,12 ah91z,0 aebez,9 aeby8,5
                8nca,0 tkau,0 ajlz0,0 aat87

    Timestamp : 2015-03-12 13:37:35
    Area      : SharePoint Foundation
    Category  : Monitoring
    Message   : Leaving Monitored Scope (Request (GET:http://contoso.epm.com:80/PWA/_layouts/15/PW
                A/PortfolioStrategy/DriverPriorities.aspx?prioritizationUid=7000bd43-8ec2-e411-80cb-005
                0560100b2)). Execution Time=60.5638426112816

    Did someone else encountered this issue?

    Thanks!

    • Moved by star.wars Monday, March 16, 2015 7:43 AM
    Friday, March 13, 2015 3:54 PM

All replies

  • Hi JFME,

    It seems your issue is more relevant to Project server, I'll move your question to the Prject server forum for a better assistance.

    https://social.technet.microsoft.com/Forums/projectserver/en-US/home?forum=projectserver2010general

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Thanks

    Daniel Yang


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Monday, March 16, 2015 7:42 AM