Project Server Data Migration - Cheat Sheet

re: Project Server Data Migration - Cheat Sheet

Tina — Fri, 16 Jun 2006 07:34:10 GMT

That's great!

re: Project Server Data Migration - Cheat Sheet

Lidiane — Fri, 16 Jun 2006 08:12:41 GMT

I am glad you like it :)

re: Project Server Data Migration - Cheat Sheet

David Lewis — Thu, 22 Jun 2006 07:20:15 GMT

I realize this is probably futile, but given all the attention over the years to whizzy new features, is there a chance of backfilling some bread and butter features that would make the basic project management processes oh so much easier?

The prime exmaple in my book is tools to manage resource task sequences "by hand", including... (a) tagged links, so we can distinguish a link inserted to sequence/balance a resource from a logical dependency; (b) tools to quickly reassign tasks from one resource to another and (c) relink the task sequences easily, without having to manually rejigger the links.

Underlying all this is the -- very widespread -- observation that algorithmic resource levelling is...(how can I say this politely)... umm... useless (sorry), and the only way really to level is to manually sequence each resource's tasks.

There's much more along the same lines to deal with fractional assignments, multi-tasksing, coordinating tasks of different resoruces, etc etc, all in the same vein. But what I've oulined above would be such a leap forward that I would fly to Redmond and hug the whole team!

Sorry to hijack an irrelevant post for this rant, but after years of struggling with this stuff, I despair of ever being heard. Aren't you gflad you have a blog? ;-)))

Thanks for at least listening.

David Lewis (djlewis at triadic dot com)

re: Project Server Data Migration - Cheat Sheet

Oliver Lehmann — Thu, 22 Jun 2006 17:03:11 GMT

May I...ummm...disagree? Resource leveling is a great function in Microsoft Office Project if you have learnt how to use it. Better would be critical chain, of course, but I do not expect this seriously.

Oliver

Suggerimenti per migrare da Project Server 2003 a Project Server 2007

Igor Macori — Tue, 27 Jun 2006 16:43:43 GMT

Segnalo un bel post ricco di indicazioni e trucchetti per migrare il DB di Project Server da un ambiente...

re: Project Server Data Migration - Cheat Sheet

Steffen — Thu, 29 Jun 2006 13:57:00 GMT

Do you work with SQL 200 or 2005? What ist the best way to migrate Project Server with SQL and 2007?

I have a PS2003 on SQL and would like to migrate the database and the to the Beta2.

thanks Steffen

re: Project Server Data Migration - Cheat Sheet

Fraser Larcombe — Fri, 30 Jun 2006 04:12:43 GMT

I am actually having some problems installing the desktop version, it crashes at about 15% through the installation, does it every time, doesnt give me any idea of what has happened just says send info to MS, which I have done.

Any ideas, anyone else had the same problem?

Fraser

re: Project Server Data Migration - Cheat Sheet

krishna — Mon, 10 Jul 2006 11:22:36 GMT

plz reply

immedeatly

re: Project Server Data Migration - Cheat Sheet

Lanka Van Dort - lankavandort@orion-sys.com — Wed, 26 Jul 2006 17:55:23 GMT

Accidentaly deleted some resources from the Global Database. How to recover the resources? Using MS Porject 2003 Enterprise version. Thanks!

re: Project Server Data Migration - Cheat Sheet

Hrvoje — Fri, 08 Dec 2006 13:29:09 GMT

What about migration from Project Server 2007 Beta2 TR to RTM version ?

re: Project Server Data Migration - Cheat Sheet

Rinat — Mon, 08 Jan 2007 10:07:43 GMT

What about migration of sharepoint workspaces?

re: Project Server Data Migration - Cheat Sheet

Michael E — Wed, 10 Jan 2007 01:08:54 GMT

any suggestions on this failed upgrade?

01/09/2007 15:51:41.414 Project Server 2003 version is 11,2,15,20030816

01/09/2007 15:51:41.414 Time to execute CUpgrader::CheckP11Version(): 0 ms

01/09/2007 15:51:41.414 preparing Query select WADMIN_DEFAULT_LANGUAGE from dbo.MSP_WEB_ADMIN

01/09/2007 15:51:41.414 preparing Query select WADMIN_DEFAULT_LANGUAGE from MSP_WEB_ADMIN

01/09/2007 15:51:41.424 preparing Query select isnull(is_member(?), 0)

01/09/2007 15:51:41.434 preparing Query select isnull(is_member(?), 0)

