migration tool errors

J

Jennpenn07

Hi, I am trying to us the migration tool with the -verify option before
migrating PS2003 to PS2007. The ps2003 is on a separate box and the PS2007 DB
is on a VM. I created the linked SQL server from 2007 to 2003 and the PS2007
service account has read permissions to the 2003 DB and DBO rights to 2007
(as recommended in the MS migration guide).

When i run the migration tool with the verify option, it fails when trying
to connect to the 2003 database. See below for log file and .ini file
details. Any help would be greatly appreciated.

Here is the content from the log file:
**********Phase:Migration initialization start**********
01/28/2009 14:55:28.678 Using a linked Project Server 2003 database.
01/28/2009 14:55:28.678 Policy to fix up project server security
categories = true.
01/28/2009 14:55:28.678 Policy to never publish master projects = true.
01/28/2009 14:55:28.678 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
01/28/2009 14:55:28.990 Adding to run table
01/28/2009 14:55:28.990 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())
01/28/2009 14:55:29.022 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())
01/28/2009 14:55:29.053 Connecting to Project Server 2003 sql server
project database
01/28/2009 14:55:29.053 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = PS2003DB\ins1, db = ProjectServer, trusted = 1
01/28/2009 14:55:29.053 Created DSN P11-PROJECT-SERVER-DSN
01/28/2009 14:55:29.068 Connecting to DSN DSN=P11-PROJECT-SERVER-DSN failed
01/28/2009 14:55:29.068 ConnectToSQLServer for Project Server 2003 project
database failed with status = 80004005
01/28/2009 14:55:29.068 ERROR: There was a problem connecting to the
Project Server 2003 project tables database. Please see the migration log for
more details.
01/28/2009 14:55:29.068 Updating run table
01/28/2009 14:55:29.068 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
01/28/2009 14:55:29.068 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?, UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
01/28/2009 14:55:29.115 Migration finished with return code 80004005
01/28/2009 14:55:29.115 Project migration failed.
01/28/2009 14:55:29.178 Error = Invalid DSN
01/28/2009 14:55:29.178 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
01/28/2009 14:55:29.178 Could not remove DSN P11-PROJECT-SERVER-WEB-DSN.

Here's the content of the ini file im using
[General]
LogFilePath=c:\PS2007Migration
LogFileNamePrefix=Batch1
;MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes

[Project Names to Save]
;Project1.published
;Project2.Target

[Project Names to Save and Publish]
;Project3.Published
;Project4.Published

[Excluded Project Names]
;Project5.published
;Project6.Target

[Project Server 2007]
Project2007PWAServer=http://2007apwbServer/pwa
Project2007SQLServer=2007DBserver\projserv
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published

[Project Server 2003]
Project2003ProjectTablesDB=ProjectServer
Project2003WebTablesDB=ProjectServer
Project2003LinkedSQLServer=PS2003DB\ins1
 
C

Christophe Fiessinger [MSFT]

Sounds like a connection error, check the DSN using a test UDL.

--
Christophe Fiessinger
Microsoft
http://blogs.msdn.com/chrisfie

Jennpenn07 said:
Hi, I am trying to us the migration tool with the -verify option before
migrating PS2003 to PS2007. The ps2003 is on a separate box and the PS2007
DB
is on a VM. I created the linked SQL server from 2007 to 2003 and the
PS2007
service account has read permissions to the 2003 DB and DBO rights to 2007
(as recommended in the MS migration guide).

When i run the migration tool with the verify option, it fails when trying
to connect to the 2003 database. See below for log file and .ini file
details. Any help would be greatly appreciated.

Here is the content from the log file:
**********Phase:Migration initialization start**********
01/28/2009 14:55:28.678 Using a linked Project Server 2003 database.
01/28/2009 14:55:28.678 Policy to fix up project server security
categories = true.
01/28/2009 14:55:28.678 Policy to never publish master projects = true.
01/28/2009 14:55:28.678 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
01/28/2009 14:55:28.990 Adding to run table
01/28/2009 14:55:28.990 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())
01/28/2009 14:55:29.022 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())
01/28/2009 14:55:29.053 Connecting to Project Server 2003 sql server
project database
01/28/2009 14:55:29.053 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = PS2003DB\ins1, db = ProjectServer, trusted = 1
01/28/2009 14:55:29.053 Created DSN P11-PROJECT-SERVER-DSN
01/28/2009 14:55:29.068 Connecting to DSN DSN=P11-PROJECT-SERVER-DSN
failed
01/28/2009 14:55:29.068 ConnectToSQLServer for Project Server 2003
project
database failed with status = 80004005
01/28/2009 14:55:29.068 ERROR: There was a problem connecting to the
Project Server 2003 project tables database. Please see the migration log
for
more details.
01/28/2009 14:55:29.068 Updating run table
01/28/2009 14:55:29.068 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?,
UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
01/28/2009 14:55:29.068 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?,
UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
01/28/2009 14:55:29.115 Migration finished with return code 80004005
01/28/2009 14:55:29.115 Project migration failed.
01/28/2009 14:55:29.178 Error = Invalid DSN
01/28/2009 14:55:29.178 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
01/28/2009 14:55:29.178 Could not remove DSN P11-PROJECT-SERVER-WEB-DSN.

