Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 884455 - Last Review: September 18, 2011 - Revision: 3.0
"Error encountered while running UPGDF11.SQL!" error message when you run the Upg10db.cmd script to upgrade a Microsoft Project Server 2002 database
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!
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)
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.
- Log on to Microsoft Project Web Access 2002 as an administrator.
- Click Admin, and then click Manage views on the Administration overview page.
- Under Resource Center in the View Name column, click Resources Summary, and then click Modify View.
- In the Displayed fields box under Fields: Select the fields you want displayed in the view, click Active, and then click Remove.
- Click Save Changes, and then log off Microsoft Project Web Access 2002.
- Run the Upg10db.cmd script to upgrade the Microsoft Project Server 2002 database.
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:
APPLIES TO
- Microsoft Office Project Server 2003
- Microsoft Project Server 2002
| kbsetup kberrmsg kbtshoot kbprb KB884455 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate