The Financials tab for Office Solution Accelerator for Six Sigma is missing from the views in Project Web Access 2003 after you install Project Server 2003 Service Pack 1 (897773)


The information in this article applies to:

  • Microsoft Office Project Server 2003
  • Microsoft Office Solution Accelerator for Six Sigma

SYMPTOMS

Consider the following scenario. You install Microsoft Office Project Server 2003 Service Pack 1 (SP1) on a computer that is running Microsoft Office Project Server 2003 and Microsoft Office Solution Accelerator for Six Sigma. When users log on to Microsoft Office Project Web Access 2003, the Financials tab for Office Solution Accelerator for Six Sigma is missing from the views in Project Web Access 2003.

CAUSE

This issue occurs if the entries that are required by the Financials feature in Office Solution Accelerator for Six Sigma are no longer stored in the MSP_WEB_CONVERSIONS table of the ProjectServer database in Microsoft SQL Server 2000. Project Server 2003 SP1 rewrites the data that is stored in the MSP_WEB_CONVERSIONS table. Therefore, the entries that Office Solution Accelerator for Six Sigma added when Office Solution Accelerator for Six Sigma was installed on the computer no longer exist in the table.

RESOLUTION

To resolve this issue, add the entries that are required by the Financials feature in Office Solution Accelerator for Six Sigma to the MSP_WEB_CONVERSIONS table. Add the following entries to the four columns of the MSP_WEB_CONVERSIONS table.
String_Type_IDCONV_VALUELANG_IDCONV_STRING
51000001033Financials
51000011033View Financial Information
To do this, follow these steps:
  1. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
  2. Expand Microsoft SQL Servers, expand the server group, and then expand the appropriate server.
  3. Expand Databases, expand the ProjectServer database, and then click Tables.
  4. Right-click MSP_WEB_CONVERSIONS in the right pane, point to Open Table, and then click Return all rows.
  5. Scroll to the end of the table.
  6. Add the entries as two new rows in the table.

MORE INFORMATION

For more information about solutions for Six Sigma management, visit the following Microsoft Web site:

http://www.microsoft.com/office/solutions/accelerators/sixsigma/default.mspx

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