Assignment owner

[Mike]

Was there a change to this field? I recently upgraded Project server to the
latest CU - previously, when creating an assignment, the owner would default
to either the assignment creator, or the default owner (as set in the
enterprise resource)

now - regardless if I manually set the field when creating the assignment,
and regardless of the value in the resource "default assignment owner" field,
the assignment owner is always being set to the resource itself.

 

[Subramanian Vasudevan]

Hi Mike,

I seem to be facing the same problem.

There's a part of my code that has stopped working after applying the
Cumulative Update to MS Project Server.

Earlier, I just had to set the Resource's Default Assignment Owner when
creating the resource. Then I create an empty Project. Then when I build the
Project Team using QueueUpdateProjectTeam, they get imported into the
Project. After that I just construct the required Tasks and Assignments and
call QueueAddToProject, all of the above works fine.

Earlier, the Default Assigment Owner became the Assignment Owner
automatically, for each assignment. But, after applying the hotfixes, this
does not happen. I'm thus facing problems when using Status Updates.

Please advise me what to do...

Thanks and regards,

Subramanian

 

[Subramanian Vasudevan]

Mike,

As you said, even if I EXPLICITLY set the RES_UID_OWNER of the Assignment
Row, it has no effect whatsoever. The assignment owner is simply not set.
Glad if somebody could help me regarding this.

Subramanian

 

[Subramanian Vasudevan]

I'm going to try a workaround. After creating the project fully, I'm going to
try try using ReadProject() to read the project details, change the
RES_UID_OWNER of each assignment, and use QueueUpdateProject() to update the
project and publish it. Maybe then the Assignment's owner will get set.

This problem may arise from the fact that the RES_UID_OWNER is a foreign key
reference to the Project's Resources Table. But when using
QueueAddtoProject,my dataset is not going to contain any rows in the Resource
Table.

Regards,

Subramanian

 

[Subramanian Vasudevan]

This is how my code works:

1. An empty Project is created in MSP.
2. The Resources of the Project are created in the Enterprise Pool. Here I
specify the default assignment owner.
3. I use QueueUpdateProjectTeam to update the ProjectTeam with the resources
I created in step 2.
4. I construct a ProjectDataSet with the tasks and assignments of the
project alone, which have to be added to the Project I created in step 1.
5. I use QueueAddtoProject to add the above tasks and assignments to the
Project. It runs without issues.
6. When I open the project in Project Client, all assignments do NOT have to
assignment owner set to the user i mentioned as default assignment owner of
that resource.

Hoping somebody can help me out.

Regards,

Subramanian

 

[Jim Corbin [MSFT]]

To see the PSI calls and DataSets used in making an assignment, try using
ProjTool (in the Project 2007 SDK download).

A test of WinProj and Project Server with the August Cumulative Update (CU),
and with the December CU, showed the correct ResourceOwner UID. The default
assignment owner was changed in PWA before the two TestAssignmentOwner
projects were created. For task T1, the assignment was made with WinProj. For
task T2, the assignment was made with ProjTool.

Here is a query and the results, which show that the correct resource owner
was added in both the T1 assignments and in the T2 assignment.

__________Query:

SELECT MSP_PROJECTS.PROJ_NAME, MSP_TASKS.TASK_NAME,
MSP_RESOURCES.RES_NAME, MSP_ASSIGNMENTS.RES_UID,
MSP_ASSIGNMENTS.RES_UID_OWNER,
MSP_ASSIGNMENTS.CREATED_DATE
FROM MSP_ASSIGNMENTS INNER JOIN
MSP_RESOURCES ON MSP_ASSIGNMENTS.RES_UID =
MSP_RESOURCES.RES_UID INNER JOIN
MSP_TASKS ON MSP_ASSIGNMENTS.TASK_UID =
MSP_TASKS.TASK_UID INNER JOIN
MSP_PROJECTS ON MSP_ASSIGNMENTS.PROJ_UID =
MSP_PROJECTS.PROJ_UID
ORDER BY MSP_ASSIGNMENTS.CREATED_DATE DESC

_______________Results:

PROJ_NAME TASK_NAME RES_NAME RES_UID RES_UID_OWNER CREATED_DATE
TestAssignmentOwner after Dec
CU T2 R2 d58fd816-d380-46e3-aff1-6cef617d32a2 b3dab395-bc33-4dd7-a3a7-a45522857369 12/17/2008 12:06:58 PM
TestAssignmentOwner after Dec
CU T1 R2 d58fd816-d380-46e3-aff1-6cef617d32a2 b3dab395-bc33-4dd7-a3a7-a45522857369 12/17/2008 11:05:21 AM
TestAssignmentOwner before Dec
CU T1 R2 d58fd816-d380-46e3-aff1-6cef617d32a2 b3dab395-bc33-4dd7-a3a7-a45522857369 12/17/2008 9:32:36 AM
ProtectedActuals tsk1 R2 d58fd816-d380-46e3-aff1-6cef617d32a2 d58fd816-d380-46e3-aff1-6cef617d32a2 9/26/2008 9:47:42 AM
ProtectedActuals tsk1 R1 b3dab395-bc33-4dd7-a3a7-a45522857369 b3dab395-bc33-4dd7-a3a7-a45522857369 9/26/2008 9:47:42 AM

 

[Subramanian Vasudevan]

Hi Jim,

We had only the August CU and the Infrastucture Update installed. I'm going
to try with the December CU applied and post the results here.

With the existing setup, I tried using ProjTool and I found out that when
making Assignments, the Assn Owner is NOT being set to the Default assignment
owner of the resource, but the assignment owner is being set as the resource
itself.

But if I read in the same Project I created, MODIFY the RES_UID_OWNER of
each Assignment in the Project as the User I want, and then use
QueueUpdateProject then the Owner gets changed to the user I want. The
problem is, that If I had specified the default assignment owner while
creating the resource, it is supposed to copy it from there. The extra
QueueUpdateProject call would then not be required. It just hits me with a
performance lag.

I'm helpless and going to try the December CU as a last option.

Regards,

Subramanian