SOLVED

Material Assignment Contour is Changed after Upgrade (2010 to 2019)

%3CLINGO-SUB%20id%3D%22lingo-sub-2191515%22%20slang%3D%22en-US%22%3EMaterial%20Assignment%20Contour%20is%20Changed%20after%20Upgrade%20(2010%20to%202019)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2191515%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EWe%20are%20upgrading%20the%20server%20from%202010%20to%202019%20(Project%20Pro%202016).%3C%2FP%3E%3CP%3EWe%20noticed%20a%20task%20that%20has%202%20resources%20-%201%20work%20resource%20and%201%20material%20resource.%3C%2FP%3E%3CP%3EWe%20researched%20it%20in%204%20places%3A%3C%2FP%3E%3COL%3E%3CLI%3EProject%20Pro%202010%3C%2FLI%3E%3CLI%3EProject%202010%20DB%20view%20Epm_AssignmentByDay_UserView%3C%2FLI%3E%3CLI%3EProject%20Pro%202016%3C%2FLI%3E%3CLI%3EProject%202019%20DB%20view%26nbsp%3BEpm_AssignmentByDay_UserView%3C%2FLI%3E%3C%2FOL%3E%3CP%3EWe%20see%20that%20the%20work%20resource%20assignment%20ends%20on%201-Sep-19%20in%20all%20sources%3C%2FP%3E%3CP%3EWe%20see%20that%20the%20material%20resource%20assignment%20ends%20on%2029-Dec-19%20in%20Pro%202010%20and%20both%20DB's%20(meaning%20that%20the%20migration%20works%20OK)%3C%2FP%3E%3CP%3EWe%20see%20that%20the%20material%20resource%20assignment%20ends%20on%201-Sep-19%20(same%20date%20as%20the%20work%20resource)%20in%20Pro%202016%2C%20meaning%20that%20when%20the%20Pro%20is%20opened%2C%20it%20re-calculated%20the%20material%20assignment%20according%20to%20a%20different%20logic%2C%20maybe%20adjusting%20it%20to%20the%20work%20assignment.%20BTW%20-%20the%20total%20amount%20of%20material%20work%20didn't%20change%2C%20the%20entire%20material%20work%20performed%20for%20Sep%20-%20Dec%20in%202010%20was%20summed%20up%20to%201-Sep-19%20in%20Pro%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20explanation%20for%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EBarak%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2191675%22%20slang%3D%22en-US%22%3ERe%3A%20Material%20Assignment%20Contour%20is%20Changed%20after%20Upgrade%20(2010%20to%202019)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2191675%22%20slang%3D%22en-US%22%3EFirst%20of%20all%2C%20there%20is%20no%20material%20work%2C%20material%20is%20a%20consumable.%20Yeah%20I%20know%2C%20when%20you%20look%20at%20a%20material%20assignment%20row%20in%20a%20Usage%20view%2C%20it%20shows%20as%20%22work%22%20but%20it%20is%20not.%20Material%20is%20assigned%20as%20a%20quantity%20of%20something%20like%20gallons%20of%20fuel%2C%20number%20of%20bricks%2C%20reams%20of%20paper%2C%20etc.%20A%20material%20resource%20is%20linearly%20spread%20over%20the%20full%20task%20duration%2C%20assuming%20it%20is%20%22prorated%22%2C%20although%20it%20can%20also%20be%20manually%20edited%20for%20any%20time%20span.%20In%20your%20case%20however%2C%20the%20material%20time%20span%20is%20greater%20than%20that%20of%20the%20work%20resource%20which%20makes%20no%20sense.%20I%20can%20only%20assume%20it%20is%20an%20assignment%20corruption%20that%20was%20corrected%20when%20you%20converted%20to%20Project%202016.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps.%3CBR%20%2F%3EJohn%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2193503%22%20slang%3D%22en-US%22%3ERe%3A%20Material%20Assignment%20Contour%20is%20Changed%20after%20Upgrade%20(2010%20to%202019)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2193503%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20response.%20It%20gave%20me%20a%20good%20direction.%3CBR%20%2F%3EI%20did%20some%20more%20checks%20and%20saw%20that%20an%20assignment%20of%20Work%20Resource%20with%20Material%20Resource%20on%20different%20times%20behaves%20quite%20chaotically%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Finish%20date%20is%20set%20by%20the%20latest%20finish%20date%20among%20assignments%20(even%20if%20it's%20the%20Material%20Resource)%20but%20duration%20is%20set%20by%20the%20work%20resource%2C%20so%20duration%20doesn't%20fit%20the%20time%20between%20start%20and%20finish%3CBR%20%2F%3E2.%20Adding%20a%20work%20resource%20to%20a%20task%20with%20material%20resource%20with%20the%20new%20assignment%20having%20an%20earlier%20finish%20date%20than%20the%20material%20assignment%3A%3CBR%20%2F%3Ea.%20If%20done%20using%20Task%20Form%20*dialog*%20or%20Resource%20Names%20field%20-%20won't%20affect%20the%20finish%20date%20of%20the%20material%20assignment%3CBR%20%2F%3Eb.%20If%20done%20using%20Task%20Form%20*in%20details%20pane*%20-%20the%20finish%20date%20of%20the%20material%20assignment%20will%20adjust%20to%20that%20of%20the%20work%20assignment%3CBR%20%2F%3Ec.%20In%20the%20above%20scenario%2C%20in%20any%20case%2C%20the%20duration%20of%20the%20task%20will%20change%20to%20that%20of%20the%20duration%20of%20the%20work%20assignment%3CBR%20%2F%3Ed.%20adding%20a%20*second*%20work%20assignment%20to%20a%20task%20with%20material%20assignment%20and%20work%20assignment%20(no%20matter%20if%20the%20material%20assignment%20is%20longer%2C%20shorter%20or%20equal%20than%20the%20first%20assignment)%20-%20the%20material%20assignment%20will%20adjust%20to%20the%20second%20assignment%20if%20it's%20longer%20than%20the%20first%20assignment%20and%20*won't%20change*%20if%20the%20second%20is%20shorter%20than%20the%20first%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

We are upgrading the server from 2010 to 2019 (Project Pro 2016).

We noticed a task that has 2 resources - 1 work resource and 1 material resource.

We researched it in 4 places:

  1. Project Pro 2010
  2. Project 2010 DB view Epm_AssignmentByDay_UserView
  3. Project Pro 2016
  4. Project 2019 DB view Epm_AssignmentByDay_UserView

We see that the work resource assignment ends on 1-Sep-19 in all sources

We see that the material resource assignment ends on 29-Dec-19 in Pro 2010 and both DB's (meaning that the migration works OK)

We see that the material resource assignment ends on 1-Sep-19 (same date as the work resource) in Pro 2016, meaning that when the Pro is opened, it re-calculated the material assignment according to a different logic, maybe adjusting it to the work assignment. BTW - the total amount of material work didn't change, the entire material work performed for Sep - Dec in 2010 was summed up to 1-Sep-19 in Pro 2016.

 

Is there any explanation for this?

 

Thanks,

Barak

3 Replies
best response confirmed by Barakb321 (Occasional Contributor)
Solution
First of all, there is no material work, material is a consumable. Yeah I know, when you look at a material assignment row in a Usage view, it shows as "work" but it is not. Material is assigned as a quantity of something like gallons of fuel, number of bricks, reams of paper, etc. A material resource is linearly spread over the full task duration, assuming it is "prorated", although it can also be manually edited for any time span. In your case however, the material time span is greater than that of the work resource which makes no sense. I can only assume it is an assignment corruption that was corrected when you converted to Project 2016.

Hope this helps.
John
Thanks for your response. It gave me a good direction.
I did some more checks and saw that an assignment of Work Resource with Material Resource on different times behaves quite chaotically:

1. Finish date is set by the latest finish date among assignments (even if it's the Material Resource) but duration is set by the work resource, so duration doesn't fit the time between start and finish
2. Adding a work resource to a task with material resource with the new assignment having an earlier finish date than the material assignment:
a. If done using Task Form *dialog* or Resource Names field - won't affect the finish date of the material assignment
b. If done using Task Form *in details pane* - the finish date of the material assignment will adjust to that of the work assignment
c. In the above scenario, in any case, the duration of the task will change to that of the duration of the work assignment
d. adding a *second* work assignment to a task with material assignment and work assignment (no matter if the material assignment is longer, shorter or equal than the first assignment) - the material assignment will adjust to the second assignment if it's longer than the first assignment and *won't change* if the second is shorter than the first
In working with Project over the years I have run across some instances when Project just doesn't respond in an explainable manner. I don't get the same response you describe above using Project 2019 Pro which doesn't surprise me. There will always be scenarios that challenge Project's scheduling algorithm. Learn to live with them and develop a workaround when necessary.