Migration Tool - Eglobal error message

S

scout12000

Does anyone have any ideas what this may be and how to fix it?

My migration tool version is 12,0,6341,5000

**********Phase:Eglobal Migration start**********
04/24/2009 10:02:29.693 preparing Query select UPG_PHASE_RUN_STATUS from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
04/24/2009 10:02:29.693 Getting Project info from Project Server 2007
04/24/2009 10:02:29.693 preparing Query select PROJ_UID, PROJ_NAME,
PROJ_TYPE from dbo.MSP_PROJECTS where PROJ_NAME = ?
04/24/2009 10:02:29.693 Could not get info for global20090422160215 in
Project Server 2007
04/24/2009 10:02:29.693 preparing Query select PROJ_CHECKEDOUT from
dbo.MSP_PROJECTS where PROJ_ID = ?
04/24/2009 10:02:29.709 Eglobal is not migrated. Starting migration of
Eglobal
04/24/2009 10:02:29.709 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
04/24/2009 10:02:29.740 Starting upgrade of eglobal global20090422160215
04/24/2009 10:02:29.740
04/24/2009 10:02:29.755 Opening project from Project Server 2003...
04/24/2009 10:02:29.755 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 (?, 1915, ?, ?, 3, ?, GETDATE())
04/24/2009 10:02:29.755 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 (?, 1915, ?, ?, 3, ?, GETDATE())
04/24/2009 10:02:29.771 preparing Query exec
dbo.MSP_P12UPG_DELETE_PROJECT_MAPPINGS ?
04/24/2009 10:02:43.475 Time to execute P12UpgradeDoc::OpenP11Project():
13687 ms
04/24/2009 10:02:43.475 Executing Query update
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set UPG_PROJ_STATUS = 4,
UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID = 1915
04/24/2009 10:02:43.475 Successfully Opened from Project Server 2003
04/24/2009 10:02:43.741 Time to execute
P12UpgradeDoc::FixUpLookupTableValueRowNumber(): 266 ms
04/24/2009 10:02:43.741 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
04/24/2009 10:02:43.756 preparing Query select max(MD_PROP_ID_SECONDARY)
from dbo.MSP_CUSTOM_FIELDS
04/24/2009 10:02:43.772 Maximum existing enterprise assignment custom
field pid = 255885314
04/24/2009 10:02:43.772 preparing Query select distinct TEXT_VALUE from
dbo.MSP_TEXT_FIELDS where (TEXT_FIELD_ID = ? OR TEXT_FIELD_ID = ?) AND
TEXT_VALUE IS NOT NULL
04/24/2009 10:02:43.772 Executing query failed with -1
04/24/2009 10:02:43.772 Cmd failed retcode= -1
04/24/2009 10:02:43.772 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server
Driver][SQL Server]The text data type cannot be selected as DISTINCT because
it is not comparable.
04/24/2009 10:02:43.772 cmd.Execute failed with status hr = 80004005
04/24/2009 10:02:43.772 g_p11Comm.GetDistinctTextCustomFieldValues failed
with 80004005
04/24/2009 10:02:43.772 Time to execute
P12UpgradeDoc::FixupEnterpriseCustomFields(): 31 ms
04/24/2009 10:02:43.772 FixupEnterpriseCustomFields failed with 80004005
04/24/2009 10:02:43.772 Time to execute P12UpgradeDoc::Upgrade(): 14015 ms
04/24/2009 10:02:43.772 Migration failed for project global20090422160215
04/24/2009 10:02:43.834 Time to execute P12ProjectUpgrader::Upgrade():
14094 ms
04/24/2009 10:02:43.834 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
04/24/2009 10:02:43.834 Ent global migration failed with error 80004005
**********Phase:Eglobal Migration end**********
 
G

Gary L. Chefetz

Scout:

I am not entirely certain, but it looks like it failed authentication. Were
you using an account with full administrative access to the system?

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


scout12000 said:
Does anyone have any ideas what this may be and how to fix it?

My migration tool version is 12,0,6341,5000

**********Phase:Eglobal Migration start**********
04/24/2009 10:02:29.693 preparing Query select UPG_PHASE_RUN_STATUS from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
04/24/2009 10:02:29.693 Getting Project info from Project Server 2007
04/24/2009 10:02:29.693 preparing Query select PROJ_UID, PROJ_NAME,
PROJ_TYPE from dbo.MSP_PROJECTS where PROJ_NAME = ?
04/24/2009 10:02:29.693 Could not get info for global20090422160215 in
Project Server 2007
04/24/2009 10:02:29.693 preparing Query select PROJ_CHECKEDOUT from
dbo.MSP_PROJECTS where PROJ_ID = ?
04/24/2009 10:02:29.709 Eglobal is not migrated. Starting migration of
Eglobal
04/24/2009 10:02:29.709 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
04/24/2009 10:02:29.740 Starting upgrade of eglobal global20090422160215
04/24/2009 10:02:29.740
04/24/2009 10:02:29.755 Opening project from Project Server 2003...
04/24/2009 10:02:29.755 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 (?, 1915, ?, ?, 3, ?, GETDATE())
04/24/2009 10:02:29.755 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 (?, 1915, ?, ?, 3, ?, GETDATE())
04/24/2009 10:02:29.771 preparing Query exec
dbo.MSP_P12UPG_DELETE_PROJECT_MAPPINGS ?
04/24/2009 10:02:43.475 Time to execute P12UpgradeDoc::OpenP11Project():
13687 ms
04/24/2009 10:02:43.475 Executing Query update
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set UPG_PROJ_STATUS = 4,
UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID = 1915
04/24/2009 10:02:43.475 Successfully Opened from Project Server 2003
04/24/2009 10:02:43.741 Time to execute
P12UpgradeDoc::FixUpLookupTableValueRowNumber(): 266 ms
04/24/2009 10:02:43.741 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
04/24/2009 10:02:43.756 preparing Query select max(MD_PROP_ID_SECONDARY)
from dbo.MSP_CUSTOM_FIELDS
04/24/2009 10:02:43.772 Maximum existing enterprise assignment custom
field pid = 255885314
04/24/2009 10:02:43.772 preparing Query select distinct TEXT_VALUE from
dbo.MSP_TEXT_FIELDS where (TEXT_FIELD_ID = ? OR TEXT_FIELD_ID = ?) AND
TEXT_VALUE IS NOT NULL
04/24/2009 10:02:43.772 Executing query failed with -1
04/24/2009 10:02:43.772 Cmd failed retcode= -1
04/24/2009 10:02:43.772 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server
Driver][SQL Server]The text data type cannot be selected as DISTINCT
because
it is not comparable.
04/24/2009 10:02:43.772 cmd.Execute failed with status hr = 80004005
04/24/2009 10:02:43.772 g_p11Comm.GetDistinctTextCustomFieldValues
failed
with 80004005
04/24/2009 10:02:43.772 Time to execute
P12UpgradeDoc::FixupEnterpriseCustomFields(): 31 ms
04/24/2009 10:02:43.772 FixupEnterpriseCustomFields failed with 80004005
04/24/2009 10:02:43.772 Time to execute P12UpgradeDoc::Upgrade(): 14015
ms
04/24/2009 10:02:43.772 Migration failed for project
global20090422160215
04/24/2009 10:02:43.834 Time to execute P12ProjectUpgrader::Upgrade():
14094 ms
04/24/2009 10:02:43.834 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
04/24/2009 10:02:43.834 Ent global migration failed with error 80004005
**********Phase:Eglobal Migration end**********
Click to expand...
 
S

scout12000

Gary,
Where it fails is here:

g_p11Comm.GetDistinctTextCustomFieldValues failed with 80004005
FixupEnterpriseCustomFields failed with 80004005

The question is which Custom Field is triggering this error?

Basically I'm stuck since migrating the Enteprise Global is the first step
that needs to happen to perform the migration.



Gary L. Chefetz said:
Scout:

I am not entirely certain, but it looks like it failed authentication. Were
you using an account with full administrative access to the system?

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


scout12000 said:
Does anyone have any ideas what this may be and how to fix it?

My migration tool version is 12,0,6341,5000