01/09/2007 15:51:41.564 preparing Query select VERS_VERSION from dbo.MSP_VERSIONS where VERS_DEFAULT = 1

01/09/2007 15:51:41.574 preparing Query select UPG_PHASE_RUN_STATUS from dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND UPG_PHASE_RUN_STATUS = ?

01/09/2007 15:51:41.574 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?

01/09/2007 15:51:41.594 preparing Query exec dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003 ?, ?

01/09/2007 15:51:41.604 Executing query failed with -1

01/09/2007 15:51:41.604 Cmd failed retcode= -1

01/09/2007 15:51:41.604 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003'.

01/09/2007 15:51:41.604 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?

01/09/2007 15:51:41.614 PWA Migration: Setup Views to Project Server 2003 -- Failed.

01/09/2007 15:51:41.614 Time to execute CUpgrader::UpgradePWASetupViews(): 40 ms

01/09/2007 15:51:41.614 PWA Migration: Setup Views to Project Server 2003 -- Failed.

01/09/2007 15:51:41.614 Updating run table

01/09/2007 15:51:41.614 preparing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?

01/09/2007 15:51:41.614 Executing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?

01/09/2007 15:51:41.634 Migration finished with return code 80004005

01/09/2007 15:51:41.634 Project migration failed.

re: Project Server Data Migration - Cheat Sheet

Theron — Fri, 28 Sep 2007 05:50:17 GMT

Hi,

Is there any procedure/steps when migrating from Project Server 2007 to Project Server 2007.

re: Project Server Data Migration - Cheat Sheet

Anton Swanevelder — Tue, 27 Nov 2007 18:43:12 GMT

Thanks for this. It is a great help. Just a note for others: If your 2003 database is not yet upgraded to sp2a you can run the command line tool UPG10DB in the Utilities\Migration\Database folder on the Office Project Server 2007 installation media.

http://technet2.microsoft.com/Office/en-us/library/f1606be4-f257-4469-a35a-d9189d542ce41033.mspx?mfr=true

re: Project Server Data Migration - Cheat Sheet

Rully — Wed, 19 Mar 2008 12:57:11 GMT

I had problem how to migration Ms project 2007 from one database server to other database server.

for the first installation, application, database reside on same machine server.

how to migration database ms project to other server and aplication still in old server.

thanks before

Rully

re: Project Server Data Migration - Cheat Sheet

Rully — Wed, 19 Mar 2008 15:10:29 GMT

I have plan to migrate ms project sql server 2007

from one server to other server.

please advice and give me scenario case how to do it

thanks

re: Project Server Data Migration - Cheat Sheet

Roger — Thu, 20 Mar 2008 12:31:51 GMT

Hi there,

Any suggestions for this error message:

An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: SharePoint Products and Technologies cannot be configured. The current installation mode does not support SKU to SKU upgrades because there exists an older version of Windows SharePoint Services that must be upgraded first.

Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.

required fields have valid values ms project 2007

required fields have valid values ms project 2007 — Tue, 03 Jun 2008 18:15:00 GMT

PingBack from http://caleblocalnews.k2free.com/requiredfieldshavevalidvaluesmsproject2007.html

re: Project Server Data Migration - Cheat Sheet

Bartek — Tue, 01 Jul 2008 11:17:14 GMT

Well i have trouble migrating PS 2003 to PS 2007 too ;/

When i run the P12 migration tool it tells me that the project has succesfully migrated but... when i open PWA or try to access the project from PP - the project list is empty ;/

Any ideas what might be worng ... ?

re: Project Server Data Migration - Cheat Sheet

Virgilio Arciniegas — Sun, 24 Aug 2008 21:11:11 GMT

To Bartek:

Hi Bartek, make sure you are adding your projects to the save and publish section of the .ini file.

It seems that you just saved them.

re: Project Server Data Migration - Cheat Sheet

ivanlemus — Wed, 15 Oct 2008 23:22:29 GMT

Hello,

I am getting the error below when attempting a gradual migration form P2003 to P2007. Do you have any ideas about what could be causing it?.

NOTE:

- Project 2007 was upgraded with the "Infrastructure Update for Office Servers".

- The error happens at the end of the upgrade.

- I've looked in "[MSP_P12UPG_InstallDefaultData]" sproc on the Project Server -> Published DB and it references 'P11_MSP_WEB_VIEW_FIELDS'...but can not find that object.

