Project Server 2010 Business Intelligence performance issue RRS feed

  • Question

  • Hello,

    We've setup a Project Server 2010 Business intelligence center and everything seems to be working fine.

    The next day when users attempt to open Sample reports an error occurs that when we apply the "refresh all Data connections" a couple of times everything works fine.

    How do we ensure that this strange issue of "fake un-related" errors are not occuring for users.

    Once the BI is accessed by a few people then the reports seem to work the first time otherwise if you are the first one running them in the morning you have to retry 4 to 5 times for the excel spreadsheet to show up?

    Tuesday, January 21, 2014 4:21 PM

All replies

  • Hello,

    I've not seen this before, may be it is some sort of timeout. What do you see in the SharePoint ULS logs? Do you run the SharePoint warm up scripts such as SPWakeUp?


    Paul Mather | Twitter | | CPS

    Tuesday, January 21, 2014 4:45 PM
  • Hi Paul,

    Yes we are running warm up scripts for both PWA and BI at 7:00am each morning.

    Should we run them more often?

    Tuesday, January 21, 2014 4:52 PM
  • hello,

    No need to run it more than once a day - only needs to run after IIS App Pools recycle. So after users keeping clicking OK to the error the report does start to refresh? What errors are in the SharePoint ULS logs?


    Paul Mather | Twitter | | CPS

    Tuesday, January 21, 2014 6:06 PM
  • Hello Claude

    While there is a list to things to double check when configuring Secure Store, I think the first thing I will do is "Set Credentials".   The password may be been changed or if several attempts to using the account is tried, it may have gotten locked out.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Wednesday, January 22, 2014 4:17 AM