"Error encountered while running UPGDF11.SQL!" error message when you run the Upg10db.cmd script to upgrade a Microsoft Project Server 2002 database (884455)


The information in this article applies to:

  • Microsoft Office Project Server 2003
  • Microsoft Project Server 2002

SYMPTOMS

When you run the Upg10db.cmd script to upgrade the Microsoft Project Server 2002 database to use with Microsoft Office Project Server 2003, you receive the following error message:
Error encountered while running UPGDF11.SQL!

CAUSE

This issue occurs in situations when the Upgdf11.sql script tries to insert values to the MSP_WEB_VIEW_REPORTS_FIELDS table of the ProjectServer database in Microsoft SQL Server 2000 and the values already exist in the table. The following INSERT statement in the Upgdf11.sql script file performs the operation:

insert into MSP_WEB_VIEW_REPORTS_FIELDS (WVIEW_ID,WFIELD_ID,WVIEW_FIELD_ORDER) values (51,6006, 9)

RESOLUTION

To resolve this problem, remove the Active field from the list of displayed fields in the Resources Summary view in Microsoft Project Web Access 2002. To do this, follow these steps.

Important We recommend that you back up the Microsoft Project Server 2002 database before you migrate or upgrade the database. Make sure that you have a backup copy of the database.

Follow these steps on the original Microsoft Project Server 2002 database and not on the database where the upgrade operation was not completed successfully. That is, before you follow these steps, restore the original database from your backup copy, and then connect it to Microsoft Project Server 2002.
  1. Log on to Microsoft Project Web Access 2002 as an administrator.
  2. Click Admin, and then click Manage views on the Administration overview page.
  3. Under Resource Center in the View Name column, click Resources Summary, and then click Modify View.
  4. In the Displayed fields box under Fields: Select the fields you want displayed in the view, click Active, and then click Remove.
  5. Click Save Changes, and then log off Microsoft Project Web Access 2002.
  6. Run the Upg10db.cmd script to upgrade the Microsoft Project Server 2002 database.

MORE INFORMATION

For more information about how to upgrade Microsoft Project Server 2002 to Project Server 2003, see the "Migrating from Earlier Versions" chapter of the Microsoft Project Server 2003 Installation Guide. To obtain the Microsoft Project Server 2003 Installation Guide, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=CA99B5E3-0478-4AC3-A230-C4F2D82096C1&displaylang=en

Modification Type:MinorLast Reviewed:7/27/2006
Keywords:kbsetup kberrmsg kbtshoot kbprb KB884455 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.