An import error occurred.

[Ivor Davies]

Project Managers receive the following error message when the try to add
resources from the Enterprise Resource Pool in Project Server 2003 (this
happens for all projects):

An import error occurred.

Check row 732 column ASSN_REG_WORK

This is not a valid work value or it is outside the range for this column.

For Work resources, type the work amount and the abbreviation for the time
period, for example, "12d" or "4hrs".

For Material resources, type the work amount alone or type the work amount
plus the Material label you created for the resource, for example "8 tons".

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

 

[Ivor Davies]

I have had our SQL experts perform a query on the MSP_ASSIGNMENTS table -
returning the top 733 rows in the table.

The value for ASSN_REG_WORK for row 732 has a value of 114549000.000000,
where the others have values in the 94 -99 range.

Also row 733 returns a value of 19200000.000000 for ASSN_REM_WORK, while all
the others have a value of 0.000000.

This at least provides me some more information.

Ivor