**********Phase:Eglobal Migration start**********
04/24/2009 10:02:29.693 preparing Query select UPG_PHASE_RUN_STATUS from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
04/24/2009 10:02:29.693 Getting Project info from Project Server 2007
04/24/2009 10:02:29.693 preparing Query select PROJ_UID, PROJ_NAME,
PROJ_TYPE from dbo.MSP_PROJECTS where PROJ_NAME = ?
04/24/2009 10:02:29.693 Could not get info for global20090422160215 in
Project Server 2007
04/24/2009 10:02:29.693 preparing Query select PROJ_CHECKEDOUT from
dbo.MSP_PROJECTS where PROJ_ID = ?
04/24/2009 10:02:29.709 Eglobal is not migrated. Starting migration of
Eglobal
04/24/2009 10:02:29.709 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
04/24/2009 10:02:29.740 Starting upgrade of eglobal global20090422160215
04/24/2009 10:02:29.740
04/24/2009 10:02:29.755 Opening project from Project Server 2003...
04/24/2009 10:02:29.755 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 (?, 1915, ?, ?, 3, ?, GETDATE())
04/24/2009 10:02:29.755 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 (?, 1915, ?, ?, 3, ?, GETDATE())
04/24/2009 10:02:29.771 preparing Query exec
dbo.MSP_P12UPG_DELETE_PROJECT_MAPPINGS ?
04/24/2009 10:02:43.475 Time to execute P12UpgradeDoc::OpenP11Project():
13687 ms
04/24/2009 10:02:43.475 Executing Query update
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set UPG_PROJ_STATUS = 4,
UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID = 1915
04/24/2009 10:02:43.475 Successfully Opened from Project Server 2003
04/24/2009 10:02:43.741 Time to execute
P12UpgradeDoc::FixUpLookupTableValueRowNumber(): 266 ms
04/24/2009 10:02:43.741 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
04/24/2009 10:02:43.756 preparing Query select max(MD_PROP_ID_SECONDARY)
from dbo.MSP_CUSTOM_FIELDS
04/24/2009 10:02:43.772 Maximum existing enterprise assignment custom
field pid = 255885314
04/24/2009 10:02:43.772 preparing Query select distinct TEXT_VALUE from
dbo.MSP_TEXT_FIELDS where (TEXT_FIELD_ID = ? OR TEXT_FIELD_ID = ?) AND
TEXT_VALUE IS NOT NULL
04/24/2009 10:02:43.772 Executing query failed with -1
04/24/2009 10:02:43.772 Cmd failed retcode= -1
04/24/2009 10:02:43.772 Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server
Driver][SQL Server]The text data type cannot be selected as DISTINCT
because
it is not comparable.
04/24/2009 10:02:43.772 cmd.Execute failed with status hr = 80004005
04/24/2009 10:02:43.772 g_p11Comm.GetDistinctTextCustomFieldValues
failed
with 80004005
04/24/2009 10:02:43.772 Time to execute
P12UpgradeDoc::FixupEnterpriseCustomFields(): 31 ms
04/24/2009 10:02:43.772 FixupEnterpriseCustomFields failed with 80004005
04/24/2009 10:02:43.772 Time to execute P12UpgradeDoc::Upgrade(): 14015
ms
04/24/2009 10:02:43.772 Migration failed for project
global20090422160215
04/24/2009 10:02:43.834 Time to execute P12ProjectUpgrader::Upgrade():
14094 ms
04/24/2009 10:02:43.834 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
04/24/2009 10:02:43.834 Ent global migration failed with error 80004005
**********Phase:Eglobal Migration end**********
Click to expand...
Click to expand...
 
G

Gary L. Chefetz

Yes, and that error most often indicates an authentication failure. I'm
sorry that I can't help you more, but this is something not easily diagnosed
via news group.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


scout12000 said:
Gary,
Where it fails is here:

g_p11Comm.GetDistinctTextCustomFieldValues failed with 80004005
FixupEnterpriseCustomFields failed with 80004005

The question is which Custom Field is triggering this error?

Basically I'm stuck since migrating the Enteprise Global is the first step
that needs to happen to perform the migration.



Gary L. Chefetz said:
Scout:

I am not entirely certain, but it looks like it failed authentication.
Were
you using an account with full administrative access to the system?

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


scout12000 said:
Does anyone have any ideas what this may be and how to fix it?

My migration tool version is 12,0,6341,5000

