Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 817782 - Last Review: February 1, 2007 - Revision: 5.7
"An OLAP cube was successfully built but with errors" error message when you try to generate an OLAP cube from Project Server 2002
SYMPTOMS
When you try to generate an OLAP cube from Microsoft Project Server
2002, you may receive the following error messages:
An
OLAP cube was successfully built but with errors
Errors in your Application Log
CAUSE
This behavior may occur if you have a
comma in any part of the Microsoft Project Server database. This
includes but is not limited to project names, resource names, task names,
enterprise codes, and outline codes.
Note Commas are used in Microsoft SQL Server as a list
separator and should be avoided.
WORKAROUND
To remove the special characters from your Enterprise
Outlines Codes in Enterprise Global, follow these steps:
- Start Microsoft Project Professional 2002, and then connect with your
Administrator account.
- On the Tools menu, point to
Enterprise Options, and then click Open Enterprise
Global.
- On the Tools menu, point to
Customize, and then click Enterprise
Fields.
- In the Customize Enterprise Fields dialog
box, select your Outline Code Level Resource or
Project.
- Click View LookUp Table.
- Locate and remove any of the following characters in your
Enterprise Outline Code:
";:<>|[],.'?~`!$%^&*()-+={}\,
- Click OK to save your changes.
- On the File menu, click
Save.
To remove special characters from the Enterprise Resource Pool, follow these steps:
- Start Microsoft Project Professional 2002, and then connect with
your Administrator account.
- On the Tools menu, point to
Enterprise Options, and then click Open Enterprise
Resource Pool.
- On the Edit menu, use the
Find command to identify special characters in every field.
To remove special characters from the project plan, follow these steps:
- Open a project plan
- On the Edit menu, use the
Find command to identify special characters in every
field.
APPLIES TO
- Microsoft Office Project Professional 2003
- Microsoft Office Project Server 2003
- Microsoft Project 2002 Professional Edition
- Microsoft Project Server 2002
- Microsoft Office Project Web Access
| kbtshoot kbclientserver kbprb KB817782 |
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