Phantom Task Updates

[hinrgsunshine2]

We are working in a Managed Time Period environment. We are experiencing a
situation where task updates are being submitted without anyone actually
submitting them. I've termed it Phantom Tasks. Basically, the project
manager
gets a weekly task update that the submitter claims they did not send. This
happens week after week. I haven't been able to isolate what event triggers
this.

How do I get rid of the notifications?

 

[Gary L. Chefetz [MVP]]

You need to dig a bit deeper to determine what's going on. You mentions both
Updates and notifications, which is it? This is likely due to orphan task
assignments. If this is the case, you'll need to hunt these down in the
database. First, look at what is showing in the user's timesheet to
determine where this might be coming from.

 

[hinrgsunshine2]

Gary-

I've isolated it down to Task Updates that have been rejected by the Project
Manager. Looks like the rejected task is sitting in the users timesheet.
Whenever
they update other tasks these get sent as well, even if the user only
publishes
other updates and does not do an UPDATE ALL.

I'm guessing that I need to have the user update the rejected task with 0 and
re-submit, then have the Project Manager approve the 0 update? If so, the
problem is the user can't go back and submit time in the past since the time
period
is closed.

Here's how I found them,

SELECT MA.WASSN_ID,MP.PROJ_NAME, MA.TASK_NAME, MR.RES_NAME, MA.WRES_ID_MGR,
MWT.WTRANS_DATE, MWT.WTRANS_PROJ_UPDATE_DATE
FROM MSP_WEB_ASSIGNMENTS MA
JOIN MSP_WEB_PROJECTS MP ON MA.WPROJ_ID = MP.WPROJ_ID
JOIN MSP_WEB_RESOURCES MR ON MA.WRES_ID = MR.WRES_ID
JOIN MSP_WEB_TRANSACTIONS MWT ON MA.WASSN_ID = MWT.WASSN_ID
WHERE MWT.WTRANS_ACTION = 2
ORDER by RES_NAME

 

[Gary L. Chefetz [MVP]]

I think you can simply tell the users to hide these, or extend your query to
delete them or set them to hidden.

 

[hinrgsunshine2]

So I can just delete an entry for the WEB_TRANSACTIONS table and it won't
cause havoc in the database?

 

[Gary L. Chefetz [MVP]]

I don't see how deleting a rejected task will affect your database, but you
need to be careful not to do this on other types of records. Mostly, you
need to get them off the timesheet so they don't keep getting resubmitted.