Here's the content of the ini file im using
[General]
LogFilePath=c:\PS2007Migration
LogFileNamePrefix=Batch1
;MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes

[Project Names to Save]
;Project1.published
;Project2.Target

[Project Names to Save and Publish]
;Project3.Published
;Project4.Published

[Excluded Project Names]
;Project5.published
;Project6.Target

[Project Server 2007]
Project2007PWAServer=http://2007apwbServer/pwa
Project2007SQLServer=2007DBserver\projserv
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published

[Project Server 2003]
Project2003ProjectTablesDB=ProjectServer
Project2003WebTablesDB=ProjectServer
Project2003LinkedSQLServer=PS2003DB\ins1
Click to expand...
 
J

Jennpenn07

Thanks for the tip, however i am not sure what how to do this. Would you mind
explaining further? Thanks

Christophe Fiessinger said:
Sounds like a connection error, check the DSN using a test UDL.

--
Christophe Fiessinger
Microsoft
http://blogs.msdn.com/chrisfie

Jennpenn07 said:
Hi, I am trying to us the migration tool with the -verify option before
migrating PS2003 to PS2007. The ps2003 is on a separate box and the PS2007
DB
is on a VM. I created the linked SQL server from 2007 to 2003 and the
PS2007
service account has read permissions to the 2003 DB and DBO rights to 2007
(as recommended in the MS migration guide).

When i run the migration tool with the verify option, it fails when trying
to connect to the 2003 database. See below for log file and .ini file
details. Any help would be greatly appreciated.

Here is the content from the log file:
**********Phase:Migration initialization start**********
01/28/2009 14:55:28.678 Using a linked Project Server 2003 database.
01/28/2009 14:55:28.678 Policy to fix up project server security
categories = true.
01/28/2009 14:55:28.678 Policy to never publish master projects = true.
01/28/2009 14:55:28.678 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
01/28/2009 14:55:28.990 Adding to run table
01/28/2009 14:55:28.990 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())
01/28/2009 14:55:29.022 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())
01/28/2009 14:55:29.053 Connecting to Project Server 2003 sql server
project database
01/28/2009 14:55:29.053 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = PS2003DB\ins1, db = ProjectServer, trusted = 1
01/28/2009 14:55:29.053 Created DSN P11-PROJECT-SERVER-DSN
01/28/2009 14:55:29.068 Connecting to DSN DSN=P11-PROJECT-SERVER-DSN
failed
01/28/2009 14:55:29.068 ConnectToSQLServer for Project Server 2003
project
database failed with status = 80004005
01/28/2009 14:55:29.068 ERROR: There was a problem connecting to the
Project Server 2003 project tables database. Please see the migration log
for
more details.
01/28/2009 14:55:29.068 Updating run table
01/28/2009 14:55:29.068 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?,
UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
01/28/2009 14:55:29.068 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?,
UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
01/28/2009 14:55:29.115 Migration finished with return code 80004005
01/28/2009 14:55:29.115 Project migration failed.
01/28/2009 14:55:29.178 Error = Invalid DSN
01/28/2009 14:55:29.178 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
01/28/2009 14:55:29.178 Could not remove DSN P11-PROJECT-SERVER-WEB-DSN.

Here's the content of the ini file im using
[General]
LogFilePath=c:\PS2007Migration
LogFileNamePrefix=Batch1
;MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes

[Project Names to Save]
;Project1.published
;Project2.Target

[Project Names to Save and Publish]
;Project3.Published
;Project4.Published

[Excluded Project Names]
;Project5.published
;Project6.Target

[Project Server 2007]
Project2007PWAServer=http://2007apwbServer/pwa
Project2007SQLServer=2007DBserver\projserv
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published

[Project Server 2003]
Project2003ProjectTablesDB=ProjectServer
Project2003WebTablesDB=ProjectServer
Project2003LinkedSQLServer=PS2003DB\ins1
Click to expand...
Click to expand...
 
J

Jennpenn07

