Microsoft KB Archive/817782

= &quot;An OLAP cube was successfully built but with errors&quot; error message when you try to generate an OLAP cube from Project Server 2002 =

Article ID: 817782

Article Last Modified on 2/1/2007

-

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

-



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:

/&quot;;:<>|[],.'?~`!$%^&*-+={}\,

 Click OK to save your changes.</li> On the File menu, click Save.</li></ol>

To remove special characters from the Enterprise Resource Pool, follow these steps:
 * 1) Start Microsoft Project Professional 2002, and then connect with your Administrator account.
 * 2) On the Tools menu, point to Enterprise Options, and then click Open Enterprise Resource Pool.
 * 3) 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:
 * 1) Open a project plan
 * 2) On the Edit menu, use the Find command to identify special characters in every field.

Additional query words: PRJ2002 PSVR2002

Keywords: kbtshoot kbclientserver kbprb KB817782

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.