#ProjectServer 2010 new Portfolio Analysis error #PS2010 #SP2010 #MSProject

May 9, 2012 at 11:39 am | Posted in Administration, Fixes, Issue, T-SQL | Leave a comment
Tags: Project 2010, Project Server 2010, PS2010

I recently came across an issue on a client site and on the Project Server forums with creating a new Portfolio Analysis, clicking the new button threw the error below:

In the ULS logs the following lines were key to resolving the issue:

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 Microsoft.Office.Project.Server.Wcf.Implementation.LookupTableImpl.ReadLookupTablesMultiLang

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…     e5a9e8ca-2a63-494a-a996-bb6c5704171a
05/09/2012 09:24:26.03*        w3wp.exe (0x2028)                          0x0190       Project Server                        Project Web App                       2q1k  Exception   …n includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 

This system was originally migrated from Project Server 2003, to Project Server 2007 then to Project Server 2010. During the migration from Project Server 2003 to Project Server 2007 there was an issue updating the multi language lookup tables, the fix is very simple and documented here:

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

Hopefully that will help others who come across this issue.

Advertisements