Project Server 2013 – Can’t load WebPart / DBNull.Value to type ‘System.Guid’

Using this script in SQL you can check which record is generating the error :

SELECT [PROJ_NAME]
,[MD_PROP_NAME]
,[CODE_VALUE]
FROM [ProjectWebApp].[pub].[MSP_PROJ_CUSTOM_FIELD_VALUES] A inner join [ProjectWebApp].[pub].[MSP_PROJECTS] B On A.[PROJ_UID]=B.PROJ_UID inner join [ProjectWebApp].[pub].[MSP_CUSTOM_FIELDS] C on C.MD_PROP_UID = A.MD_PROP_UID
Where [CODE_VALUE] is null and FIELD_TYPE_ENUM = 21 and [MD_LOOKUP_TABLE_UID] is not null
order by [PROJ_NAME]​

Advertisements

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