"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 (837154)

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>

RESOLUTION

To resolve this issue, remove the list separator characters from the resource names. To do so, follow these steps:

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.
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.

"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 (837154)

SYMPTOMS

CAUSE

RESOLUTION

MORE INFORMATION