- P2003 DBs hosted on sql 2000 and P2007 DBs are hosted on SQL2005.

Thanks for all your help. Have a nice day.

**********Phase:PWA migration start**********

10/15/2008 13:43:30.577 preparing Query select UPG_PHASE_RUN_STATUS from dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND UPG_PHASE_RUN_STATUS = ?

10/15/2008 13:43:30.577 PWA Migration: Starting Phase Setup default migration data.

10/15/2008 13:43:30.577 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?

10/15/2008 13:43:30.593 preparing Query exec dbo.MSP_P12UPG_InstallDefaultData

10/15/2008 13:43:30.936 Executing query failed with -1

10/15/2008 13:43:30.936 Cmd failed retcode= -1

10/15/2008 13:43:30.936 Err1 = S0002 Err2 = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'P11_MSP_WEB_VIEW_FIELDS'.

10/15/2008 13:43:30.936 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?

10/15/2008 13:43:30.936 PWA Migration: Setup default migration data -- Failed.

10/15/2008 13:43:30.936 Time to execute CUpgrader::UpgradePWASetupData(): 360 ms

**********Phase:PWA migration end**********

10/15/2008 13:43:30.936 Time to execute CUpgrader::UpgradePWA(): 360 ms

10/15/2008 13:43:30.936 Updating run table

10/15/2008 13:43:30.936 preparing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?

10/15/2008 13:43:30.936 Executing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINI

re: Project Server Data Migration - Cheat Sheet

ivanlemus — Fri, 24 Oct 2008 16:17:49 GMT

Here is the solution to the question I posted (provided by MS support):

1. Execute the script bellow against the project_2007_published_db.

2. run the migration tool again.

---------------------------------------------------

DECLARE @RC int

EXEC @RC = [Project2007_published_db_name].[dbo].[MSP_P12UPG_CreateAllViewsToProjectServer2003]

'project2003_db_server_name','project2003_db_name'

Note:

------

replace these values with your own:

- [Project2007_published_db_name]

- 'project2003_db_server_name'

- 'project2003_db_name'

----------------------------------------------------

Thank you all. happy friday!

re: Project Server Data Migration - Cheat Sheet

ivanlemus — Sat, 01 Nov 2008 07:07:47 GMT

hello all,

i am getting the following error when trying to attach a SharePoint 2.0 content db to a windows sharepoint services 3.0. do you have an idea about what could be causing it?

thx for all your help. have a nice weekend.

command:

----------------------------------------------

stsadm.exe -o addcontentdb -url http://usnapvm3devepm1:80 -databasename DevEPM_temp_310 -databaseserver usnapvm3devdb2

errors:

-----------------------------------------------

---------- C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\WEB SERVER EXTENSIONS\12\LOGS\UPGRADE.LOG

[SPWebTemplateSequence] [ERROR] [10/31/2008 11:41:57 PM]: Template PWS#0: SPSite Id=abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be accessed due to exception. Skipping this SPSite for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be found.

[SPWebTemplateSequence] [ERROR] [10/31/2008 11:41:57 PM]: Template PWS#0: SPSite Id=abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be accessed due to exception. Skipping SPWeb Id=813b3054-9e3f-46be-9c47-333c0e777afc for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be found.

[SPWebTemplateSequence] [ERROR] [10/31/2008 11:41:57 PM]: Template MPS#0: SPSite Id=abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be accessed due to exception. Skipping SPWeb Id=2b60587a-59a1-4b34-aaa6-12bc0cd7e030 for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be found.

[SPWebTemplateSequence] [ERROR] [10/31/2008 11:41:57 PM]: Template MPS#0: SPSite Id=abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be accessed due to exception. Skipping SPWeb Id=88bd14cf-8bf1-4e8e-8c47-91af6e16bf45 for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be found.

[SPWebTemplateSequence] [ERROR] [10/31/2008 11:41:57 PM]: Template MPS#0: SPSite Id=abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be accessed due to exception. Skipping SPWeb Id=8832366c-f5bf-487f-a200-986a100c9bf6 for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be found.

[SPWebTemplateSequence] [ERROR] [10/31/2008 11:41:57 PM]: Template MPS#0: SPSite Id=abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be accessed due to exception. Skipping SPWeb Id=ac80a789-b21a-4690-b2cc-c2375f87db81 for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be found.

