Project Server Database Timeout


Hey,


Since it is the end of the year, I am slowly working my way through my Outlook tasks to be able to start fresh in the new year. I seemed to have missed posting a change we made to the PSI in the SP1 Rollup. In the SP1 Rollup, we added two new methods to the Admin PSI. One allows you to read the current database timeout and the second allows you to set it:



  • SetDatabaseTimeout(DatabaseTimeoutType.Core, timeout);

  • GetDatabaseTimeout(DatabaseTimeoutType.Core);
                      

We added these methods because, in some deployments, the default timeout was not long enough. If your Project Server deployment is experiencing database timeouts, you may want to try changing the default timeout. Attached is sample code on how to use these methods.


Chris Boyd


 


Technorati Tags: ,,

PsDbTimeout.zip

Comments (2)

  1. António Madeira says:

    I have been trying to overcome database timeouts on views in PWA. I tried to use the PsDBTimeout app but apparently the SetDatabaseTimeout method does not exist in the Admin Webservice. Can you advise?

    Thanks in advance.

    Antonio Madeira (antonio.madeira@pmo-projects.com)

    PS: I have updated my office server components (officeserver2007sp1-kb936984-x86-fullfile-en-us.exe).