From: Choolu on 6 Oct 2009 14:01 I am having problems migrating my project server 2003 to project server 2007. I am doing an in-place upgrade/migration on the same server (win2k3 server standard). The -verify shows up clean: 10/06/2009 09:19:46.047 Log file Initialized 10/06/2009 09:19:46.047 Migration tool version is 12,0,4518,1014 10/06/2009 09:19:46.047 Configuration file is c:\migrationscripts \p12migration.ini 10/06/2009 09:19:47.156 Connecting to Project Server 2007 Draft db... 10/06/2009 09:19:47.156 Creating DSN: name = MSP-12-WORKING-DB-DSN, server = vc0753-server, db = ProjectServer_Draft, trusted = 1 10/06/2009 09:19:47.219 Created DSN MSP-12-WORKING-DB-DSN 10/06/2009 09:19:47.328 Connection string DSN=MSP-12-WORKING-DB- DSN;UID=;APP=2007 Microsoft Office system;WSID=VC0753- SERVER;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes 10/06/2009 09:19:47.328 Connecting to Project Server 2007 published db... 10/06/2009 09:19:47.328 Creating DSN: name = MSP-12-PUBLISHED-DB- DSN, server = vc0753-server, db = ProjectServer_Published, trusted = 1 10/06/2009 09:19:47.328 Created DSN MSP-12-PUBLISHED-DB-DSN 10/06/2009 09:19:47.344 Connection string DSN=MSP-12-PUBLISHED-DB- DSN;UID=;APP=2007 Microsoft Office system;WSID=VC0753- SERVER;DATABASE=ProjectServer_Published;Trusted_Connection=Yes 10/06/2009 09:19:47.344 Project Server 2007 url = http://vc0753-server/pwa 10/06/2009 09:19:47.344 Creating Project Server 2007 soap object... 10/06/2009 09:19:47.750 Creating Project Server 2007 resource soap object... 10/06/2009 09:19:47.797 Creating Project Server 2007 winproj soap object... 10/06/2009 09:19:47.984 Creating Project Server 2007 wssinterop soap object... 10/06/2009 09:19:48.000 Getting all Upgraded Projects from Project Server 2007 10/06/2009 09:19:48.000 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' 10/06/2009 09:19:48.016 preparing Query select WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from dbo.MSP_WEB_ADMIN 10/06/2009 09:19:48.016 Project Server 2007 Project Server version is 12,0,15,45181014 10/06/2009 09:19:48.016 Connecting to Project Server 2007 ... **********Phase:Tool initialization end********** 10/06/2009 09:21:25.516 Initializations succeeded, Starting migration **********Phase:Migration initialization start********** 10/06/2009 09:21:25.516 Policy to fix up project server security categories = true. 10/06/2009 09:21:25.516 Policy to never publish master projects = true. 10/06/2009 09:21:25.516 WARNING: Projects will be migrated even if they have multiple status managers for the same task. 10/06/2009 09:21:25.532 WARNING: Projects will be migrated even if they have pending status updates. 10/06/2009 09:21:25.860 Adding to run table 10/06/2009 09:21:25.860 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()) 10/06/2009 09:21:25.907 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()) 10/06/2009 09:21:25.923 Connecting to Project Server 2003 sql server project database 10/06/2009 09:21:25.923 Creating DSN: name = P11-PROJECT-SERVER-DSN, server = vc0753-server, db = ProjectServer, trusted = 1 10/06/2009 09:21:25.923 Created DSN P11-PROJECT-SERVER-DSN 10/06/2009 09:21:25.938 Connection string DSN=P11-PROJECT-SERVER- DSN;UID=;APP=2007 Microsoft Office system;WSID=VC0753- SERVER;DATABASE=ProjectServer;Trusted_Connection=Yes 10/06/2009 09:21:25.938 Connecting to the Project Server 2003 sql server web database 10/06/2009 09:21:25.938 Creating DSN: name = P11-PROJECT-SERVER-WEB- DSN, server = vc0753-server, db = ProjectServer, trusted = 1 10/06/2009 09:21:25.938 Created DSN P11-PROJECT-SERVER-WEB-DSN 10/06/2009 09:21:25.954 Connection string DSN=P11-PROJECT-SERVER-WEB- DSN;UID=;APP=2007 Microsoft Office system;WSID=VC0753- SERVER;DATABASE=ProjectServer;Trusted_Connection=Yes 10/06/2009 09:21:25.954 preparing Query select WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from dbo.MSP_WEB_ADMIN 10/06/2009 09:21:25.954 Project Server 2003 version is 11,2,15,20030816 10/06/2009 09:21:25.954 Time to execute CUpgrader::CheckP11Version (): 0 ms 10/06/2009 09:21:25.954 preparing Query select WADMIN_DEFAULT_LANGUAGE from dbo.MSP_WEB_ADMIN 10/06/2009 09:21:25.969 preparing Query select WADMIN_DEFAULT_LANGUAGE from MSP_WEB_ADMIN 10/06/2009 09:21:25.969 preparing Query select isnull(is_member(?), 0) 10/06/2009 09:21:25.969 preparing Query select isnull(is_member(?), 0) 10/06/2009 09:21:25.969 preparing Query select isnull(is_member(?), 0) 10/06/2009 09:21:25.969 preparing Query select isnull(is_member(?), 0) 10/06/2009 09:21:28.438 preparing Query select VERS_VERSION from dbo.MSP_VERSIONS where VERS_DEFAULT = 1 10/06/2009 09:21:28.501 Prescanning Project Server 2003 database for potential problems 10/06/2009 09:21:28.501 Looking for checked out projects... 10/06/2009 09:21:28.501 preparing Query select PROJ_NAME from dbo.MSP_PROJECTS where PROJ_CHECKEDOUT = 1 and PROJ_TYPE in (0, 1, 2, 3) 10/06/2009 09:21:28.563 Looking for externally modified projects... 10/06/2009 09:21:28.563 preparing Query select PROJ_NAME from dbo.MSP_PROJECTS where (PROJ_EXT_EDITED = 1 or RESERVED_BINARY_DATA is null) and PROJ_TYPE in (0, 1) 10/06/2009 09:21:29.923 Looking for duplicate enterprise resources... 10/06/2009 09:21:29.923 preparing Query select distinct r1.RES_NAME from dbo.MSP_RESOURCES r1 inner join dbo.MSP_RESOURCES r2 on (r1.RES_NAME = r2.RES_NAME and r1.PROJ_ID = r2.PROJ_ID) where r1.PROJ_ID = 1 and r1.RES_UID != r2.RES_UID order by r1.RES_NAME 10/06/2009 09:21:30.032 No potential problems found 10/06/2009 09:21:30.032 Updating run table 10/06/2009 09:21:30.032 preparing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ? 10/06/2009 09:21:30.032 Executing Query update dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE = GETDATE() where UPG_RUN_UID = ? 10/06/2009 09:21:30.063 Migration finished with return code 1 10/06/2009 09:21:30.063 Project migration successful. But when I try to run the migrationtool, it keeps looping/cycling on this P12ProjectUpgrader process: 10/06/2009 09:46:26.635 Log file Initialized 10/06/2009 09:46:26.635 Migration tool version is 12,0,4518,1014 10/06/2009 09:46:26.635 Configuration file is c:\migrationscripts \p12migration.ini 10/06/2009 09:46:26.698 Connecting to Project Server 2007 Draft db... 10/06/2009 09:46:26.698 Creating DSN: name = MSP-12-WORKING-DB-DSN, server = vc0753-server, db = ProjectServer_Draft, trusted = 1 10/06/2009 09:46:26.698 Created DSN MSP-12-WORKING-DB-DSN 10/06/2009 09:46:26.792 Connection string DSN=MSP-12-WORKING-DB- DSN;UID=;APP=2007 Microsoft Office system;WSID=VC0753- SERVER;DATABASE=ProjectServer_Draft;Trusted_Connection=Yes 10/06/2009 09:46:26.792 Connecting to Project Server 2007 published db... 10/06/2009 09:46:26.792 Creating DSN: name = MSP-12-PUBLISHED-DB- DSN, server = vc0753-server, db = ProjectServer_Published, trusted = 1 10/06/2009 09:46:26.807 Created DSN MSP-12-PUBLISHED-DB-DSN 10/06/2009 09:46:26.807 Connection string DSN=MSP-12-PUBLISHED-DB- DSN;UID=;APP=2007 Microsoft Office system;WSID=VC0753- SERVER;DATABASE=ProjectServer_Published;Trusted_Connection=Yes 10/06/2009 09:46:26.807 Project Server 2007 url = http://vc0753-server/pwa 10/06/2009 09:46:26.823 Creating Project Server 2007 soap object... 10/06/2009 09:46:26.917 Creating Project Server 2007 resource soap object... 10/06/2009 09:46:26.963 Creating Project Server 2007 winproj soap object... 10/06/2009 09:46:27.151 Creating Project Server 2007 wssinterop soap object... 10/06/2009 09:46:27.167 Getting all Upgraded Projects from Project Server 2007 10/06/2009 09:46:27.167 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' 10/06/2009 09:46:27.167 preparing Query select WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from dbo.MSP_WEB_ADMIN 10/06/2009 09:46:27.167 Project Server 2007 Project Server version is 12,0,15,45181014 10/06/2009 09:46:27.167 Connecting to Project Server 2007 ... **********Phase:Tool initialization end********** 10/06/2009 09:46:27.401 Initializations succeeded, Starting migration **********Phase:Migration initialization start********** 10/06/2009 09:46:27.401 Policy to fix up project server security categories = true. 10/06/2009 09:46:27.401 Policy to never publish master projects = true. 10/06/2009 09:46:27.401 WARNING: Projects will be migrated even if they have multiple status managers for the same task. 10/06/2009 09:46:27.401 WARNING: Projects will be migrated even if they have pending status updates. 10/06/2009 09:46:27.604 Adding to run table 10/06/2009 09:46:27.604 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()) 10/06/2009 09:46:27.604 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()) 10/06/2009 09:46:27.604 Connecting to Project Server 2003 sql server project database 10/06/2009 09:46:27.604 Creating DSN: name = P11-PROJECT-SERVER-DSN, server = vc0753-server, db = ProjectServer, trusted = 1 10/06/2009 09:46:27.604 Created DSN P11-PROJECT-SERVER-DSN 10/06/2009 09:46:27.620 Connection string DSN=P11-PROJECT-SERVER- DSN;UID=;APP=2007 Microsoft Office system;WSID=VC0753- SERVER;DATABASE=ProjectServer;Trusted_Connection=Yes 10/06/2009 09:46:27.620 Connecting to the Project Server 2003 sql server web database 10/06/2009 09:46:27.620 Creating DSN: name = P11-PROJECT-SERVER-WEB- DSN, server = vc0753-server, db = ProjectServer, trusted = 1 10/06/2009 09:46:27.635 Created DSN P11-PROJECT-SERVER-WEB-DSN 10/06/2009 09:46:27.682 Connection string DSN=P11-PROJECT-SERVER-WEB- DSN;UID=;APP=2007 Microsoft Office system;WSID=VC0753- SERVER;DATABASE=ProjectServer;Trusted_Connection=Yes 10/06/2009 09:46:27.682 preparing Query select WADMIN_VERSION_MAJOR, WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from dbo.MSP_WEB_ADMIN 10/06/2009 09:46:27.682 Project Server 2003 version is 11,2,15,20030816 10/06/2009 09:46:27.682 Time to execute CUpgrader::CheckP11Version (): 0 ms 10/06/2009 09:46:27.682 preparing Query select WADMIN_DEFAULT_LANGUAGE from dbo.MSP_WEB_ADMIN 10/06/2009 09:46:27.682 preparing Query select WADMIN_DEFAULT_LANGUAGE from MSP_WEB_ADMIN 10/06/2009 09:46:27.682 preparing Query select isnull(is_member(?), 0) 10/06/2009 09:46:27.682 preparing Query select isnull(is_member(?), 0) 10/06/2009 09:46:27.682 preparing Query select isnull(is_member(?), 0) 10/06/2009 09:46:27.682 preparing Query select isnull(is_member(?), 0) 10/06/2009 09:46:27.776 preparing Query select VERS_VERSION from dbo.MSP_VERSIONS where VERS_DEFAULT = 1 10/06/2009 09:46:27.792 preparing Query select UPG_PHASE_RUN_STATUS from dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND UPG_PHASE_RUN_STATUS = ? 10/06/2009 09:46:27.823 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ? 10/06/2009 09:46:27.854 preparing Query exec dbo.MSP_P12UPG_CreateAllViewsToProjectServer2003 ?, ? 10/06/2009 09:46:28.885 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ? 10/06/2009 09:46:28.885 PWA Migration: Setup Views to Project Server 2003 -- Success. 10/06/2009 09:46:28.885 Time to execute CUpgrader::UpgradePWASetupViews(): 1109 ms 10/06/2009 09:46:28.885 preparing Query select PROJ_ID, PROJ_NAME, PROJ_TYPE, PROJ_VERSION from dbo.MSP_PROJECTS order by PROJ_ID 10/06/2009 09:46:28.885 Adding project ID= 1 Name= resglobal Type=3 10/06/2009 09:46:28.885 Adding project ID= 3 Name= Administrative Time Type=1 10/06/2009 09:46:28.885 No version name specified 10/06/2009 09:46:28.885 Adding project ID= 25 Name= VACCO Standard Schedule Template Type=1 10/06/2009 09:46:28.885 No version name specified 10/06/2009 09:46:28.885 Adding project ID= 44 Name= A07-0044 JPL MSL Service Valves.Published Type=0 .......... 10/06/2009 09:46:28.901 Adding project ID= 493 Name= New Milestone Format.Published Type=0 10/06/2009 09:46:28.901 preparing Query select A.PROJ_ID, B.PROJ_NAME, A.TEXT_REF_UID, A.TEXT_FIELD_ID, A.TEXT_VALUE from dbo.MSP_TEXT_FIELDS A, dbo.MSP_PROJECTS B where A.PROJ_ID = B.PROJ_ID and (A.TEXT_FIELD_ID = 188743706 or A.TEXT_FIELD_ID = 239075346 or A.TEXT_FIELD_ID = 239075347) order by A.PROJ_ID 10/06/2009 09:46:29.213 Total Number of Projects to migrate 282 **********Phase:Migration initialization end********** **********Phase:Eglobal Migration start********** 10/06/2009 09:46:29.213 preparing Query select UPG_PHASE_RUN_STATUS from dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND UPG_PHASE_RUN_STATUS = ? 10/06/2009 09:46:29.213 Getting Project info from Project Server 2007 10/06/2009 09:46:29.213 preparing Query select PROJ_UID, PROJ_NAME, PROJ_TYPE from dbo.MSP_PROJECTS where PROJ_NAME = ? 10/06/2009 09:46:29.213 Could not get info for global20090408172047 in Project Server 2007 10/06/2009 09:46:29.213 preparing Query select PROJ_CHECKEDOUT from dbo.MSP_PROJECTS where PROJ_ID = ? 10/06/2009 09:46:29.213 Eglobal is not migrated. Starting migration of Eglobal 10/06/2009 09:46:29.213 preparing Query exec dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ? 10/06/2009 09:46:29.229 Starting upgrade of eglobal global20090408172047 10/06/2009 09:46:29.229 10/06/2009 09:46:29.229 Opening project from Project Server 2003... 10/06/2009 09:46:29.229 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 (?, 450, ?, ?, 3, ?, GETDATE()) 10/06/2009 09:46:29.229 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 (?, 450, ?, ?, 3, ?, GETDATE()) 10/06/2009 09:46:29.260 preparing Query exec dbo.MSP_P12UPG_DELETE_PROJECT_MAPPINGS ? 10/06/2009 09:46:32.963 Time to execute P12UpgradeDoc::OpenP11Project (): 3672 ms 10/06/2009 09:46:32.963 Executing Query update dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set UPG_PROJ_STATUS = 4, UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID = 450 10/06/2009 09:46:32.963 Successfully Opened from Project Server 2003 10/06/2009 09:46:33.010 Time to execute P12UpgradeDoc::FixUpLookupTableValueRowNumber(): 46 ms 10/06/2009 09:46:33.010 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 10/06/2009 09:46:33.042 preparing Query select max (MD_PROP_ID_SECONDARY) from dbo.MSP_CUSTOM_FIELDS 10/06/2009 09:46:33.135 Maximum existing enterprise assignment custom field pid = 255885314 10/06/2009 09:46:33.135 Time to execute P12UpgradeDoc::FixupEnterpriseCustomFields(): 125 ms 10/06/2009 09:46:33.135 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 10/06/2009 09:46:33.135 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.167 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.245 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.245 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.245 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.260 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.260 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.260 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.260 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.260 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.260 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.260 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.292 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.292 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.292 WARNING: Renamed Enterprise Task custom field Comments to Comments1 due to a Project Server 2007 reserved name conflict 10/06/2009 09:46:33.307 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.307 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.307 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.307 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.307 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.307 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.307 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.307 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.307 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.307 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.323 WARNING: Renamed Enterprise Project custom field Category to Category1 due to a Project Server 2007 reserved name conflict 10/06/2009 09:46:33.323 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.323 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.323 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.323 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.323 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND (MD_ENT_TYPE_UID = ? OR MD_ENT_TYPE_UID = ?) 10/06/2009 09:46:33.323 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.323 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND MD_ENT_TYPE_UID = ? 10/06/2009 09:46:33.323 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.323 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND MD_ENT_TYPE_UID = ? 10/06/2009 09:46:33.338 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.338 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND MD_ENT_TYPE_UID = ? 10/06/2009 09:46:33.338 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.338 preparing Query SELECT MD_PROP_NAME FROM dbo.MSP_CUSTOM_FIELDS WHERE MD_PROP_NAME = ? AND MD_ENT_TYPE_UID = ? 10/06/2009 09:46:33.338 preparing Query SELECT WC.CONV_STRING FROM dbo.MSP_WEB_VIEW_FIELDS VF INNER JOIN dbo.MSP_WEB_CONVERSIONS WC ON VF.WFIELD_NAME_CONV_VALUE = WC.CONV_VALUE WHERE WC.CONV_STRING = ? 10/06/2009 09:46:33.338 Time to execute P12UpgradeDoc::CheckEnterpriseCustomFieldNameConflicts(): 204 ms 10/06/2009 09:46:33.338 Time to execute P12UpgradeDoc::FixMessInfo (): 0 ms 10/06/2009 09:46:33.338 Saving to Project Server 2007 10/06/2009 09:46:34.463 Received serializer callback: 11 10/06/2009 09:46:34.463 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:46:37.776 Received serializer callback: 17 10/06/2009 09:46:37.776 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:46:39.338 Received serializer callback: 2 10/06/2009 09:46:39.338 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:46:39.463 Received serializer callback: 12 10/06/2009 09:46:39.463 Save Job was successfully submitted to queue 10/06/2009 09:46:39.463 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:46:39.526 Time to execute P12UpgradeDoc::SaveP12Project (): 6187 ms 10/06/2009 09:46:39.526 Time to execute P12UpgradeDoc::Upgrade(): 10297 ms 10/06/2009 09:46:39.854 Received serializer callback: 4 10/06/2009 09:46:39.854 Waiting for Job to be Processed. percentage complete: 0 10/06/2009 09:46:39.854 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:46:57.698 Received serializer callback: 18 10/06/2009 09:46:57.698 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:46:57.698 Received serializer callback: 21 10/06/2009 09:46:57.698 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:47:02.010 Received serializer callback: 4 10/06/2009 09:47:02.010 Waiting for Job to be Processed. percentage complete: 0 10/06/2009 09:47:02.010 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:47:24.214 Received serializer callback: 4 10/06/2009 09:47:24.214 Waiting for Job to be Processed. percentage complete: 0 10/06/2009 09:47:24.214 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:47:46.386 Received serializer callback: 4 10/06/2009 09:47:46.386 Waiting for Job to be Processed. percentage complete: 0 10/06/2009 09:47:46.386 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:48:08.573 Received serializer callback: 4 10/06/2009 09:48:08.573 Waiting for Job to be Processed. percentage complete: 0 10/06/2009 09:48:08.573 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:48:30.745 Received serializer callback: 4 10/06/2009 09:48:30.745 Waiting for Job to be Processed. percentage complete: 0 10/06/2009 09:48:30.745 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:48:52.933 Received serializer callback: 4 10/06/2009 09:48:52.933 Waiting for Job to be Processed. percentage complete: 0 10/06/2009 09:48:52.933 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms 10/06/2009 09:49:15.105 Received serializer callback: 4 10/06/2009 09:49:15.105 Waiting for Job to be Processed. percentage complete: 0 10/06/2009 09:49:15.105 Time to execute P12ProjectUpgrader::SerializerCallBack(): 0 ms I've let it run for 2 days and the log file just keeps looping on these 3 commands... Any help would be appreciated.
|
Pages: 1 Prev: Incorrect date in start/finish fields Next: Stop Light Formula |