[SPWebTemplateSequence] [ERROR] [10/31/2008 11:41:57 PM]: Template MPS#0: SPSite Id=abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be accessed due to exception. Skipping SPWeb Id=e9cc310c-792e-4c93-97a7-f1e3384cdeab for template upgrade. Exception: System.IO.FileNotFoundException: The site with the id abaaba05-0a21-4a37-85a2-ff9fcb8d41af could not be found.

[SPManager] [INFO] [10/31/2008 11:41:57 PM]: Inplace Upgrade session finishes. root object = SPContentDatabase Name=epm_migration1_il Parent=SPDatabaseServiceInstance Name=INSTANCE1, recursive = True. 7 errors and 0 warnings encountered.

re: Project Server Data Migration - Cheat Sheet

salamn — Sun, 15 Mar 2009 17:30:13 GMT

hi sir

iAM ENGINEER need the programs

thanks

re: Project Server Data Migration - Cheat Sheet

mike — Wed, 29 Apr 2009 19:30:42 GMT

The migration tool fails for me when it tries to migrate Enterprise Global...particularly with the Custom Fields in PS2003.

--- preparing Query select distinct TEXT_VALUE from dbo.MSP_TEXT_FIELDS where (TEXT_FIELD_ID = ? OR TEXT_FIELD_ID = ?) AND TEXT_VALUE IS NOT NULL

--- Executing query failed with -1

--- g_p11Comm.GetDistinctTextCustomFieldValues failed with 80004005

What could this be? How can identify what custom field or outline code is causing this issue?

**********Phase:Eglobal Migration start**********

04/29/2009 11:36:44.819 preparing Query select UPG_PHASE_RUN_STATUS from dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND UPG_PHASE_RUN_STATUS = ?

04/29/2009 11:36:44.819 Getting Project info from Project Server 2007

04/29/2009 11:36:44.819 preparing Query select PROJ_UID, PROJ_NAME, PROJ_TYPE from dbo.MSP_PROJECTS where PROJ_NAME = ?

04/29/2009 11:36:44.819 Could not get info for global20090428162504 in Project Server 2007

04/29/2009 11:36:44.819 preparing Query select PROJ_CHECKEDOUT from dbo.MSP_PROJECTS where PROJ_ID = ?

04/29/2009 11:36:44.835 Eglobal is not migrated. Starting migration of Eglobal

04/29/2009 11:36:44.835 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?

04/29/2009 11:36:44.835 Starting upgrade of eglobal global20090428162504

04/29/2009 11:36:44.835

04/29/2009 11:36:44.835 Opening project from Project Server 2003...

04/29/2009 11:36:44.835 Executing Query insert into dbo.MSP_P12UPGRADE_PROJECT_UPGRADES (UPG_RUN_UID, UPG_PROJ_P11_ID, UPG_PROJ_UID, UPG_PROJ_P11_NAME, UPG_PROJ_STATUS, UPG_PROJ_TYPE, UPG_PROJ_START_DATE) values (?, 1934, ?, ?, 3, ?, GETDATE())

04/29/2009 11:36:44.835 preparing Query insert into dbo.MSP_P12UPGRADE_PROJECT_UPGRADES (UPG_RUN_UID, UPG_PROJ_P11_ID, UPG_PROJ_UID, UPG_PROJ_P11_NAME, UPG_PROJ_STATUS, UPG_PROJ_TYPE, UPG_PROJ_START_DATE) values (?, 1934, ?, ?, 3, ?, GETDATE())

04/29/2009 11:36:44.851 preparing Query exec dbo.MSP_P12UPG_DELETE_PROJECT_MAPPINGS ?

04/29/2009 11:36:52.336 Time to execute P12UpgradeDoc::OpenP11Project(): 7485 ms

04/29/2009 11:36:52.336 Executing Query update dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set UPG_PROJ_STATUS = 4, UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID = 1934

04/29/2009 11:36:52.336 Successfully Opened from Project Server 2003

04/29/2009 11:36:52.601 Time to execute P12UpgradeDoc::FixUpLookupTableValueRowNumber(): 265 ms

04/29/2009 11:36:52.601 preparing Query select distinct attr.ATTRIB_FIELD_ID from dbo.MSP_FIELD_ATTRIBUTES attr, dbo.MSP_PROJECTS proj where attr.PROJ_ID = proj.PROJ_ID and proj.PROJ_TYPE = 2

04/29/2009 11:36:52.617 preparing Query select max(MD_PROP_ID_SECONDARY) from dbo.MSP_CUSTOM_FIELDS

