Task data may disappear or value custom field values in a task may be missing when you make changes to enterprise custom fields in your Master Project File in Project 2003

Article translations Article translations
Article ID: 840314 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you make changes to enterprise custom fields in your Master Project File in Microsoft Office Project 2003, enterprise custom field values that are contained in a task may be missing from the inserted file, and other task data may randomly disappear.

Additionally, when you save a file, you may receive a SQL error message that is similar to the following:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'MSP_TASK_BASELINES'with unique index 'I_MSP_TASK_BASELINES'
In some cases, the SQL error message that you receive may have "MSP_ASSIGNMENT_BASELINES" instead of "MSP_TASK_BASELINES," and the corresponding index is "I_MSP_ASSIGNMENT_BASELINES" instead of being "I_MSP_TASK_BASELINES."

CAUSE

This problem may occur if all the following conditions are true:
  • You save your project plan to your Microsoft Project Server, or you save your project plan as a Master Project File (*.mpp).
  • You make changes to Enterprise Custom Fields.
  • You add new tasks with Enterprise Custom Field data to your Master Project Plan.
  • You save the changes to your project plan, and then restart Microsoft Office Project Professional 2003.
  • You add Enterprise Custom Field data to tasks that you entered earlier that did not previously contain Enterprise Custom Field data.
  • You have more than one Enterprise Custom Field that is defined for any particular entity (task, resource, or assignment) in the project.

RESOLUTION

Service pack information

This problem is corrected in Project 2003 Service Pack 1.

To resolve this problem, obtain the latest service pack for Project 2003. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
873459 How to obtain the latest service pack for Project 2003

Hotfix information

How to obtain the hotfix

This issue is fixed in the Microsoft Project 2003 Hotfix Package that is dated April 21, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
840659 Microsoft Office Project 2003 hotfix package: April 21, 2004

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in Project 2003 Service Pack 1.

Properties

Article ID: 840314 - Last Review: April 7, 2006 - Revision: 3.4
APPLIES TO
  • Microsoft Office Project Professional 2003
  • Microsoft Office Project Server 2003
Keywords: 
kbqfe kbhotfixserver kbproject2003presp1fix kbfix kbbug KB840314

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com