Project Resource Kit for Project Server 2007 Released!


This is now available for download at http://www.microsoft.com/downloads/details.aspx?FamilyId=A33D253C-6424-48E4-B87E-0861D1977BB7&displaylang=en.  Just had an e-mail from Phil Smail with these details:

The Project Resource Kit for Project 2007 has released. It’s available for x86 and x64 and the tools are English only

The PRK consists of the following tools:

· Portfolio Analyzer Views Migration: Allows an administrator to bulk edit the location of an analysis server for multiple data analysis views.

· Project Server Settings Backup and Restore (Playbooks): Allows an administrator to backup Project Server settings and restore those settings to another Project Server.

· Project Server Data Populator: Allows an administrator to populate Project Server with projects, resources and other objects. Useful for helping capacity and performance testing.

· Project Workspace Site Relinker: Allows an administrator to relink the connection between Project Server and Project Workspace sites.

· View Effective Rights: Allows an administrator to query the Project Server to determine the effective permissions of users against projects or resources.

Full documentation will appear in the next couple of weeks but I’ll get early docs up on the Project blog either today or tomorrow

 

I'll be finding time to play with these over the next few days - and see the settings backup and restore tool as a really useful one.  This may be something we use in support to get configuration details of your servers if we are investigating an issue that isn't data related - so we don't need the full database set - but need to know how you have configured your server.

Enjoy!  And let us know how you get on with these.

Technorati Tags: Project Server 2007


