Problem migrating data from project2k3server to project2k7server

S

Sean

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems migrating project2k3server data to project2k7server 0
Find then highlight in yellow 6
Migration Tool - Eglobal error message 3
PS2003 - PS2007 migration. One project will not migrate, all others fine. 6
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
Grouping query to elminate dups 2
Migration of ProjectServer2003 to ProjectServer2007 in single mach 7
Migration to PS2007 0

Top