You are currently offline, waiting for your internet to reconnect

"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

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;User ID=MSProjectServerUser; Password=Password;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source= SourceName </DSOConnection><Server>ServerName/Server><CubeDB>Project2002</CubeDB><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 argumentAdditional 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;User ID=MSProjectServerUser; Password=Password;Persist Security Info=False;Initial Catalog=ProjectServer;Data Source=SourceName</DSOConnection><Server>ServerName</Server><CubeDB>Project2002</CubeDB><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:
Properties

Article ID: 837154 - Last Review: 09/18/2011 03:44:00 - Revision: 3.0

  • Microsoft Project Server 2002
  • Microsoft Office Project Web Access
  • Microsoft Project 2002 Professional Edition
  • kberrmsg kbprb KB837154
Feedback