Answered by:
Project Server 2007 Database schema Differences

Question
-
We moved a Project server 2007 Farm to a new Project server 2007 Farm(New installation):
Differences between old setup and the new one:
Old Windows server 2003 Enterprise(64bit) All updates done up to latest.
Sql Server 2005 Sp3 Enterprise(64bit)
WSS3 sp2
New Windows server 2008 Standard sp1 + updates(64bit)
SQL Server 2008 Standard(64bit) SP1 (CU2 not installed yet)
WSS3 SP2
We get the following when profisioning the PWA Instance on the new Server: Failed to create PWA--see event log
Event Log error message:
Published database schema(12.2.3....) is newer than Project server Schema(12.2.2...)
Please Help.
Thx!
Friday, February 11, 2011 1:16 PM
Answers
-
Hi hennas,
This is because your new Project Server 2007 environment is on a lower service pack level than your old Project Server farm.
So make sure to install at least the same service pack AND cumulative updates on the new farm that have been installed on the old farm.
After you have done this, provisioning should work.
I hope this helps,
Hans
My EPM blog: Projectopolis- Marked as answer by Christophe FiessingerMicrosoft employee Saturday, February 12, 2011 8:25 PM
Friday, February 11, 2011 2:09 PM
All replies
-
Hi hennas,
Please go through the Brians's post related to the common provisioning errors, you will find the resolution of your error in the post.
let me know if its of any help.
| Khurram Jamshed | Follow my blog about Enterprise Project Management Solution | http://khurramjamshed.blogspot.com |- Proposed as answer by Alexander.Burton Friday, February 11, 2011 8:07 PM
Friday, February 11, 2011 2:02 PM -
Hi hennas,
This is because your new Project Server 2007 environment is on a lower service pack level than your old Project Server farm.
So make sure to install at least the same service pack AND cumulative updates on the new farm that have been installed on the old farm.
After you have done this, provisioning should work.
I hope this helps,
Hans
My EPM blog: Projectopolis- Marked as answer by Christophe FiessingerMicrosoft employee Saturday, February 12, 2011 8:25 PM
Friday, February 11, 2011 2:09 PM -
Just look at the VERSIONS table in the Published DB for instance, plenty of documentation on TechNet on this topic
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product PageSaturday, February 12, 2011 8:25 PM -
Its been solved thanks!
Hans.H Was the fix.
Friday, February 18, 2011 1:38 PM