PRJ2000: Base Calendars Are Duplicated When Connected to Resource Pool (316396)


The information in this article applies to:

  • Microsoft Project 2000
This article was previously published under Q316396

SYMPTOMS

In Microsoft Project 2000, when you save or open a project file that is stored in a database, you may experience unreasonably slow performance.

If you open the database and view the MSP_CALENDARS table, calendar names are duplicated in the CAL_NAME field, and each duplicate has the instance number appended.

For example, the CAL_NAME field may contain information similar to the following:

MyCalendar
MyCalendar1
MyCalendar2
MyCalendar3

CAUSE

This problem may occur if you save your project to a Microsoft SQL Server or Oracle database, and all projects share a common resource pool.

RESOLUTION

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Microsoft Project 2000 service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

NOTE: In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The typical support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this fix should have the following file attributes or later. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel. 
   Date         Time   Version        Size       File name
   -----------------------------------------------------------
   12-OCT-2001  10:31                 3,034,112  Msproject.msp
   25-MAR-2002  13:38                       121  cleanup.sql
After the hotfix is installed, the following files will have the listed attributes or later: 
   Date         Time   Version        Size       File name
   ---------------------------------------------------------
   12-OCT-2001  10:31  9.0.2001.1010  6,160,438  Winproj.exe
   12-OCT-2001  10:32  9.0.2001.703     782,389  Pj9od9.dll
You must install this hotfix to each client computer that is running Microsoft Project 2000.

How to Clean Up the Database

After you apply the hotfix, you must follow the steps below to clean up the data in the database.

NOTE: To protect the integrity of your data, back up your database before you follow these steps.

Restore the Resource Pool

NOTE: A user who has read/write permission to the resource pool in the database must perform these steps.
  1. In Microsoft Project, click Open on the File menu. Click ODBC to open the resource pool.
  2. In the Open Resource Pool dialog box, click Open the resource pool read-write so that you can make changes to resource information, and then click OK.
  3. On the Tools menu, point to Resources, and then click Share Resources.
  4. In the Share Resources dialog box, click the first project that is listed in the Sharing Links list, and then press CTRL+SHIFT+END to select all projects.
  5. Click Break Link, and then click OK.
  6. On the File menu, click Save As, and then click ODBC to save the resource pool to the same database that stores the sharer projects.

    NOTE: If the resource pool is already saved to the same database as the sharer projects, Microsoft Project prompts you to overwrite the existing project or append to the database. Click Overwrite.
  7. Close the resource pool.
  8. On the computer where the database is stored, run the Cleanup.sql script against the database where the projects are stored. (Cleanup.sql is downloaded as part of this patch and will be in your download location.)

    For Microsoft SQL Server, you can use the Microsoft Query Analyzer or type the following at a command prompt:

    osql -U account_name -P password -d db_name -i Cleanup.sql

    For an Oracle database server, use a tool such as SQL Plus to log on as a user with the appropriate permissions to the database. Then, at the SQL> prompt, run the Cleanup.sql script.
  9. In Microsoft Project, click Open on the File menu. Click ODBC to open the resource pool.
  10. In the Open Resource Pool dialog box, click Open the resource pool read-write so that you can make changes to resource information, and then click OK.
  11. On the Tools menu, click Options.
  12. On the Calculation tab, click Calculate all open projects, and then click Calculate.
  13. Save and close the resource pool.

Restore the Sharer Projects

You must follow these steps on all projects that share the resource pool.

IMPORTANT: If you restore the link to the resource pool without performing the following steps, the resource pool will again display the behavior described in the "Symptoms" section of this article, and you will again have to perform the earlier steps.
  1. In Microsoft Project, click Open on the File menu. Click ODBC to open one of the projects that shares the resource pool.
  2. In the Open Resource Pool Information dialog box, click Do not open other files.
  3. Repeat steps 1 and 2 until all sharer projects are open.
  4. On the Tools menu, click Options.
  5. On the Calculation tab, click Calculate all open projects, and then click Calculate.
  6. On the File menu, click Save. On the File menu, click Close.
  7. Repeat step 6 for all projects.
  8. Repeat steps 1 and 2 to reopen all projects.
  9. On the File menu, click Open. Click ODBC to open the resource pool.
  10. In the Open Resource Pool dialog box, click Open the resource pool read-write so that you can make changes to resource information, and then click OK.
  11. On the Window menu, click the first sharer project that is listed, so that the pool is not the active project.
  12. On the Tools menu, point to Resources, and then click Share Resources.
  13. In the Share Resources dialog box, click Use Resources. In the From list, click the name of the resource pool, and then click OK.
  14. On the File menu, click Save. On the File menu, click Close.
  15. Repeat steps 12 through 14 for all sharer projects.
WARNING: Do not connect any sharer projects to the pool without first following the steps in both the "Restore the Resource Pool" and "Restore the Sharer Projects" sections of this article. Otherwise, Microsoft Project will again place duplicate calendars in the restored files.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MinorLast Reviewed:10/12/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix KB316396
©2004 Microsoft Corporation. All rights reserved.