none
Getting an error when I click "New" under "Portfolio Analyses" in PWA 2010 RRS feed

  • Question

  • I have set up some sample business drivers and prioritized them.  However, when I click New on the "Portfolio Analyses" page I get a nondescript error and with a correlation UID.  THe ULS logs don't provide any insight into what kind of error it's throwing.  Please help.  Thank you!

    Monday, May 7, 2012 7:28 PM

Answers

All replies

  • Hi there,

    Has this functionality ever worked for you or just stopped working? Do you see anything in the ULS logs relating to loading lookup tables when you hit the new new button? Reason I ask is that we recently looked into a similar issue for a client and this was caused by an issue with lookup tables.

    Thanks

    Paul 


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Monday, May 7, 2012 7:36 PM
    Moderator
  • Paul,

    I do see the ULS logs reflecting an issue with the lokoup tables.  Please see below.

    This is our first foray into the Portfolio Analyses.  I was just trying to set up a sample, the way they do it in the MS Project Experts bible.  Here are the logs:

    05/07/2012 14:47:45.15 	w3wp.exe (0x1BD4)                       	0x1D88	Project Server                	General                       	0000	Exception	Exception occurred in method Microsoft.Office.Project.Server.BusinessLayer.LookupTable.ReadLookupTablesMultiLang 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.Project.Server.DataAccessLayer.DAL.SubDal.FillTypedDataSet(Boolean allowCache, DataSet typedDataSet, String[] tables, SqlCommand sqlCommand, Boolean enforceConstraints)     at Microsoft.Office.Project.Server.DataAccessLayer.LookupTableDal.ReadLookupTables()     at Microsoft.Office.Project.Server.BusinessLayer.LookupTable.ReadLookupTablesMultiLang(String xmlFilter, Boolean autoCheckOut)     at Micr...	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.15*	w3wp.exe (0x1BD4)                       	0x1D88	Project Server                	General                       	0000	Exception	...osoft.Office.Project.Server.Wcf.Implementation.LookupTableImpl.ReadLookupTablesMultiLang(String xmlFilter, Boolean autoCheckOut)	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.15 	w3wp.exe (0x1BD4)                       	0x1D88	Project Server                	Unified Logging Service       	c91s	Monitorable	Watson bucket parameters: Microsoft Project Server 2010, ULSException14, 070f6ea0 "project server", 0e00178d "14.0.6029.0", ea364808 "system.data", 0200c627 "2.0.50727.0", 4ca2ba0b "tue sep 28 23:01:15 2010", 0000087d "0000087d", 000000d8 "000000d8", 2fb64168 "constraintexception", 30303030 "0000"	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.15 	w3wp.exe (0x1BD4)                       	0x1D88	Project Server                	Unified Logging Service       	b6ig	Medium  	Not reporting 0000 to Watson because it is not enabled	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.15 	w3wp.exe (0x1BD4)                       	0x1D88	SharePoint Foundation         	Monitoring                    	b4ly	Medium  	Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=147.570990167745	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.16 	w3wp.exe (0x1534)                       	0x1FD4	SharePoint Foundation         	Monitoring                    	b4ly	High    	Leaving Monitored Scope (ExecuteWcfOperation:http://schemas.microsoft.com/office/project/server/webservices/LookupTable/ReadLookupTablesMultiLang). Execution Time=161.806598324647	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.16 	w3wp.exe (0x1534)                       	0x1FD4	Project Server                	Project Web App               	2q1k	Exception	 System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=GeneralUnhandledException Instructions: Pass this into PSClientError constructore to access all error information     at Microsoft.Office.Project.Server.WebServiceProxy.LookupTable.ReadLookupTablesMultiLang(String xmlFilter, Boolean autoCheckOut)     at Microsoft.Office.Project.PWA.ApplicationPages.OptimizerCreateAnalysisPage.FillForcedLookupTables()     at Microsoft.Office.Project.PWA.ApplicationPages.OptimizerCreateAnalysisPage.FillControls()     at Microsoft.Office.Project.PWA.ApplicationPages.OptimizerCreateAnalysisPage.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(Boolea...	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.16*	w3wp.exe (0x1534)                       	0x1FD4	Project Server                	Project Web App               	2q1k	Exception	...n includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.16 	w3wp.exe (0x1534)                       	0x1FD4	Project Server                	Unified Logging Service       	c91s	Monitorable	Watson bucket parameters: Microsoft Project Server 2010, ULSException14, 070f6ea0 "project server", 0e00178d "14.0.6029.0", 17ecd0fa "microsoft.office.project.server.pwa", 0e0017dc "14.0.6108.0", 4e27522e "wed jul 20 17:09:50 2011", 00001135 "00001135", 00000067 "00000067", e5d72a0a "soapexception", 3271316b "2q1k"	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.16 	w3wp.exe (0x1534)                       	0x1FD4	Project Server                	Unified Logging Service       	b6ig	Medium  	Not reporting 2q1k to Watson because it is not enabled	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.16 	w3wp.exe (0x1534)                       	0x1FD4	SharePoint Foundation         	Runtime                       	tkau	Unexpected	System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=GeneralUnhandledException Instructions: Pass this into PSClientError constructore to access all error information    at Microsoft.Office.Project.Server.WebServiceProxy.LookupTable.ReadLookupTablesMultiLang(String xmlFilter, Boolean autoCheckOut)     at Microsoft.Office.Project.PWA.ApplicationPages.OptimizerCreateAnalysisPage.FillForcedLookupTables()     at Microsoft.Office.Project.PWA.ApplicationPages.OptimizerCreateAnalysisPage.FillControls()     at Microsoft.Office.Project.PWA.ApplicationPages.OptimizerCreateAnalysisPage.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 ...	360e0bbc-2810-4ca5-8a35-3938354ec33c
    05/07/2012 14:47:45.16*	w3wp.exe (0x1534)                       	0x1FD4	SharePoint Foundation         	Runtime                       	tkau	Unexpected	...includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)	360e0bbc-2810-4ca5-8a35-3938354ec33c


    Monday, May 7, 2012 8:01 PM
  • Hi Bill,

    Was this system upgraded from Project Server 2003, to Project Server 2007 then to Project Server 2010?

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Monday, May 7, 2012 8:20 PM
    Moderator
  • Yes it was.
    Monday, May 7, 2012 8:22 PM
  • Ok, after migrating from Project Server 2003 to 2007 did you run the following delete script:

    http://technet.microsoft.com/en-us/library/cc197573(v=office.12).aspx#section9

    Looking at the error you are seeing, I would assume not. Can you run this script against the Published DB? I would test this on a Test system first.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Monday, May 7, 2012 8:47 PM
    Moderator