M
Michael
anyone have any insight to this error message? I run the verify and it
says no potential problems found, Project migration successful. I run
without verify (the real migration), it fails, and this is what is in
the log:
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.424 preparing Query select isnull(is_member(?),
0)
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.
says no potential problems found, Project migration successful. I run
without verify (the real migration), it fails, and this is what is in
the log:
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.424 preparing Query select isnull(is_member(?),
0)
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.