Microsoft KB Archive/897773

= 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 =

Article ID: 897773

Article Last Modified on 7/28/2006

-

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.

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

Additional query words: prj MOSASS

Keywords: kbtshoot kbsetup kbprb KB897773

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.