Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 837154 - Last Review: November 30, 2007 - Revision: 1.4
"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;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:
- Identify the resources whose names contain list separator
characters. To do so, follow these steps:
- Start SQL Server Enterprise Manager.
- Expand
ServerName, and then expand
Databases.
- Expand the ProjectServer database, and
then click Tables.
- Right-click the MSP_RESOURCES table,
point to Open Table, and then click Return all
rows.
- 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:
- Log on to Project Web Access as an
administrator.
- Click Admin, click Manage
enterprise features, and then under Enterprise
options, click Check in enterprise resources.
- Make sure that all resources are checked in.
- Under Activities in Admin, click
Manage users and groups.
- In the User Account column, click the
resource whose name you want to modify, and then click Modify
User.
- 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.
- Click OK when you receive the message
that states that the user information was successfully updated.
- 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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=818847/
)
PSVR2002: How to troubleshoot OLAP and Analyzer View
For more information about Project Server 2002,
visit the following Microsoft Web site:
APPLIES TO
- Microsoft Project Server 2002
- Microsoft Office Project Web Access
- Microsoft Project 2002 Professional Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please