04/29/2009 11:36:52.617 Maximum existing enterprise assignment custom field pid = 255885314

04/29/2009 11:36:52.617 preparing Query select distinct TEXT_VALUE from dbo.MSP_TEXT_FIELDS where (TEXT_FIELD_ID = ? OR TEXT_FIELD_ID = ?) AND TEXT_VALUE IS NOT NULL

04/29/2009 11:36:52.632 Executing query failed with -1

04/29/2009 11:36:52.632 Cmd failed retcode= -1

04/29/2009 11:36:52.632 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server Driver][SQL Server]The text data type cannot be selected as DISTINCT because it is not comparable.

04/29/2009 11:36:52.632 cmd.Execute failed with status hr = 80004005

04/29/2009 11:36:52.632 g_p11Comm.GetDistinctTextCustomFieldValues failed with 80004005

04/29/2009 11:36:52.632 Time to execute P12UpgradeDoc::FixupEnterpriseCustomFields(): 31 ms

04/29/2009 11:36:52.632 FixupEnterpriseCustomFields failed with 80004005

04/29/2009 11:36:52.632 Time to execute P12UpgradeDoc::Upgrade(): 7796 ms

04/29/2009 11:36:52.632 Migration failed for project global20090428162504

04/29/2009 11:36:52.679 Time to execute P12ProjectUpgrader::Upgrade(): 7843 ms

04/29/2009 11:36:52.679 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?

04/29/2009 11:36:52.695 Ent global migration failed with error 80004005

**********Phase:Eglobal Migration end**********

re: Project Server Data Migration - Cheat Sheet

Parag Kharche — Wed, 10 Jun 2009 10:17:30 GMT

I have migrated from PS 2007 to PS 2007 but facing problem in restoring project workspaces...

How to restore...

Reply..ASAP..

re: Project Server Data Migration - Cheat Sheet

Kannan — Thu, 13 Aug 2009 16:20:29 GMT

I get the following error when i am trying to migrate from PS2003 to PS2007. The SQL Server 2000 and SQL server 2005 are on the same box. The project server 2003 database on SQL Server 2000 is restored on to SQL server 2005. Any help is appreciated

08/13/2009 17:16:51.500 Log file Initialized

08/13/2009 17:16:51.510 Migration tool version is 12,0,4518,1014

08/13/2009 17:16:51.510 Configuration file is C:\Documents and Settings\Kannan\My Documents\P12MIGRATION.INI

08/13/2009 17:16:54.273 Connecting to Project Server 2007 Draft db...

08/13/2009 17:16:54.374 Creating DSN: name = MSP-12-WORKING-DB-DSN, server = Server2003, db = ProjectServer_Draft, trusted = 1

08/13/2009 17:16:55.205 Created DSN MSP-12-WORKING-DB-DSN

08/13/2009 17:16:56.316 Connection string DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes

08/13/2009 17:16:56.316 Connecting to Project Server 2007 published db...

08/13/2009 17:16:56.326 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN, server = Server2003, db = ProjectServer_Draft, trusted = 1

08/13/2009 17:16:56.356 Created DSN MSP-12-PUBLISHED-DB-DSN

08/13/2009 17:16:56.467 Connection string DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office system;WSID=SERVER2003;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes

08/13/2009 17:16:56.467 Project Server 2007 url = http://Server2003/pwa

08/13/2009 17:16:56.477 Creating Project Server 2007 soap object...

08/13/2009 17:16:57.839 Creating Project Server 2007 resource soap object...

08/13/2009 17:16:57.909 Creating Project Server 2007 winproj soap object...

08/13/2009 17:16:58.169 Creating Project Server 2007 wssinterop soap object...

08/13/2009 17:16:58.229 Getting all Upgraded Projects from Project Server 2007

08/13/2009 17:16:58.249 preparing Query select distinct A.UPG_P11_ENT_ID, A.UPG_P12_ENT_UID, B.PROJ_NAME, C.UPG_PROJ_P11_NAME from dbo.MSP_P12UPGRADE_ENTITY_MAPS A, dbo.MSP_PROJECTS B, dbo.MSP_P12UPGRADE_PROJECT_UPGRADES C WHERE A.UPG_P12_ENT_UID = B.PROJ_UID AND A.UPG_P11_ENT_ID = C.UPG_PROJ_P11_ID AND A.MD_ENT_TYPE_UID = 'CECFE271-6660-4ABE-97ED-208D3C71FC18'

