#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: , ,

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:


Hopefully that will help others who come across this issue.


Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: