Import Error

G

Gerald

We are using PJS 2003, and started recently receiving the following error
each time the project is opened, any thoughts on were to find the source of
the problem ?

Check row 5 column TASK_REM_WORK
"This is not a vaild work calue or itis outside the range for this column"

tia
--Gerald
 
D

Dale Howard [MVP]

Gerald --

Open the project and try the following:

1. Apply any Task view, such as the Gantt Chart view.
2. Click View - Table - Work.
3. Check the Remaining Work value for task ID #5.

Is there anything unusual in that field for the task in question? For
example, a negative number or a value greater than 1,666,666,666 hours. If
yes, then correct the value, then save and publish the project. If not,
then try these addtional steps:

4. Right-click on the Indicators column and select the Insert Column item
from the list
5. Select the Unique ID field and click the OK button.
6. Locate task Unique ID #5 and examine the Remaining Work value.

Again, is there anything unusual in that field for the task in question? If
yes, then correct the value, then save and publish the project. Let us know
if this helps.
 
G

Gerald

Dale;

Thanks for your time, I tried all you suggested, I could not find a unique
ID 5, ID 5 has a unique ID of 66.

is it possible that it is hidden some way ?

tia
--Gerald
 
D

Dale Howard [MVP]

Gerald --

The task with Unique ID #5 was probably deleted from the project, which
would account for it turning up missing. So on task ID #5, do you see
anything funky with the Remaining Work value? Let us know.
 
G

Gerald

Dale;

No, I dont see any odd values in any of the columns, thou I'm suspecting
that the actual column that is tossing the error may not be visible through
the web or project interface, is there a SQL table(s) I can look at for the
offending values ?

tia
--Gerald
 
D

Dale Howard [MVP]

Gerald --

My suspicion is that the project has become corrupted somehow. To resolve
this problem, I would save the project outside of Project Server as an .xml
file, close it, and open and save it as an .mpp file. Then I would delete
the project from the project server database. If the project has associated
Risks, Issues, or Documents, refer to the following FAQ for the steps needed
to preserver the WSS subweb:

http://www.projectserverexperts.com/Shared Documents/DeleteProjectWithoutSubweb.htm

After deleting the project from the Project Server database, I would import
the project back into the system using the Import Projects wizard. Hope
this helps.
 
G

Gerald

Dale

Thanks, I will start the process... if there are timesheet associcated what
will become of them ?

tia
--Gerald
 
D

Dale Howard [MVP]

Gerald --

After you import the project back into the Project Server database, click
Collaborate - Publish - Republish Assignments and select the "Overwrite
actual work entered by resources" option. This will "push" the timesheet
information back to each resource's View My Tasks page. Hope this helps.
 
G

Gerald

Dale --

Thanks for your patience in helping me through this mess.

Your an awesome asset !!!

--Gerald
 
Top