**********Phase:Eglobal Migration start**********
04/24/2009 10:02:29.693 preparing Query select UPG_PHASE_RUN_STATUS
from
dbo.MSP_P12UPGRADE_UPGRADE_RUN_PHASES where UPG_PHASE_UID=? AND
UPG_PHASE_RUN_STATUS = ?
04/24/2009 10:02:29.693 Getting Project info from Project Server 2007
04/24/2009 10:02:29.693 preparing Query select PROJ_UID, PROJ_NAME,
PROJ_TYPE from dbo.MSP_PROJECTS where PROJ_NAME = ?
04/24/2009 10:02:29.693 Could not get info for global20090422160215
in
Project Server 2007
04/24/2009 10:02:29.693 preparing Query select PROJ_CHECKEDOUT from
dbo.MSP_PROJECTS where PROJ_ID = ?
04/24/2009 10:02:29.709 Eglobal is not migrated. Starting migration
of
Eglobal
04/24/2009 10:02:29.709 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
04/24/2009 10:02:29.740 Starting upgrade of eglobal
global20090422160215
04/24/2009 10:02:29.740
04/24/2009 10:02:29.755 Opening project from Project Server 2003...
04/24/2009 10:02:29.755 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 (?, 1915, ?, ?, 3, ?, GETDATE())
04/24/2009 10:02:29.755 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 (?, 1915, ?, ?, 3, ?, GETDATE())
04/24/2009 10:02:29.771 preparing Query exec
dbo.MSP_P12UPG_DELETE_PROJECT_MAPPINGS ?
04/24/2009 10:02:43.475 Time to execute
P12UpgradeDoc::OpenP11Project():
13687 ms
04/24/2009 10:02:43.475 Executing Query update
dbo.MSP_P12UPGRADE_PROJECT_UPGRADES set UPG_PROJ_STATUS = 4,
UPG_PROJ_FINISH_DATE = GETDATE() where UPG_PROJ_P11_ID = 1915
04/24/2009 10:02:43.475 Successfully Opened from Project Server 2003
04/24/2009 10:02:43.741 Time to execute
P12UpgradeDoc::FixUpLookupTableValueRowNumber(): 266 ms
04/24/2009 10:02:43.741 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
04/24/2009 10:02:43.756 preparing Query select
max(MD_PROP_ID_SECONDARY)
from dbo.MSP_CUSTOM_FIELDS
04/24/2009 10:02:43.772 Maximum existing enterprise assignment custom
field pid = 255885314
04/24/2009 10:02:43.772 preparing Query select distinct TEXT_VALUE
from
dbo.MSP_TEXT_FIELDS where (TEXT_FIELD_ID = ? OR TEXT_FIELD_ID = ?) AND
TEXT_VALUE IS NOT NULL
04/24/2009 10:02:43.772 Executing query failed with -1
04/24/2009 10:02:43.772 Cmd failed retcode= -1
04/24/2009 10:02:43.772 Err1 = 37000 Err2 = [Microsoft][ODBC SQL
Server
Driver][SQL Server]The text data type cannot be selected as DISTINCT
because
it is not comparable.
04/24/2009 10:02:43.772 cmd.Execute failed with status hr = 80004005
04/24/2009 10:02:43.772 g_p11Comm.GetDistinctTextCustomFieldValues
failed
with 80004005
04/24/2009 10:02:43.772 Time to execute
P12UpgradeDoc::FixupEnterpriseCustomFields(): 31 ms
04/24/2009 10:02:43.772 FixupEnterpriseCustomFields failed with
80004005
04/24/2009 10:02:43.772 Time to execute P12UpgradeDoc::Upgrade():
14015
ms
04/24/2009 10:02:43.772 Migration failed for project
global20090422160215
04/24/2009 10:02:43.834 Time to execute
P12ProjectUpgrader::Upgrade():
14094 ms
04/24/2009 10:02:43.834 preparing Query exec
dbo.MSP_P12UPG_INSERT_OR_UPDATE_RUN_PHASE_STATUS ?, ?, ?
04/24/2009 10:02:43.834 Ent global migration failed with error
80004005
**********Phase:Eglobal Migration end**********
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

PS2003 - PS2007 migration. One project will not migrate, all others fine. 6
Migration tool fails to migrate project without throwing any error 2
Problem migrating data from project2k3server to project2k7server 0
Migration to 2007 error 2
migration tool errors 3
Migration of ProjectServer2003 to ProjectServer2007 in single mach 7
Migration to PS2007 0
problems migrating project2k3server data to project2k7server 0

Top