web assignments without task uid?

[Stephan Steiner]

Hi

Our Project => SAP actuals export fell flat on its nose today because a few
Task EFs were missing. Upon further investigation, I found that I have a
handful of entries in MSP_WEB_WORK whose corresponding entry in the
MSP_WEB_ASSIGNMENTS table lacks the ASSN_ID, TASK_ID and TASK_UID, and hence
no task EFs can be found.

I started checking the fields of the MSP_WEB_ASSIGNMENTS table and found
that all have the WASSN_IS_CONFIRMED field set to 1, many are self-assigned
and not yet approved (WASSN_CREATED_BY_RES = 2), all but one need to be
updated (WASSN_SEND_UPDATE_NEEDED = 1) and all but two have pending actuals
(WASSN_ACTUALS_PENDING = 1)

Since I'm not the project pro, I'm wondering about a few things regarding
the assignments I'm seeing:

Is it possible to have assignments in properly submitted and approved (be
they user created or created by the project manager) state, with ASSN_ID,
TASK_ID or TASK_UID not set? I thought Project always had the following
hierarchy: Project - Task (0 - n) - Assignment (0 - n). It is not yet time
for these actuals to be exported so I suppose all the actuals will be
submitted and approved by the time the export is supposed to run, but this
just got me somewhat worried. It appears for past weeks, everything is in
order, but I'd rather not rely on having been lucky then and get to the
bottom of this.
Can I count on the entries in the MSP_TASKS and MSP_ASSIGNMENTS tables being
created once the actuals have been submitted and approved?

Regards
Stephan

 

[travis.bartlett]

Stephan,

When you say "lacks the ASSN_UID", what data is in that field? Will the
projects affected currently publish successfully without throwing any
errors on the app server?

I ask because I am having a problem where a project won't publish, and
I have noticed that many of the ASSN_UIDs in the project are "-1".

I'm not sure if those are just deleted assignments, or if this project
has become corrupt.

thanks,

Travis

 

[travis.bartlett]

Stephan,

When you say "lacks the ASSN_UID", what data is in that field? Will the
projects affected currently publish successfully without throwing any
errors on the app server?

I ask because I am having a problem where a project won't publish, and
I have noticed that many of the ASSN_UIDs in the project are "-1".

I'm not sure if those are just deleted assignments, or if this project
has become corrupt.

thanks,

Travis

 

[Stephan Steiner]

When I wrote lack, I mean ASSN_UID, TASK_ID and TASK_UID are -1. That means
they are not anywhere in the project (since those three values link to the
MSP_ASSIGNMENTS and MSP_TASKS tables respectively). About half of those
tasks are user created and have yet to be approved so it's natural that they
do not show up in a project... I figure once the approval has been made,
they should show up in the project as they need to be scheduled by the
project manager. Since our entire organization is rather new to Project
Server, there's a lot of task creation and deletion going on right now and I
can't say with certainty that everything we have in the DB is as it ought to
be - hence me asking about entries that I have a hard time understanding.

IIRC, deleted assignments still contain those fields.. at least the task
stuff since I make a query on the MSP_WEB_ASSIGNMENT table with an INNER
JOIN on the MSP_TASKS table to allow users to blend out deleted assignments
as well as those they no longer wish to have in the timesheet (versus the
standard functionality of selecting one, hiding it, selecting the next,
hiding it, .... going nuts).

This afternoon, it's submission time so I'll run that query again to see if
anything has changed.

Regards
Stephan