Thursday, July 07, 2011 6:58 AMI 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.
Thursday, July 07, 2011 10:35 AM
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.
Thursday, July 07, 2011 10:55 AMModerator
Thursday, July 07, 2011 12:10 PM
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.
Friday, July 08, 2011 6:35 AM
Have you run the update on all servers?
What was the order of the procedures you carried out?
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
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:
Can you check the follow places in Central Admin and let us tknow the status?
- Central Admin > Upgrade and Migration > Check product and patch installation status
- 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
Friday, July 08, 2011 3:56 PM
What version of SQL Server are you running? What service pack? Is this 32 or 64 bit? Is it on a different server?
Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
Sunday, July 10, 2011 6:18 AMSQL Server 2008 R2, 64 bit, its on a different server