You receive the "An import error occurred. Check Row <RowNo> column RES_PEAK" error message when you open a project file in Project Professional 2003 (887027)


The information in this article applies to:

  • Microsoft Office Project Professional 2003

SYMPTOMS

When you open a file that is stored in a database, such as Microsoft SQL Server, in Microsoft Office Project Professional 2003, you may receive the following error message:

Microsoft Office Project Professional 2003

An import error occurred.

Check Row <RowNo> column RES_PEAK.

For Work type resources (such as people or machinery), type a positive number between 0 and 60,000,000 (or 6,000,000,000 percent) with up to two decimal places.

Material type resource assignments (such as consumable materials like fuel or cement) can be either fixed or variable. For a fixed material resource assignment, type the units value alone. For example, "10" would mean "10 tons", if your material label was, for example, "tons".

For a variable material resource assignment, type the units value, a s

To continue importing with additional error messages, click Yes.
To continue importing with no error messages, click No.
To stop importing, click Cancel.

CAUSE

This issue may occur for either of the following reasons.

Cause 1

The RES_PEAK value field of any record in the MSP_RESOURCES table of the project database has a negative value.

Cause 2

Negative work values for resources are displayed in the timescale in Task Usage view.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft Project 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

873459 How to obtain the latest service pack for Project 2003

WORKAROUND

Workaround 1

To work around the issue that is mentioned in the "Cause 1" section, follow these steps:
  1. Log on to the computer that is running your project database. For example, log on to the computer that is running Microsoft SQL Server.
  2. Click Start, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  3. In the Connect to SQL Server dialog box, type or select the name of the computer that is running Microsoft SQL Server in the SQL Server list.
  4. Select the authentication type that will grant you access to the project database, type the logon name and password, and then click OK.

    Note Contact your Microsoft SQL Server administrator if you do not have access to your project database.
  5. Type the following Microsoft SQL Server statement in the Query section:
    use <DatabaseName>
update MSP_RESOURCES
set RES_PEAK = 0
where RES_PEAK < 0 ;
    Note The USE DatabaseName command tells Microsoft SQL Server to use the DatabaseName database as the default database for subsequent statements. The database remains the default until the end of the session, or until another USE command is issued.

    The placeholder DatabaseName is the name of your project database.
  6. On the Query menu, click Execute to run the Microsoft SQL Server statement that you typed in the Query section in step 5.
  7. Close Query Analyzer.
  8. Log on to Project Professional 2003, and then open the project file.

Workaround 2

To work around the issue that is mentioned in the "Cause 2" section, set the resource contour to flat for the resources for which you experience this issue. Then, save and publish the project.
Modification Type:MinorLast Reviewed:7/27/2006
Keywords:kberrmsg kbnewfile kbtshoot KB887027 kbAudEndUser kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.