Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
PWA not working after installing Project Server 2010 SP1

Proposed Answer PWA not working after installing Project Server 2010 SP1

  • Thursday, July 07, 2011 6:58 AM
     
     
    Sign In to Vote
    0
    I have installed this SP1 on a Win Server 2008 R2 64bit machine where SP 2010 and PS 2010 was already running having Feb 2010 CU for Project Server 2010. When i installed SP1 and then tried to open my PWA the following error displayed on the web browser:

    The databases are out of the range of compatibility, upgrade your databases.
    Maaz Ibrahim
     

All Replies

  • Thursday, July 07, 2011 10:35 AM
     
     
    Sign In to Vote
    0

    hi MAAZ,

    Have you followed the Necessary Steps to Install SP1 like Stoping the Project Server Queue Account etc,

    Please let me if you have Multi server environment.

    Nur Mondal
     
  • Thursday, July 07, 2011 10:55 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    When you say you have installed, did you run the config wizard after installing the binaries? If so, did it complete successfully?

     

    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
     
  • Thursday, July 07, 2011 12:10 PM
     
     
    Sign In to Vote
    0

    Yes i ran the Config Wizard after installing and restarting the machine, the Configuration wizard failed and some error shown up in the log like;

    ERR            An exception of type Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException was thrown.  Additional exception information: An update conflict has occurred, and you must re-try this action. The object SPUpgradeSession Name=Upgrade-20110707-145005-293 was updated by Administrator, in the PSCONFIG (3872) process, on machine <machine name>.  View the tracing log for more information about the conflict.
    Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException: An update conflict has occurred, and you must re-try this action. The object SPUpgradeSession Name=Upgrade-20110707-145005-293 was updated by Administrator, in the PSCONFIG (3872) process, on machine <machine name>.  View the tracing log for more information about the conflict.

     

    I have also tried psconfig update command its also not working as well.

    While looking at the Health Analyzer i identified that only ProjectServer_Reporting database is not updating rest of the other dbs are updating correctly.

    Maaz Ibrahim
     
  • Friday, July 08, 2011 6:35 AM
     
     
    Sign In to Vote
    0

    Hi Maaz,

     

    Have you run the update on all servers?

    What was the order of the procedures you carried out?

    Did you

    1) Run the binaries on all servers but not the Configuration wizard?

    2) next run the configuration wizard on the server running Central Administration

    3) last run the Configuration wizard on all remaining servers?

     
  • Friday, July 08, 2011 3:22 PM
     
     Proposed Answer
    Sign In to Vote
    0

    Maaz,

    Is it single server environment or multi-server environment?

    In case of multi server environment, you have to follow the sequence. Read this post for some nice discussions earlier:

    http://social.technet.microsoft.com/Forums/en-US/projserv2010setup/thread/305063b0-d967-403a-a7c0-38d664888234

    Can you check the follow places in Central Admin and let us tknow the status?

    1. Central Admin > Upgrade and Migration > Check product and patch installation status
    2. Central Admin > Upgrade and Migration > Review Databases Status

    In one of my roll out on 3 server setup (web, app, SQL), i ran SPF SP1 + MSPS SP1 + June 2011 CU on app server and then ran it on web server.  After that when I went to item 1 above i.e 'Check product and patch installation status' page, I found that my web server was showing 'Missing / Required' under the Install Status column for each component. Also at the bottom of the same page I had this error in red "Warning: The farm server do not currently have the same product and patch level as each other. Upgrade should not be run on any server until all farm server have the same set of required products and patches installed."

    At that point I rebooted the app and web servers and after reboot the status of web server on that page showed 'Installed'.

    At that point if you go to Review Database Status page (item 2 above), you will notice status message 'Database is in compatibility range and upgrade is recommended' for databases. I ran the SP config Wizard and it was successfull.

    Look at the status on those two pages and make sure the services are stopped and none of the service is doing work on the databases. Reporting database is not updating!!!.... make sure the scheduled cube build operation is not doing something at that same.

    __________________________________________________

    Faisal Masood – PMP

    www.FaisalMasood.com | www.Softvative.com | www.epmadmin.com

    Blog | Twitter | YouTube

     
  • Friday, July 08, 2011 3:56 PM
     
     
    Sign In to Vote
    0

    What version of SQL Server are you running?  What service pack?  Is this 32 or 64 bit?  Is it on a different server?

    Cheers!

    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    www.WhartonComputer.com
     
  • Sunday, July 10, 2011 6:18 AM
     
     
    Sign In to Vote
    0
    SQL Server 2008 R2, 64 bit, its on a different server
    Maaz Ibrahim