MSP_EpmAssignmentByDay - no data

[Jyrki]

We have quite a lot of projects in Project Server. Should there be data in
MSP_EpmAssignmentByDay table on ProjectServer_Reporting db? Now the table is
totally empty.

How can we get data to that table?

 

[Barbara - Austria]

Hi Jyrki,

what happens if you publish a project? Does that data get to the table? Are
there any failed jobs in your queue?

You can try to force a rebuild of your Reporting DB:
1. From PWA - Server Settings - Administrative Backup, take backup of
‘Enterprise Custom Fields’.
2. From PWA - Server Settings - Administrative Restore, restore ‘Enterprise
Custom Fields’.

You should do that outside of normal working hours. It will take some time
and slow down your system. It will start several jobs which are also
starting additional ones. Sometimes you can only see "Waiting to be
processed" in your queue. Add 'Success' to 'Job Completion States' to see
that is still happening a lot in the background.

Regards
Barbara