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

Article translations Article translations
Article ID: 837154 - View products that this article applies to.
Expand all | Collapse all

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:
    
    <ViewsDropData>
    	<ProjectData>
    		<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
    		<EntResourceIDList>*</EntResourceIDList>
    		<EntResourceStartDate>Date</EntResourceStartDate>
    		<EntResourceFinishDate>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>
    		<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
    		<EntResourceIDList>*</EntResourceIDList>
    		<EntResourceStartDate>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>
    

CAUSE

This issue may occur if the name of a resource contains one or more of the following list separator characters:
/ " ; : < > | [ ] , . ' ? ~ ` ! $ % ^ & * ( ) - + = { } \
For example, this issue may occur if the name of a resource contains a comma character.

RESOLUTION

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

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

Properties

Article ID: 837154 - Last Review: September 18, 2011 - Revision: 3.0
APPLIES TO
  • Microsoft Project Server 2002
  • Microsoft Office Project Web Access
  • Microsoft Project 2002 Professional Edition
Keywords: 
kberrmsg kbprb KB837154

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com