none
Project Server 2013 - Null Values in dbo Views for Enterprise Custom Fields RRS feed

  • Question

  • We have installed and configured Project Server 2013, we have added enterprise custom fields for project and tasks level, the problem is like this: the values are shown in the project server plans and screens but in the project user view in the dbo schema the columns are shown but with NULL values.

    Please advise how we can get the values in the project users view and task user view (dbo database views)

    Wednesday, February 13, 2013 10:14 AM

All replies

  • Hi there,

    Have you published the projects?

    Thanks

    Paul


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

    Wednesday, February 13, 2013 10:33 AM
    Moderator
  • Hi Paul, yes sure the projects were published. the problem exists in the reporting tables.

    Wednesday, February 13, 2013 11:50 AM
  • Hi there,

    After publishing do you see a successful Reporting sync job in the Project Server queue?

    Thanks

    Paul


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

    Wednesday, February 13, 2013 12:02 PM
    Moderator
  • Hi Paul,

    the Reporting sync job is showing this error:

    ReportingProjectChangeMessageFailed (24006) - One or more custom field metadata mismatch were detected while transfering project 'cbb6d93e-3374-e211-97f3-4061868f6472'. Details: id='24006' name='ReportingProjectChangeMessageFailed' uid='a2ead9db-4875-e211-93f3-00155d68c800' QueueMessageBody='Project UID='cbb6d93e-3374-e211-97f3-4061868f6472'. PublishType='ProjectPublish'' Error='One or more custom field metadata mismatch were detected while transfering project 'cbb6d93e-3374-e211-97f3-4061868f6472''.

    Please advise my friend.

    Thursday, February 14, 2013 8:08 AM
  • I'd suggest doing an administrative backup of your Custom Fields and Lookup Tables Khalid, and then restoring the same.  This will trigger a reporting database rebuild which will hopefully correct any metadata issues in your reporting DB.  The process can take a little while depending on your data volumes, and happens in stages so sometimes it looks like nothing is happening.  Monitor this process for errors - if any occur this suggests a deeper issue.

    Best regards.

    Brian.


    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page

    Saturday, February 16, 2013 6:17 PM
    Owner