Losing Predecessors on Copy Paste - Server Only - Not Local

J

John D.

Re-post from General forum

Original Problem -

Error Message:

"Pasting Error Occurred on ID X in the [blank] column

This is not a valid duration, or is outside the range for this field .... "


By [blank] I mean the normal text for the column name is missing. As if the
column it's seeing the error in has no name.

This was also followed with the same error for the Basline Fixed Cost
Accrual Column

Occurs while copying and pasting a summary task in schedule that has been
inserted to another schedule. Happens in both the sub schedule alone and in
the consolidating schedule.

It is reproducible by my ISP's tech support.

Tried to date:
XP Sp3
MS Project Pro 2007 - SP1
Creating a different view and doing the copy -n- paste from there.
There was on article in the MS knowledge base that was not useful.

I can get it to go away by saving down to 2003, doing on copy-n-paste and
then using that new task group going forward with subsequent copy-n-pastes.

I'm guessing somewhere in the process one or more bogus columns are showing
up in the schema, but I have no way that I know of to find it.

Update -

Been working on this some more. Seems to be related to enterprise custom
fields. Some of them seem to have come into the project in the process of
opening a local schedule whilst logged into the server in Project Pro.

I've noticed that these fields show up after opening the schedule but
subsequently go away after saving to the server with a clean brand new
project. But, somewhere in the process on at least one of my project files,
they got "stuck" in the project.

I suspect they are sitting there with bad data in them to boot which is
fouling up the copy paste process some how.

I have saved these files locally out to .XML and the custom fields go away.

My ISP has been able to work around by checking out the file, disconnecting
from the server, doing the copy paste locally, then checking it back in. This
is probably an OK work around but complicates things.

Current plan is to do this -
Establish default values for the basic enterprise custom fields on the
server in hopes that this will at least prevent garbage data or
uninitialized variables.

Re-save and republish the cleansed files.

Re link the project to project interfacing tasks.

If any of this is ringing a bell and / or you have additional suggestions,
please let me know.

I hope this is the right forum. The problem is not happening locally, so I'm
regarding it as a server driven problem that is showing up in the client.

Update -

This is now totally reproducible.

The files have all been cleaned up by saving to .XML and resaving back to
..MPP and they have all been saved, not published yet, to the server. Then the
sub projects were re-inserted to consolidating project.

All enterprise custom fields have a defaults, none are required.

The copy and paste of a summary task and it's sub tasks drops the
predecessors and successors local to that group of tasks. This is while
editing from the consolidating schedule and while editing in one of the
individual sub projects.

Getting the same error as previously noted.

Enterprise fields are not showing up in the organizer. Health shows up in
the custom fields on a task level.

Can't see the State field in the client.

Any input or feedback would be greatly appreciated.

Saving the project as a file locally, then doing the copy paste work. Then
you can save it back over the existing server schedule. The links between the
sub project and the consolidating project were OK in my test.

Did not have to go Offline interestingly enough, which seemed to avoid any
error messages about external links missing.

I'd still like to solve the problem. It seems like you ought to be able to
copy paste while online and not have your predecessors go away.

Best,
John
 
G

Gary L. Chefetz

John:

The fundamental problem with what you're doing by using a row-level cut and
paste is that you are duplicating database rows in the process which creates
key data violations and, as you've seen, just makes a mess of things. It's
not a problem for an mpp file, but when you're connected to server, you're
directly populating database tables.

The way to do this is to copy and paste the task names only and then link
the new tasks to the source tasks in the subprojects. If you find the
linking tedious, and your tasks carry unique names or identifiers, you can
write a macro to do the linking.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


John D. said:
Re-post from General forum

Original Problem -

Error Message:

"Pasting Error Occurred on ID X in the [blank] column

This is not a valid duration, or is outside the range for this field ....
"


By [blank] I mean the normal text for the column name is missing. As if
the
column it's seeing the error in has no name.

This was also followed with the same error for the Basline Fixed Cost
Accrual Column

Occurs while copying and pasting a summary task in schedule that has been
inserted to another schedule. Happens in both the sub schedule alone and
in
the consolidating schedule.

It is reproducible by my ISP's tech support.

Tried to date:
XP Sp3
MS Project Pro 2007 - SP1
Creating a different view and doing the copy -n- paste from there.
There was on article in the MS knowledge base that was not useful.

I can get it to go away by saving down to 2003, doing on copy-n-paste and
then using that new task group going forward with subsequent
copy-n-pastes.

I'm guessing somewhere in the process one or more bogus columns are
showing
up in the schema, but I have no way that I know of to find it.

Update -

Been working on this some more. Seems to be related to enterprise custom
fields. Some of them seem to have come into the project in the process of
opening a local schedule whilst logged into the server in Project Pro.

I've noticed that these fields show up after opening the schedule but
subsequently go away after saving to the server with a clean brand new
project. But, somewhere in the process on at least one of my project
files,
they got "stuck" in the project.

I suspect they are sitting there with bad data in them to boot which is
fouling up the copy paste process some how.

I have saved these files locally out to .XML and the custom fields go
away.

My ISP has been able to work around by checking out the file,
disconnecting
from the server, doing the copy paste locally, then checking it back in.
This
is probably an OK work around but complicates things.

Current plan is to do this -
Establish default values for the basic enterprise custom fields on the
server in hopes that this will at least prevent garbage data or
uninitialized variables.

Re-save and republish the cleansed files.

Re link the project to project interfacing tasks.

If any of this is ringing a bell and / or you have additional suggestions,
please let me know.

I hope this is the right forum. The problem is not happening locally, so
I'm
regarding it as a server driven problem that is showing up in the client.

Update -

This is now totally reproducible.

The files have all been cleaned up by saving to .XML and resaving back to
.MPP and they have all been saved, not published yet, to the server. Then
the
sub projects were re-inserted to consolidating project.

All enterprise custom fields have a defaults, none are required.

The copy and paste of a summary task and it's sub tasks drops the
predecessors and successors local to that group of tasks. This is while
editing from the consolidating schedule and while editing in one of the
individual sub projects.

Getting the same error as previously noted.

Enterprise fields are not showing up in the organizer. Health shows up in
the custom fields on a task level.

Can't see the State field in the client.

Any input or feedback would be greatly appreciated.

Saving the project as a file locally, then doing the copy paste work. Then
you can save it back over the existing server schedule. The links between
the
sub project and the consolidating project were OK in my test.

Did not have to go Offline interestingly enough, which seemed to avoid any
error messages about external links missing.

I'd still like to solve the problem. It seems like you ought to be able to
copy paste while online and not have your predecessors go away.

Best,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top