Comments (40)

  1. Brian, this is fantastic stuff.  The settings transfer tool has been a long time coming, and the Site relinker is just absolutely crucial!

    thanks!

    Nico

  2. Duncan Griffin says:

    Agree, great utility…

    If I could ask just one more thing, it would be…Can I run this as a report…Would be great to have a documented config log of configured environments…

    Thanks

  3. Hi Duncan,

    As the file it puts out is XML it should just be a case of throwing the right XLS at it to get a report in whatever format you want.  There is my challenge to readers of this blog…

    Then just build it into a timer process.

    Best regards,

    Brian.

  4. Mocha says:

    i’m interesting with this feature …

    Project Server Settings Backup and Restore (Playbooks): Allows an administrator to backup Project Server settings and restore those settings to another Project Server.

    But could i use this tool to backup all settings include database to another server. Cause i have plan to move my project server to another server, but when i tried to restore the database (i have already backup the server from old server).. its to many question that related to old server.

    Im afraid it makes my old server could not running project server again. cause i still want to use my project server in  old server.

    Best regards,

    Mocha

  5. Hi Mocha,

    I will probably do a posting in a couple of days positioning this against a backup/restore migration.  Have you read my blog posting on backup?  You should find it with a search.

    Best regards,

    Brian.

  6. cesar cruz says:

    Brian,

    Have you had any time to look at the Backup and Restore?

    I can’t find any configuration information as when I execute the Playbooks.exe and enter my PWA site address it keeps complaining about the URL, name and password is incorrect.

    Help. I need to copy my production PWA project, sites, global, etcc. to my test server.

    Thank You.

  7. Gabriel says:

    Hi,

    I am trying to install the resource kit on a windows 2003 x64, I download the file ProjectServerResourceKit(x64).exe from Microsoft and when I try to execute ViewEffectiveRights.exe the application close suddenly. I check the exe file and i discover that is a x86 application, I try to execute on a Windows 2003 x86 and work fine, any one have this issue?, how can i solve?

    Thank you in advance, best regards  

  8. Hi Gabriel,

    The tool is working fine for me on my x64 machine.  How did you identify yours as x86?  My exe is 100KB and dll 50KB for comparison if that helps.

    Best regards,

    Brian.

  9. Gabriel says:

    Hi Brian,

    In order to identify if the application is x86 or x64 i use the freeware utility “Dependency Walker for Win64 (x64)”. My exe is 109KB and dll 50KB, because of that I suppose that is not the same version. The exe on the x86 download have the same size that in the x64 download. Which step must I follow in order to get an x64 version of this exe?

    Thank you in advance, best regards  

  10. Karina Kamp says:

    Hi Brian

    I’ve the same problem as Gabriel

    I got the following error message when using the console:

    Unhandled Exception: System.InvalidCastException: Unable to cast object of type

    ‘System.DBNull’ to type ‘System.String’.

      at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate meth

    od, Object[] args, Boolean synchronous)

      at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)

      at ViewEffectiveRights.DataManager.RunLoadQuery(String query, DataSetCallback

    callback, Object[] passThrough)

      at ViewEffectiveRights.DataManager.RunLoadQuery(Object args)

      at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, C

    ontextCallback callback, Object state)

      at System.Threading.ThreadHelper.ThreadStart(Object obj)

    Any Ideas?

    The connection to the database works, but I’m not able to enter any information

    Thanks and best regards

  11. I am out of the office at the moment – but I will look into this on my return and try and get an answer as to why Gabriel and Karina are running into this issue.

    Best regards,

    Brian

  12. Michael Richards says:

    Has anyone tried the relinkallwsssites.exe?  We moved our project server and wss to a new server and our project site workspace links are broken.  When I try to use the relinkallwsssites tool, I keep getting the error below for the ‘pwa’ server.

    ERROR: Unable to find specified server http://<mynewservername>/pwa. Check the input parameters and try again.

    I can successfully navigate to the http://mynewservername/pwa.  Any ideas would be welcomed.  Thanks in advance.

  13. vserrano says:

    Hi Brian

    I am trying to do a migration of data (backup and restore) between environments Project Server 2007 in different domains. Can it be done?

    Thanks!

  14. Jeff Uhrlaub says:

    Has anyone come up with an answer for the URL, name and password problem with the playbooks tool? it was working for us and then stopped.

    Thanks.

  15. Jeppe Jakobsen says:

    Anyone found a solution for the problem when running the relink tool

    ERROR: Unable to find specified server http://<mynewservername>/pwa. Check the input parameters and try again.

    i keep getting this error, and have no idea what is causing it, the sites are working fine

  16. Hi Jeppe,

    I am not aware of this particular issue. Are you using host headers?

    Check the syntax against the usage:-

    USAGE: RelinkAllWSSSites WSSServerURL ProjectServerURL [Silent] [QuitOnError]

      WSSServerURL      Required parameter in the form of http://server:port

      ProjectServerURL  Required parameter in the form of http://server/pwa

      [QuitOnError]        Optional. When specified, the application will stop if an error is encountered

      [Silent]                  Optional. When specified, per project progress information will not be displayed

    Best regards,

    Brian.

  17. Steve says:

    Hi Brian,

    When I try to run Playbooks.exe, I keep getting this error:

    ERROR: Server was unable to process request. Cannot open database SSPrvCfg01 requested by the login . The login failed

    for user  ZZZZZusername  ( I have just made this username up )

    Please set URL, username andpassword correctly.

    Now I have checked

    – the username is a domain user but is sa in the SQL server ( we are using a named instance of SQL 2005 with SP2 ). The user has all access to all databases required.

    – The user is a local administrator on the local box.

    Can you suggest a cause of the fault please? This is driving me nuts.

    Thanks

    Steve.

  18. Hi Steve – You say the db is a named instance – but the name SSPrvCfg01 does not indicate this, unless it is an alias.  I have not tried playbooks with aliases, but have seen issues in other parts of Project Server where an alias is not defined on the server that you are running on and therefore cannot be contacted.

    Best regards,

    Brian.

  19. Steve says:

    Hi Brian

    I managed to work it out –

    I logged onto the box with the project server service account we set up at install time.

    Then I went into IE under Tools, Options and scrolled down to  "User AuthenticationLogon" section and I set it to "Automatic logon with current username and password".  

    This now seems to work – it seems the tool is using IE based authentication. Weird, but there you go. Might be worth including this as a note in the next release as its a very useful tool.

    Cheers

    Steve.

  20. Steve says:

    Hi Brian,

    I also get the same error as Jeppe with the RelinkAllWSSSites tool giving the same error. Any ideas please?

    I used :

    RelinkAllWSSSites http://server_name:80  http://server_name/pwa

    where "server_name" is my QA server name

    Any ideas please?

    Cheers

    Steve.

  21. Thanks for the feedback Steve, and for the Relink tool (same Steve? another Steve?) I will take a look at this tomorrow on the system I used for the posting and see what happens.

    Best regards,

    Brian.

  22. For the relink error "ERROR: Unable to find specified server http://<mynewservername>/pwa&quot; one cause can be that the WSS and PWA URLs are under different SSPs.  For the tool to work they need to be in the same SSP.  You could change associations to test this out.

  23. Yves Z. says:

    Hi Brian.

    My question is about Playbooks. I backuped settings from a Project Server instance. These instance is linked to Active Directory and the instance where I want to restore the settings in on a single server and not connected to Active Directory. To access these instance with IE I put my logon/password on the dialog box and with Project Professional I put my user credentials. But with Playbooks I cannot fill in my user name/password to access the required instance and it doesn’t work. Except the "Forms authentication" (which does not work on these instance) there is no way to put other credentials and the credentials I used to open windows are not the same than the credentials to access the Project server instance…

    Thank you for your help

    Yves

  24. Hi Yves,

    As the single server is not on the domain it will not be able to authenticate.  I would suggest you implement the forms auth on the single server for forms authenticated users, and then these users will be able to log in (using the same ADAM or aspnetdb credentials if these are copied across).  Also I assume you can still connect as the administrator that was used to provision the PWA site – so using this account you could change the a users account from <domain>user to <singleserver>user and then create a local account on your single server for any accounts you want to use.  To change many users (and only do this in your test single server environment!) you could edit the MSP_RESOURCES table in the published database and change the WRES_ACCOUNT field to match a local user account on the single server.

    This will only fix things for Project – if WSS is also important to you in the single server environment the permissions will need to be sync’d – and it will still not address all things like active issues etc.

    Let me know if this helps.

    Best regards.

    Brian.

  25. Sadaf Shaikh says:

    Has anyone tried the relinkallwsssites.exe when restoring the Project Server Backup onto the same Server ?

    Our production server had to be formatted and Project Server 2007 had to be re-installed.

    I have successfully restored from the Full Farm backup, that was taken prior to the re-installation. All the project tasks , timesheets and resource related data is coming up, but WSS project workspaces created for the projects are not connecting as the project site workspace links are broken.

    Tried using the relinkallwsssites tool, i’m getting the following:

    C:Project Resource Kit>RelinkAllWSSSites http://epm2007 http://epm2007/pwa

    10/24/2008 2:29:01 PM : INFO: The site for project KalSoft – EPM 2007 with GUID

    774b669e-a860-4052-9c01-be4424bc6356 does not exist in the current web application.

    But when i try to manully provision a workspace site i get the “This project already has a website asscoauted with it” message. Deletion via Server Settings gives the message that ” No Project Workspace exists for KalSoft – EPM 2007″

    Gaurav’s posting concerning “Steps to Move Project Server 2007 from One Environment to Another Including WorkSpace” didn’t help.

    Is it because I’m not moving to another server, just trying to relink workspaces to projects on the same server but in a restore scenario ?

    Any ideas/workarounds will be appreciated

  26. Hi Sadaf,

    Probably too late for you unless you go to SQL backups – but if your SQL Server was on a different server then you should have only needed to re-connect to the farm and entered the SharePoint Configuration database details to get up and running again.  I would also have expected the links to be in place if nothing else had changed on the server.  Can you manually enter site details in the Project Workspaces page on Server Setings?

    Best regards,

    Brian.

  27. Gary Hess says:

    Brian,

    I am trying to make use of the RelinkAllWSSSites.exe tool without success.  We had to try and recreate a Project server form SQL backups.  I have resored the DBs and am created a PWA site but the project sites are not linked.  When I run:

    RelinkAllWSSSites.exe wsserverurl http://hostpwa01:80 projectserverurl http://hostpwa01/pwa4

    I am always greated with ERROR: Invalid Server address wsserverurl.  Check the input parameters and try again.

    I do not have any host headers.  All web apps are in 1 SSP.  I have tried with and without editing the RelinkAllWSSSites.exe.config file to have the correct server name in the urls included in it.

    Any help you could give would be greatly appreciated.

    Thanks in advance,

    Gary

  28. mark.stafford@defence.gov.au says:

    Hi All,  

    In terms of the RelinkAllWSSSites.exe tool issue

    eg: ERROR: Unable to find specified server http://<WSSServerURL&gt;:<port>. Check the input parameters and try again

    I dropped the port number from the WSSServerURL command line argument and it works!

  29. Julie Spence says:

    When I ran the Playbook last year it ran successfully, and now I’m receiving "unauthorized" errors when I run it.  I’m launching it with accounts that are set up as Administrators in Project Server, and we use only Windows Authentication. URL is in Trusted Sites with "Automatic Logon with current ID" selected.

    PlaybooksLogger Started 02/09/2009

    06:34:56

    06:34:56 : Running application ServerUrlForm

    06:35:11 : Server URL set to http://<PWA ServerName>/pwa

    06:35:11 : Initializing Web Services…

    06:35:11 : ERROR: The request failed with HTTP status 401: Unauthorized.

    Please set URL, Username, password correctly

    I can’t figure out where else authentication is occurring – any assistance would be greatly appreciated.

    Thanks,

    Julie

  30. Hi Julie,

    I haven’t used the tool lately – but a good starting point for troubleshooting would be the IIS logs.  You should be able to identify at least which site is giving the 401 and to which account.

    Best regards,

    Brian.

  31. Christoph Muelder says:

    Hi Julie and Brian,

    the 401 error seems to be related with the use of a FQDN for the pwa url. Playbooks.exe does not seem to use the Local Intranet / Trusted Site settings of IE anymore (perhaps a security feature of .NET 2.0/3.0 SP2?) but tries to logon with anonymous logon only?

    I extended my PWA application to another website that uses a hostname only. With this it works again.

    Best regards

    Christoph

  32. carlosnegroni@hotmail.com says:

    Brian:

    Hi, I moved a Project Server 2007 to another machine but when I tried to use the tool RelinkAllWSSSites I got the following message:

    "The request failed with HTTP status 401: Unauthorized.."

    I’m using an account which belongs to the Local Admins of the new server. And the command is: RelinkAllWSSSites.exe http://des-project:18652 http://des-project/pwa

    What can I do?

    Thank you very much

    Regards

    Carlos Negroni

  33. Hi Carlos,

    I assume the user was also a user in Project Web Access?

    Best regards,

    Brian.

  34. FrenchMan says:

    Hi,

    I just try to make a backup/restore with playbooks.exe and i got a problem during restore.

    Error message is :

    ERROR: Project Server Error: GeneralReadOnlyRow Context: Restoring Settings to Server .

    Could you help me please ?

    —————————————-

    —————————————-

    10:55:09 : ========================================================================================================================

    10:55:09 : Restoring Settings to Server http://w2K3R2FR/pwa

    10:55:09 : ========================================================================================================================

    10:55:09 :    Restoring Additional Server Settings…

    10:55:09 :    Restoring Alerts and Reminders…

    10:55:09 :    Restoring Server-Side Event Handler Configuration…

    10:55:09 :    Restoring Active Directory Resource Pool Synchronization…

    10:55:09 :    Restoring Project Workspace Provisioning Settings…

    10:55:09 :    Restoring Timesheet Periods…

    10:55:10 :       SoapException: System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=GeneralReadOnlyRow Instructions: Pass this into PSClientError constructor to access all error information

      à Microsoft.Office.Project.Server.WebService.Admin.UpdateReportingPeriods(TimePeriodDataSet dsDelta, Boolean validationOnly)

    10:55:10 :       ERROR: Project Server Error: GeneralReadOnlyRow Context: Restoring Settings to Server .

  35. Jad says:

    Hi,

    you will obtain this error once your timesheets are closed. if they are closed,they are in a read only status. in order to restore your timesheets, you must set your timesheets from closed to open…backup your system and then try to restore it.

    Regards,

  36. Sam says:

    Hi Brian,

    I am getting following error while restoring the Custom fields and Lookuptable using Playbook

    For Lookup Table:

    SoapException: System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=LookupTableInvalidUID Instructions: Pass this into PSClientError constructor to access all error information

      at Microsoft.Office.Project.Server.WebService.LookupTable.UpdateLookupTables(LookupTableDataSet ltds, Boolean validateOnly, Boolean autoCheckIn, Int32 language)

    ERROR: Project Server Error: LookupTableInvalidUID Context: Creating lookup table TestLT

    For Custom Fields:

    Creating custom field TestCF…

    SoapException: System.Web.Services.Protocols.SoapException: ProjectServerError(s) LastError=CustomFieldInvalidUID Instructions: Pass this into PSClientError constructor to access all error information

      at Microsoft.Office.Project.Server.WebService.CustomFields.UpdateCustomFields(CustomFieldDataSet cfds, Boolean validateOnly, Boolean autoCheckIn)

    ERROR: Project Server Error: CustomFieldInvalidLookupTableUID Context: Updating custom field TestCF.

    ERROR: Project Server Error: CustomFieldInvalidUID Context: Updating custom field TestCF.

    Thanks

    Sam

  37. Mark says:

    Hi Brian,

    I’m gettnig the same error as others here:

    ERROR: Unable to find specified server http://<mynewservername>/pwa. Check the input parameters and try again.

    Only my "pwa" is installed on a different port to "80" (http://<mynewservername&gt;:<myportnumber>/pwa). Is it possible that my port nnumber not being "80" poses a problem, and if so, how can one work around it. We would prefer to leave the port 80 for another service.

  38. SJ says:

    Hi All,

    I am having the same issue as Mark and Steve. Have checked everything over and over again. There is only one SSP. The error I get is Unable to find specified server <PWA Instance Name> Check the input parameters and try again.

    Any help will be HIGHLY appreciated.

    Thank you,

  39. SJ says:

    Hello all,

    I have managed to fix my Relink issue. You have to run the command as the primary administrator of the Web Application. Of course it may or may not apply to your situation.

  40. Thanks for finding your own answer sJ, and for coming back and posting it!

    Best regards,

    Brian

Skip to main content