none
Database in Reporting Server is not updating MSP_EpmResourceByDay_UserView RRS feed

Answers

  • Hello,

    Does your Resource Capacity job (Reporting (Resources Capacity Range Sync)) still run successfully each day? What settings do you have set on this? This is set on the Additional Server Settings in the Resource Capacity Settings section (PWA Server Setting > Additional Server Settings). How many months ahead and month behind have you got set?

    If the job is not running, change the scheduled time for the job by 5 minutes or so on the Additional Server Settings page then wait for that time to pass and check the queue for the successful job. Once the job is successful that view should contain data for the time range set (months behind / ahead).

    Paul


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

    • Marked as answer by fodi30 Wednesday, August 27, 2014 9:25 AM
    Wednesday, August 27, 2014 8:14 AM
    Moderator

All replies

  • Hello,

    Does your Resource Capacity job (Reporting (Resources Capacity Range Sync)) still run successfully each day? What settings do you have set on this? This is set on the Additional Server Settings in the Resource Capacity Settings section (PWA Server Setting > Additional Server Settings). How many months ahead and month behind have you got set?

    If the job is not running, change the scheduled time for the job by 5 minutes or so on the Additional Server Settings page then wait for that time to pass and check the queue for the successful job. Once the job is successful that view should contain data for the time range set (months behind / ahead).

    Paul


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

    • Marked as answer by fodi30 Wednesday, August 27, 2014 9:25 AM
    Wednesday, August 27, 2014 8:14 AM
    Moderator
  • Thanks Paul, i started the JOB from Central Admin for Resource Capcity and it worked.

    _________ Fahad Ahmed Khan .NET Articles, Web Development, SharePoint and Project Server Custom Solution Provider

    Wednesday, August 27, 2014 9:25 AM
  • If you modify the scheduled time on the Additional Server Settings page in PWA that should relink the job in Central Admin and it will fire automatically.

    Paul


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

    Wednesday, August 27, 2014 9:45 AM
    Moderator