The Financials tab for Office Solution Accelerator for Six Sigma is missing from the views in Project Web Access 2003 (897772)


The information in this article applies to:

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

SYMPTOMS

Consider the following scenario. Microsoft Office Solution Accelerator for Six Sigma is installed and configured on a computer that is running Microsoft Office Project Server 2003. 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.

The Financials tab was displayed as expected when users previously logged on to Project Web Access 2003. However, when users now log on to Project Web Access 2003, the Financials tab is missing.

CAUSE

This issue occurs if you modified the permissions settings of an Office Solution Accelerator for Six Sigma category or of an Office Solution Accelerator for Six Sigma security template. Permissions settings that are specific to Office Solution Accelerator for Six Sigma are applied when Office Solution Accelerator for Six Sigma is installed on the computer. When you modify the permissions settings of an Office Solution Accelerator for Six Sigma category or of an Office Solution Accelerator for Six Sigma security template, the permissions settings for the Financials feature are not retained in Project Server 2003.

For example, if you modify the Black Belt security template, the users to whom the Black Belt security template applies no longer have access to the Financials tab in Project Web Access 2003.

RESOLUTION

To resolve this issue, create an SQL script that contains the following lines of code. 
DECLARE @tempTable Table(relID int)

INSERT INTO @tempTable (relID)
SELECT 
	DISTINCT p.WSEC_REL_ID 
FROM 
	dbo.MSP_WEB_SECURITY_SP_CAT_PERMISSIONS p INNER JOIN 
	dbo.MSP_WEB_SECURITY_SP_CAT_RELATIONS r ON 
	p.WSEC_REL_ID = r.WSEC_REL_ID INNER JOIN 
	dbo.MSP_WEB_VW_SEC_ALLSP a ON 
	r.WSEC_SP_GUID = a.WSEC_SP_GUID 
WHERE 
	a.WSEC_SP_NAME IN ('Black Belt', 'Master Black Belt', 'Executive Sponsor', 'Finance', 'Champion', 'Site VP of Six Sigma', 'Corp VP of Six Sigma', 'Executives', 'Administrators')

INSERT INTO MSP_WEB_SECURITY_SP_CAT_PERMISSIONS (WSEC_REL_ID,WSEC_FEA_ACT_ID,WSEC_ALLOW,WSEC_DENY,WSEC_ACCESS)
select relID,10001,1,0,1 from @tempTable
Run the SQL script to add the permissions settings for the Financials tab back to the Office Solution Accelerator for Six Sigma roles.

This SQL script works as follows. The script declares a temporary table and then inserts data that is based on the query that uses the SELECT DISTINCT statement. The query returns a list of relationship IDs that correspond to categories that are available to the Office Solution Accelerator for Six Sigma roles. The INSERT INTO statement uses the relationship IDs from the temporary table to insert a row for each relationship ID into the MSP_WEB_SECURITY_SP_CAT_PERMISSIONS table. The value of the relationship ID is inserted into the WSEC_REL_ID column. The INSERT INTO statement also inserts the following values into the following columns.
WSEC_FEA_ACT_IDWSEC_ALLOWWSEC_DENYWSEC_ACCESS
10001101
The value of 10001 in the WSEC_FEA_ACT_ID column corresponds to the Financials tab.

Notes
  • Make sure that you back up data on the server before you run the SQL script.
  • If you receive a primary key error message when you run the script, remove the roles that are referenced in the error message from the SELECT DISTINCT statement.
  • An alternative method that you can use when you run this script is to run the SELECT DISTINCT statement by using one role at a time. After you run the SELECT DISTINCT statement for one role, manually insert the rows into the MSP_WEB_SECURITY_SP_CAT_PERMISSIONS table for each relationship ID. Repeat this procedure for each role.
  • In scenarios where you have to frequently use the SQL script, you may want to incorporate the SQL script into an Active Server Pages (ASP) page. Then, add a link to the ASP page to the Admin menu in Project Web Access 2003.

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:kbtshoot kbprb KB897772 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.