PRJ2000: Portfolio View Collapsed or Project Name Column Is Incorrect (329830)


The information in this article applies to:

  • Microsoft Project 2000
This article was previously published under Q329830

SYMPTOMS

When you view the View Your Portfolio page in Microsoft Project Central, you may experience one or both of the following symptoms:
  • The grid is collapsed so that it appears as a small box, and you cannot expand the grid.
  • The column names are incorrect. For example, the Actual Cost, Baseline Cost, Cost or Cost Variance columns may be displayed instead of the Project Name, Start and Finish columns.

CAUSE

This issue may occur if both of the following conditions exist:
  • You use Microsoft SQL Server to store the Project Central database.
  • The Project Central scripts to create the Project Central database were used in the wrong order. For example, you ran the Insdefsi.sql script before the Insdefsq.sql script.

RESOLUTION

To resolve this issue, run the Insdefsq.sql script, and then run the Insdefsi.sql script:

NOTE: When you run the scripts, your Project Central Database is reset, and your data is no longer valid in Project Central. Make a copy of your project file so that you can re-send messages to Project Central after the database is reset.
  1. Start Microsoft SQL Query Analyzer. To do so, click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  2. In the Connect to SQL Server dialog box, click the server that you want to work with in the SQL Server box.
  3. Click to select the Start SQL Server if it is stopped check box.
  4. Under Connect using, click SQL Server authentication if it is not already selected.
  5. In the Login name box, type SA if it does not already appear.
  6. In the Password box, type the password for the SA account, and then click OK. SQL Query Analyzer starts.
  7. Make sure that Master is the selected database in the Query window.

    NOTE: Master appears in the status bar at the bottom of the Query window. When you position the pointer over it, you see a "Database Name: master" tooltip.
  8. In the Query window list that displays Master, click Project_CentralDb.
  9. Insert the Project Central CD into the CD-ROM or DVD-ROM drive.
  10. In the SQL Query Analyzer, click Open on the File menu.
  11. In the Open Query File dialog box, view the PJCNTRL\ISAPI\1033 folder on the Project Central CD.
  12. On the File menu, click Open. In the Open Query File dialog box, click Insdefsq.sql, and then click Open.
  13. On the Query menu, click Execute.

    NOTE: Wait for this process to finish before you go to the next step.
  14. On the File menu, click Open. In the Open Query File dialog box, click Insdefsi.sql, and then click Open.
  15. On the Query menu, click Execute.
  16. When the process is finished, click Exit on the File menu.
Modification Type:MinorLast Reviewed:4/29/2003
Keywords:kbui kbprb KB329830
©2002 Microsoft Corporation. All rights reserved.