A
ahelp
We are preparing to migrate from PS2003 to PS2007. In running the migration
tool with the -verify switch, I'm not getting very far--it's failing with an
invalid DSN error. Here is the log & ini file:
04/25/2007 11:33:27.005 Log file Initialized
04/25/2007 11:33:27.005 Migration tool version is 12,0,4518,1014
04/25/2007 11:33:27.005 Configuration file is C:\Program Files\Microsoft
Office\Office12\p12migration.ini
04/25/2007 11:33:27.067 Connecting to Project Server 2007 Draft db...
04/25/2007 11:33:27.067 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= hqsql2005dev01\dev01, db = ProjectServr_Draft, trusted = 1
04/25/2007 11:33:27.067 Created DSN MSP-12-WORKING-DB-DSN
04/25/2007 11:33:27.208 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=1FDY791;DATABASE=ProjectServr_Draft;Trusted_Connection=Yes
04/25/2007 11:33:27.208 Connecting to Project Server 2007 published db...
04/25/2007 11:33:27.208 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = hqsql2005dev01\dev01, db = ProjectServr_Published, trusted = 1
04/25/2007 11:33:27.208 Created DSN MSP-12-PUBLISHED-DB-DSN
04/25/2007 11:33:27.239 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=1FDY791;DATABASE=ProjectServr_Published;Trusted_Connection=Yes
04/25/2007 11:33:27.239 Project Server 2007 url =
http://hqepmdevweb01/projectserver
04/25/2007 11:33:27.239 Creating Project Server 2007 soap object...
04/25/2007 11:33:27.348 Creating Project Server 2007 resource soap object...
04/25/2007 11:33:27.379 Creating Project Server 2007 winproj soap object...
04/25/2007 11:33:27.550 Creating Project Server 2007 wssinterop soap
object...
04/25/2007 11:33:27.581 Getting all Upgraded Projects from Project Server
2007
04/25/2007 11:33:27.581 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'
04/25/2007 11:33:27.581 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
04/25/2007 11:33:27.581 Project Server 2007 Project Server version is
12,0,15,45181014
04/25/2007 11:33:27.581 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********
04/25/2007 11:33:28.547 Initializations succeeded, Starting migration
**********Phase:Migration initialization start**********
04/25/2007 11:33:28.547 Using a linked Project Server 2003 database.
04/25/2007 11:33:28.547 Policy to fix up project server security
categories = true.
04/25/2007 11:33:28.547 Policy to never publish master projects = true.
04/25/2007 11:33:28.547 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
04/25/2007 11:33:28.547 WARNING: Projects will be migrated even if they
have pending status updates.
04/25/2007 11:33:28.734 Adding to run table
04/25/2007 11:33:28.734 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())
04/25/2007 11:33:28.734 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())
04/25/2007 11:33:28.734 Connecting to Project Server 2003 sql server
project database
04/25/2007 11:33:28.734 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = hqsql65s2\dev07, db = Projectserver042207, trusted = 1
04/25/2007 11:33:28.734 Created DSN P11-PROJECT-SERVER-DSN
04/25/2007 11:33:44.621 Connecting to DSN DSN=P11-PROJECT-SERVER-DSN failed
04/25/2007 11:33:44.621 ConnectToSQLServer for Project Server 2003 project
database failed with status = 80004005
04/25/2007 11:33:44.621 ERROR: There was a problem connecting to the
Project Server 2003 project tables database. Please see the migration log for
more details.
04/25/2007 11:33:44.621 Updating run table
04/25/2007 11:33:44.621 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
04/25/2007 11:33:44.621 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
04/25/2007 11:33:44.637 Migration finished with return code 80004005
04/25/2007 11:33:44.637 Project migration failed.
04/25/2007 11:33:44.668 Error = Invalid DSN
04/25/2007 11:33:44.668 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
04/25/2007 11:33:44.668 Could not remove DSN P11-PROJECT-SERVER-WEB-DSN.
The ini file (with comments deleted) is:
[General]
LogFilePath=c:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=no
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes
[Project Names to Save]
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
Project2007PWAServer=http://hqepmdevweb01/projectserver
Project2007SQLServer=hqsql2005dev01\dev01
DraftDB=ProjectServr_Draft
PublishedDB=ProjectServr_Published
[Project Server 2003]
Project2003ProjectTablesDB=Projectserver042207
Project2003WebTablesDB=Projectserver042207
Project2003LinkedSQLServer=hqsql65s2\dev07
The 2003 db is on SQL 2000. I can connect to the Projectserver042207
database with Project & PWA & edit the DSN with Editsite. What might be going
on?
Thanks,
Mike
tool with the -verify switch, I'm not getting very far--it's failing with an
invalid DSN error. Here is the log & ini file:
04/25/2007 11:33:27.005 Log file Initialized
04/25/2007 11:33:27.005 Migration tool version is 12,0,4518,1014
04/25/2007 11:33:27.005 Configuration file is C:\Program Files\Microsoft
Office\Office12\p12migration.ini
04/25/2007 11:33:27.067 Connecting to Project Server 2007 Draft db...
04/25/2007 11:33:27.067 Creating DSN: name = MSP-12-WORKING-DB-DSN, server
= hqsql2005dev01\dev01, db = ProjectServr_Draft, trusted = 1
04/25/2007 11:33:27.067 Created DSN MSP-12-WORKING-DB-DSN
04/25/2007 11:33:27.208 Connection string
DSN=MSP-12-WORKING-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=1FDY791;DATABASE=ProjectServr_Draft;Trusted_Connection=Yes
04/25/2007 11:33:27.208 Connecting to Project Server 2007 published db...
04/25/2007 11:33:27.208 Creating DSN: name = MSP-12-PUBLISHED-DB-DSN,
server = hqsql2005dev01\dev01, db = ProjectServr_Published, trusted = 1
04/25/2007 11:33:27.208 Created DSN MSP-12-PUBLISHED-DB-DSN
04/25/2007 11:33:27.239 Connection string
DSN=MSP-12-PUBLISHED-DB-DSN;UID=;APP=2007 Microsoft Office
system;WSID=1FDY791;DATABASE=ProjectServr_Published;Trusted_Connection=Yes
04/25/2007 11:33:27.239 Project Server 2007 url =
http://hqepmdevweb01/projectserver
04/25/2007 11:33:27.239 Creating Project Server 2007 soap object...
04/25/2007 11:33:27.348 Creating Project Server 2007 resource soap object...
04/25/2007 11:33:27.379 Creating Project Server 2007 winproj soap object...
04/25/2007 11:33:27.550 Creating Project Server 2007 wssinterop soap
object...
04/25/2007 11:33:27.581 Getting all Upgraded Projects from Project Server
2007
04/25/2007 11:33:27.581 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'
04/25/2007 11:33:27.581 preparing Query select WADMIN_VERSION_MAJOR,
WADMIN_VERSION_MINOR, WADMIN_VERSION_REVISION, WADMIN_VERSION_BUILD from
dbo.MSP_WEB_ADMIN
04/25/2007 11:33:27.581 Project Server 2007 Project Server version is
12,0,15,45181014
04/25/2007 11:33:27.581 Connecting to Project Server 2007 ...
**********Phase:Tool initialization end**********
04/25/2007 11:33:28.547 Initializations succeeded, Starting migration
**********Phase:Migration initialization start**********
04/25/2007 11:33:28.547 Using a linked Project Server 2003 database.
04/25/2007 11:33:28.547 Policy to fix up project server security
categories = true.
04/25/2007 11:33:28.547 Policy to never publish master projects = true.
04/25/2007 11:33:28.547 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
04/25/2007 11:33:28.547 WARNING: Projects will be migrated even if they
have pending status updates.
04/25/2007 11:33:28.734 Adding to run table
04/25/2007 11:33:28.734 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())
04/25/2007 11:33:28.734 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())
04/25/2007 11:33:28.734 Connecting to Project Server 2003 sql server
project database
04/25/2007 11:33:28.734 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = hqsql65s2\dev07, db = Projectserver042207, trusted = 1
04/25/2007 11:33:28.734 Created DSN P11-PROJECT-SERVER-DSN
04/25/2007 11:33:44.621 Connecting to DSN DSN=P11-PROJECT-SERVER-DSN failed
04/25/2007 11:33:44.621 ConnectToSQLServer for Project Server 2003 project
database failed with status = 80004005
04/25/2007 11:33:44.621 ERROR: There was a problem connecting to the
Project Server 2003 project tables database. Please see the migration log for
more details.
04/25/2007 11:33:44.621 Updating run table
04/25/2007 11:33:44.621 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
04/25/2007 11:33:44.621 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
04/25/2007 11:33:44.637 Migration finished with return code 80004005
04/25/2007 11:33:44.637 Project migration failed.
04/25/2007 11:33:44.668 Error = Invalid DSN
04/25/2007 11:33:44.668 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
04/25/2007 11:33:44.668 Could not remove DSN P11-PROJECT-SERVER-WEB-DSN.
The ini file (with comments deleted) is:
[General]
LogFilePath=c:\ProjectServer2007Migration
LogFileNamePrefix=Batch1
MigrateAll=
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=no
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes
[Project Names to Save]
[Project Names to Save and Publish]
[Excluded Project Names]
[Project Server 2007]
Project2007PWAServer=http://hqepmdevweb01/projectserver
Project2007SQLServer=hqsql2005dev01\dev01
DraftDB=ProjectServr_Draft
PublishedDB=ProjectServr_Published
[Project Server 2003]
Project2003ProjectTablesDB=Projectserver042207
Project2003WebTablesDB=Projectserver042207
Project2003LinkedSQLServer=hqsql65s2\dev07
The 2003 db is on SQL 2000. I can connect to the Projectserver042207
database with Project & PWA & edit the DSN with Editsite. What might be going
on?
Thanks,
Mike