I figured out my problem. This was a simple permission problem. I didnt have
read permissions set up for the service account on the 2003 sql box. the
account could only read from the linked sql server that was set up on the SQL
2007 box. So, whats the purpose of the linked server then?

Jennpenn07 said:
Thanks for the tip, however i am not sure what how to do this. Would you mind
explaining further? Thanks

Christophe Fiessinger said:
Sounds like a connection error, check the DSN using a test UDL.

--
Christophe Fiessinger
Microsoft
http://blogs.msdn.com/chrisfie

Jennpenn07 said:
Hi, I am trying to us the migration tool with the -verify option before
migrating PS2003 to PS2007. The ps2003 is on a separate box and the PS2007
DB
is on a VM. I created the linked SQL server from 2007 to 2003 and the
PS2007
service account has read permissions to the 2003 DB and DBO rights to 2007
(as recommended in the MS migration guide).

When i run the migration tool with the verify option, it fails when trying
to connect to the 2003 database. See below for log file and .ini file
details. Any help would be greatly appreciated.

Here is the content from the log file:
**********Phase:Migration initialization start**********
01/28/2009 14:55:28.678 Using a linked Project Server 2003 database.
01/28/2009 14:55:28.678 Policy to fix up project server security
categories = true.
01/28/2009 14:55:28.678 Policy to never publish master projects = true.
01/28/2009 14:55:28.678 WARNING: Projects will be migrated even if they
have multiple status managers for the same task.
01/28/2009 14:55:28.990 Adding to run table
01/28/2009 14:55:28.990 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())
01/28/2009 14:55:29.022 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())
01/28/2009 14:55:29.053 Connecting to Project Server 2003 sql server
project database
01/28/2009 14:55:29.053 Creating DSN: name = P11-PROJECT-SERVER-DSN,
server = PS2003DB\ins1, db = ProjectServer, trusted = 1
01/28/2009 14:55:29.053 Created DSN P11-PROJECT-SERVER-DSN
01/28/2009 14:55:29.068 Connecting to DSN DSN=P11-PROJECT-SERVER-DSN
failed
01/28/2009 14:55:29.068 ConnectToSQLServer for Project Server 2003
project
database failed with status = 80004005
01/28/2009 14:55:29.068 ERROR: There was a problem connecting to the
Project Server 2003 project tables database. Please see the migration log
for
more details.
01/28/2009 14:55:29.068 Updating run table
01/28/2009 14:55:29.068 preparing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?,
UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
01/28/2009 14:55:29.068 Executing Query update
dbo.MSP_P12UPGRADE_UPGRADE_RUNS SET UPG_RUN_STATUS = ?,
UPG_RUN_FINISH_DATE =
GETDATE() where UPG_RUN_UID = ?
01/28/2009 14:55:29.115 Migration finished with return code 80004005
01/28/2009 14:55:29.115 Project migration failed.
01/28/2009 14:55:29.178 Error = Invalid DSN
01/28/2009 14:55:29.178 Error = Driver's ConfigDSN, ConfigDriver, or
ConfigTranslator failed
01/28/2009 14:55:29.178 Could not remove DSN P11-PROJECT-SERVER-WEB-DSN.

Here's the content of the ini file im using
[General]
LogFilePath=c:\PS2007Migration
LogFileNamePrefix=Batch1
;MigrateAll=Publish
FixUpSecurityCategories=yes
StopProjectMigrationIfStatusUpdatesPending=yes
NeverPublishMasterProjects=yes
ResetStatusManagerToOwnerOnConflict=yes

[Project Names to Save]
;Project1.published
;Project2.Target

[Project Names to Save and Publish]
;Project3.Published
;Project4.Published

[Excluded Project Names]
;Project5.published
;Project6.Target

[Project Server 2007]
Project2007PWAServer=http://2007apwbServer/pwa
Project2007SQLServer=2007DBserver\projserv
DraftDB=ProjectServer_Draft
PublishedDB=ProjectServer_Published

[Project Server 2003]
Project2003ProjectTablesDB=ProjectServer
Project2003WebTablesDB=ProjectServer
Project2003LinkedSQLServer=PS2003DB\ins1
Click to expand...
Click to expand...
Click to expand...
 

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

Migration of ProjectServer2003 to ProjectServer2007 in single mach 7
Problem migrating data from project2k3server to project2k7server 0
Migration to 2007 error 2
PS2003 - PS2007 migration. One project will not migrate, all others fine. 6
2007 Migration - Invalid DSN 1
Migration Tool - Eglobal error message 3
migration fails 0
Migration of ProjectServer2003 to ProjectServer2007 in single mach 1

Top