Microsoft KB Archive/837154

= &quot;Not enough memory to complete the operation&quot; error message when you open the enterprise resource pool or you cannot build an OLAP cube in Project Server 2002 =

Article ID: 837154

Article Last Modified on 11/30/2007

-

APPLIES TO


 * Microsoft Project Server 2002
 * Microsoft Office Project Web Access
 * Microsoft Project 2002 Professional Edition

-





SYMPTOMS
You may experience one or more of the following symptoms in Microsoft Project Server 2002:  In Microsoft Project Professional 2002, when you open the enterprise resource pool, you may receive the following error message:

There is not enough memory to complete the operation. Close programs, projects, or windows you aren't using, and then try again.

 When you log on to Microsoft Project Web Access and then build an On-Line Analytical Processing (OLAP) cube in Microsoft Project Server, the operation is not completed successfully because the operation cannot process information from the enterprise resource pool. Entries that are similar to the following are logged to the trace log file:

DateTime: File
 * Drive:\Proj10\WebClient\source\utility\pjadorsutil2.cpp Line :1691 HResult :0x80004005

Description :Assert Detected. The error code was also included. For more information, please see the event log.

PjViewMgr: DateTime: File
 * Drive:\Proj10\WebClient\source\server\pjviewmgr\ViewCreator.cpp Line :464 HResult
 * 0x80004005 Description :Assert Detected. The error code was also included.

Views Notification Service:  DateTime: File: Drive:\Proj10\pcportal\source\viewsnotify\ViewNotify.cpp Line :127 HResult :0x800a0005 Description :The views processor failed to process the following document:

  <![CDATA[resglobal] ]> * Date Date</EntResourceFinishDate> <BuildCubeRequest><CubeUpdate><CubeStart>Date</CubeStart><CubeFinish>Date< /CubeFinish><Connection>Provider=SQLOLEDB;User ID=MSProjectServerUser; Password=Password;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=SourceName</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB;Use r ID=MSProjectServerUser; Password=Password;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source= SourceName </DSOConnection><Server>ServerName/Server><CubeDB>Project2002</Cub eDB><CubeDesc>Project 2002 Resource Availability</CubeDesc></CubeUpdate></BuildCubeRequest> </ProjectData> <OrgGuid>projectserver</OrgGuid> <BasePath>projectserver</BasePath> <TimeStamp>Date Time </TimeStamp> </ViewsDropData>

PjQuery:   DateTime: File
 * Drive:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp Line :102 HResult
 * 0x80004005 Description :Assert Detected. The error code was also included.

PjViewMgr: DateTime: File
 * Drive:\Proj10\WebClient\source\server\pjviewmgr\ViewCreator.cpp Line :693 HResult
 * 0x80004005 Description :Assert Detected. The error code was also included.

Views Notification Service:   DateTime: File
 * Drive:\Proj10\pcportal\source\viewsnotify\ViewNotify.cpp Line :122 HResult :0x800a0005

Description :View schedular received error while scheduling views. For more information, please see the event log.

PjQuery:   DateTime: File
 * Drive:\Proj10\WebClient\source\server\pjquery\PjGenericQuery.cpp Line :886 HResult
 * 0x80004005 Description :Assert Detected. The error code was also included.

PCSViews:  DateTime: File :ViewsDrop.cls Line :-1 HResult :0x5 Description :Error Information: Invalid procedure call or argument Additional Information: An error occurred processing the following view :-

<ViewsDropData> <ProjectData> <![CDATA[resglobal] ]></EntProjectName> *</EntResourceIDList> Date</EntResourceStartDate> <EntResourceFinishDate>Date</EntResourceFinishDate> <BuildCubeRequest><CubeUpdate><CubeStart>Date</CubeStart><CubeFinish>Date< /CubeFinish><Connection>Provider=SQLOLEDB;User ID=MSProjectServerUser; Password=project2002;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=SourceName</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB;Use r ID=MSProjectServerUser; Password=Password;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=SourceName</DSOConnection><Server>ServerName</Server><CubeDB>Project2002</Cub eDB><CubeDesc>Project 2002 Resource Availability</CubeDesc></CubeUpdate></BuildCubeRequest> </ProjectData> <OrgGuid>projectserver</OrgGuid>

</li></ul>

<div class="cause_section">

CAUSE
This issue may occur if the name of a resource contains one or more of the following list separator characters:

/ &quot; ; : < > | [ ],. ' ? ~ ` ! $ % ^ & * - + = { } \

For example, this issue may occur if the name of a resource contains a comma character.

<div class="resolution_section">

RESOLUTION
To resolve this issue, remove the list separator characters from the resource names. To do so, follow these steps: <ol> Identify the resources whose names contain list separator characters. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> Start SQL Server Enterprise Manager.</li> Expand  , and then expand Databases.</li> Expand the ProjectServer database, and then click Tables.</li> Right-click the MSP_RESOURCES table, point to Open Table, and then click Return all rows.</li> In the RES_NAME column, make a note of the resources whose names contain list separator characters.</li></ol> </li> Remove the list separator characters from the names of the resources that you identified in step 1. To do so, follow these steps: <ol style="list-style-type: lower-alpha;"> Log on to Project Web Access as an administrator.</li> Click Admin, click Manage enterprise features, and then under Enterprise options, click Check in enterprise resources.</li> Make sure that all resources are checked in.</li> Under Activities in Admin, click Manage users and groups.</li> In the User Account column, click the resource whose name you want to modify, and then click Modify User.</li> On the Modify User page, in the User Account box, remove the list separator character from the name of the resource, and then click Save Changes.</li> <li>Click OK when you receive the message that states that the user information was successfully updated.</li> <li>Repeat step 2e through 2g for each resource name that you want to modify.</li></ol> </li></ol>

<div class="moreinformation_section">

MORE INFORMATION
For more information about how to work with enterprise resources, see Microsoft Project 2002 Help. In Microsoft Project Professional, on the Help menu, click Microsoft Project Help. Type enterprise resources, and then click Search to view the topics that are returned.

For additional information about how to troubleshoot OLAP, click the following article number to view the article in the Microsoft Knowledge Base:

818847 PSVR2002: How to troubleshoot OLAP and Analyzer View

For more information about Project Server 2002, visit the following Microsoft Web site:

http://support.microsoft.com/ph/2692

Keywords: kberrmsg kbprb KB837154

-

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

© Microsoft Corporation. All rights reserved.