Microsoft KB Archive/896043

= You receive an &quot;An error occurred while completing the operation&quot; error message when you try to modify a category by using Office Project Web Access 2003 on a computer that is running Project Server 2003 SP1 and Office Solution Accelerator for Six Sigma =

Article ID: 896043

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. Then, you install and configure Microsoft Office Solution Accelerator for Six Sigma. You log on to Microsoft Office Project Web Access 2003, click Admin, click Manage Security, click a category, and then you click Modify Category. When you try to modify the category, the changes that you make to the category cannot be saved. Instead, you receive the following error message:

An error occurred while completing the operation



CAUSE
This issue occurs if the versions of the Sec_editcategory.asp and Sec_definecategory.asp files that are used by Project Server 2003 SP1 are mismatched. Office Solution Accelerator for Six Sigma overwrites certain Project Server 2003 SP1 files with the versions of the files that are included in Office Solution Accelerator for Six Sigma.



RESOLUTION
To resolve this issue, replace the Sec_editcategory.asp file and the Sec_definecategory.asp file with the correct versions that are required by Project Server 2003 SP1. You must also update the Qylibstd.sql file with the information that is required by Solution Accelerator for Six Sigma. To do this, follow these steps:  Replace the Sec_editcategory.asp file and the Sec_definecategory.asp file with the correct versions that are required by Project Server 2003 SP1. To do this, follow these steps:  Start Microsoft Windows Explorer. Copy the Sec_editcategory.asp and Sec_definecategory.asp files that are located in the following folder:



Note Office Solution Accelerator for Six Sigma backs up the original versions of the Project Server 2003 SP1 files to this folder. If you installed Project Server 2003 SP1 before you installed Office Solution Accelerator for Six Sigma, this folder contains the versions of the files that are included in Project Server 2003 SP1. Paste the Sec_editcategory.asp file and the Sec_definecategory.asp file that you copied in step 1b to the following folder:



 Click Yes when you are prompted to replace the existing files. </li> Update the Qylibstd.sql file with the information that is required by Solution Accelerator for Six Sigma. To do this, follow these steps:  In Notepad, open the Qylibstd.sql file that is located in the following folder:



Note Office Solution Accelerator for Six Sigma backs up the original versions of the Project Server 2003 SP1 files to this folder. If you installed Project Server 2003 SP1 before you installed Office Solution Accelerator for Six Sigma, this folder contains the versions of the files that are included in Project Server 2003 SP1.</li> Add the following lines to the end of the existing text in the Qylibstd.sql file:

<pre class="fixed_text">400000 @MSP_WEB_SP_ADM_GETURLFORTOOLS(^0) 450000 @MSP_WEB_SP_QRY_GetAllTasksForActionItemEditForm(^0,^1,^2) 450001 @MSP_WEB_SP_QRY_GetAllTasksForRiskEditForm(^0,^1,^2) 450002 @MSP_WEB_SP_QRY_GetProjectActionItem(^0) 450003 @MSP_WEB_SP_QRY_GetProjectRisks(^0) 450004 @MSP_WEB_SP_QRY_GetAllProjectTemplates 450005 @MSP_WEB_SP_ADM_SecGetProjectTemplatesForCategoryID(^0)

</li> Save the updated Qylibstd.sql file to the following folder:



</li> Click Yes when you are prompted to replace the existing file.</li></ol> </li></ol>

<div class="moreinformation_section">

MORE INFORMATION
For more information about solutions for Six Sigma management by using the Microsoft Office System, visit the following Microsoft Web site:

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

Additional query words: prj MOSASS

Keywords: kberrmsg kbtshoot kbprb KB896043

-

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

© Microsoft Corporation. All rights reserved.