none
Project Server 2013 : Report table not updated with Published tables RRS feed

  • Question

  • Hello Team,

    We found the issue that Publish and Reporting table have difference in work attribute. is their any way that we can refresh the Reporting table in one go.

    Thanks.

    Friday, April 3, 2015 8:43 PM

All replies

  • Hello. You could bulk publish all the projects. https://gallery.technet.microsoft.com/scriptcenter/Server-2010-Publish-all-45ba385b Paul

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

    Friday, April 3, 2015 8:47 PM
    Moderator
  • Hi, you could try to refresh the reporting DB.

    http://www.epmcentral.com/pjadmin/pjserver10/rebuilddb.php

    Saturday, April 4, 2015 8:22 AM
  • If this issue is specific to one or few projects, using Save for sharing would be much more easier.

    If this issue is for all the projects then as NicoOosthuysen recommended RDB refresh would be the option. Having said that  you have to take extra measure before you start RDb refresh , since it is very high system resource and time consuming activity

    Steps for Save for sharing

    1. Open MS Project Pro 2013.
    2. Open the project plan from the server.
    3. Now save it locally without making changes in the File Name, using File > Share > Save For Sharing. Provide local location. Do not close Project Professional
    4. Now save back the project back to server using File > Save As (Project Name should be grayed out)
    5. Save and then publish the project plan.


    Hrishi Deshpande Senior Consultant

    Tuesday, April 7, 2015 9:18 PM
    Moderator
  • It seems like 4 or 5 years ago, I had a similar issue and I restored the Enterprise Resource pool from the backup from server settings, and when it restored the resource pool it  also refreshed the reporting database as well.  

    Also, backup your databases before performing bulk updates.

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Saturday, April 11, 2015 2:04 PM
    Moderator