The data from a Microsoft Project 2002 cube may not appear as expected when you view it in Project 2003 (828915)


The information in this article applies to:

  • Microsoft Office Project Server 2003
  • Microsoft Office Project Professional 2003
  • Microsoft Office Project Standard 2003

SYMPTOMS

If you create a cube in Microsoft Office Project Server 2003 and use it to view data that was published from a Microsoft Project 2002 cube, the data that is from the last day of assignments may not be included in the results, and assignments that start and end on the same day may return no data.

CAUSE

This problem occurs because Project 2003 treats AssignmentTimeStart values that are from Project 2002 differently. Because of this, Microsoft Project 2002 truncates the time component of the date/time value. The SQL query tries to find data for projects by comparing the dates. However, the Project 2003 cube values for AssignmentTimeStart include the time in addition to the date. The SQL query excludes data on the last day of a cube range because the default time (typically "8:00 AM") places it outside the query's parameters.

For example, the following WHERE clause finds one-day assignments for 2003-01-01, where all the AssignmentTimeStart values have the time truncated: 
            AND AssignmentTimeStart >= {d'2003-01-01'} 
            AND AssignmentTimeStart <= {d'2003-01-01'}
However, in Project 2003, all the AssignmentTimeStart values have a time value, typically 08:00:00 AM. Therefore, an AssignmentTimeStart value of 2003-01-01 08:00:00 AM is excluded by the same query because the value is not less than or equal to 2003-01-01 00:00:00 AM.

WORKAROUND

To work around this problem, republish the projects that are in Project 2003. To do this, point to Publish on the Collaborate menu, and then click Republish Assignments.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MinorLast Reviewed:1/12/2006
Keywords:kbprb kbdisplay kbconversion kbpending KB828915 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.