08/13/2009 17:16:58.339 preparing Query select WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from dbo.MSP_WEB_ADMIN

08/13/2009 17:16:58.399 Project Server 2007 Project Server version is 12,0,15,45181014

08/13/2009 17:16:58.399 Connecting to Project Server 2007 ...

**********Phase:Tool initialization end**********

08/13/2009 17:16:59.952 Initializations succeeded, Starting migration

**********Phase:Migration initialization start**********

08/13/2009 17:16:59.952 Policy to fix up project server security categories = true.

08/13/2009 17:16:59.972 Policy to never publish master projects = true.

08/13/2009 17:16:59.982 WARNING: Projects will be migrated even if they have multiple status managers for the same task.

08/13/2009 17:17:00.613 Adding to run table

08/13/2009 17:17:00.613 preparing Query insert into dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME, UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())

08/13/2009 17:17:00.633 Executing Query insert into dbo.MSP_P12UPGRADE_UPGRADE_RUNS (UPG_RUN_UID, UPG_RUN_MACHINE_NAME, UPG_RUN_STATUS, UPG_RUN_START_DATE) values (?, ?, 0, GETDATE())

08/13/2009 17:17:00.743 Connecting to Project Server 2003 sql server project database

08/13/2009 17:17:00.753 Creating DSN: name = P11-PROJECT-SERVER-DSN, server = Server2003, db = ProjectServer2003, trusted = 1

08/13/2009 17:17:00.773 Created DSN P11-PROJECT-SERVER-DSN

08/13/2009 17:17:01.033 Connection string DSN=P11-PROJECT-SERVER-DSN;UID=;APP=2007 Microsoft Office system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes

08/13/2009 17:17:01.043 Connecting to the Project Server 2003 sql server web database

08/13/2009 17:17:01.043 Creating DSN: name = P11-PROJECT-SERVER-WEB-DSN, server = Server2003, db = ProjectServer2003, trusted = 1

08/13/2009 17:17:01.063 Created DSN P11-PROJECT-SERVER-WEB-DSN

08/13/2009 17:17:01.294 Connection string DSN=P11-PROJECT-SERVER-WEB-DSN;UID=;APP=2007 Microsoft Office system;WSID=SERVER2003;DATABASE=ProjectServer2003;Trusted_Connection=Yes

08/13/2009 17:17:01.314 preparing Query select WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from dbo.MSP_WEB_ADMIN

08/13/2009 17:17:01.634 Project Server 2003 version is 11,2,15,20030816

08/13/2009 17:17:01.634 Time to execute CUpgrader::CheckP11Version(): 341 ms

08/13/2009 17:17:01.634 preparing Query select WADMIN_DEFAULT_LANGUAGE from dbo.MSP_WEB_ADMIN

08/13/2009 17:17:01.734 preparing Query select WADMIN_DEFAULT_LANGUAGE from MSP_WEB_ADMIN

08/13/2009 17:17:01.784 preparing Query select isnull(is_member(?), 0)

08/13/2009 17:17:01.924 preparing Query select isnull(is_member(?), 0)

08/13/2009 17:17:01.995 preparing Query select isnull(is_member(?), 0)

08/13/2009 17:17:03.377 preparing Query select VERS_VERSION from dbo.MSP_VERSIONS where VERS_DEFAULT = 1

08/13/2009 17:17:03.687 preparing Query select UPG_PHASE_RUN_STATUS from dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND UPG_PHASE_RUN_STATUS = ?

08/13/2009 17:17:05.049 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?

08/13/2009 17:17:05.620 preparing Query exec dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003 ?, ?

08/13/2009 17:17:05.690 Executing query failed with -1

08/13/2009 17:17:05.690 Cmd failed retcode= -1

08/13/2009 17:17:05.690 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003'.

08/13/2009 17:17:05.710 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?

08/13/2009 17:17:05.740 PWA Migration: Setup Views to Project Server 2003 -- Failed.

08/13/2009 17:17:05.750 Time to execute CUpgrader::UpgradePWASetupViews(): 2063 ms

08/13/2009 17:17:05.750 PWA Migration: Setup Views to Project Server 2003 -- Failed.

08/13/2009 17:17:05.770 Updating run table

08/13/2009 17:17:05.770 preparing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?

08/13/2009 17:17:05.770 Executing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ?

08/13/2009 17:17:06.050 Migration finished with return code 80004005

08/13/2009 17:17:06.050 Project migration failed.