none
Custom Views in PS reporting DB got wiped off after applying latest patches in the server RRS feed

  • Question

  • Hi,

    We have recently applied patches in our sharepoint farm later we found that the custom views written in the project server reporting database got wiped off. This is happening every time we apply patches.

    Any help in understanding the issue is much appreciated.

    Thanks.

    Tuesday, September 4, 2012 3:58 AM

Answers

  • Hi Sudhir,

    the patch process will also alter/update database schemas. Since you're not supposed to edit the databases in the first places, custom edits/additions will be wiped.

    The common practice is to create a custom database which solely contains designed view (and maybe external data) for reports and other analysis purposes.

    Kind regards,
    Adrian

    Wednesday, September 12, 2012 10:24 PM

All replies

  • Hi Sudhir,

    the patch process will also alter/update database schemas. Since you're not supposed to edit the databases in the first places, custom edits/additions will be wiped.

    The common practice is to create a custom database which solely contains designed view (and maybe external data) for reports and other analysis purposes.

    Kind regards,
    Adrian

    Wednesday, September 12, 2012 10:24 PM
  • Hi,

    We have recently applied patches in our sharepoint farm later we found that the custom views written in the project server reporting database got wiped off. This is happening every time we apply patches.

    Any help in understanding the issue is much appreciated.

    Thanks.

    Hi Sudhir,

    As far as I know if you don't modify the out of the box reporting database objects, applying the patches doesn't throw any such issues.

    http://msdn.microsoft.com/en-us/library/ms504195.aspx

    The Draft, Published, and Archive database schemas are not documented. You can use the Reporting database to help generate reports, and the Reporting database schema is documented in the Project 2010 SDK download. You can also extend the Reporting database to include external data for integrated reporting solutions.

    Did you modify the any out of box database objects? I have worked with some customers where we had to add the SProcs, views in Reporting database & didn't encounter any issue.

    Thanks,


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Thursday, September 13, 2012 6:17 AM
  • Hi Sudhir,

    I agree with Amit, adding new database objects to the Project Server Reporting database should be fine. We have done this many times for customers and these have never seen any issues after patching.

    Paul


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

    Thursday, September 13, 2012 7:04 AM
    Moderator