Ran SQL to delete tasks - problem

[LAUREEN.]

Hello,

We ran:

delete from MSP_WEB_ASSIGNMENTS
where WASSN_ID IN (
select ma.WASSN_ID 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
where
ma.WASSN_DELETED_IN_PROJ <>0
--AND mp.PROJ_NAME like '25713%' --uncomment it for specific project
)


After this, now my projects schedules are not lining up with what is being
published. Under view resource assignments, I see assignments that are no
longer in the schedule. I pulled the ID for both the web ones and the
schedules and the tasks do not match. I tried re-publising. Please help, we
have been so frustrated trying to use the view resource assignments view.

 

[Gaurav Wason]

Why did you ran this query? Did you ran this query in Production or Dev?
--
Please rate this post if it has helped

Thanks
Gaurav Wason
(e-mail address removed), PMP, MCTS Project Made Easy (Project Server Archive Tool)
and (Project Owner Tool)
http://projectmadeeasy.com

 

[LAUREEN.]

We ran it because we had to many tasks with an "x" next to them in view
resource assigments. I got the query from this forum. We did it in
production- is this bad? We can restore an old dbase if we need to.

 

[Gaurav Wason]

This is better as this will hide the assignments from timesheet.

UPDATE MSP_WEB_ASSIGNMENTS
SET WASSN_REMOVED_BY_RESOURCE = 1
WHERE WASSN_Deleted_In_Proj = 1 and task_is_Summary = 0

What was the result when you ran the original query.
--
Please rate this post if it has helped

Thanks
Gaurav Wason
(e-mail address removed), PMP, MCITP roject Made Easy (Project Server Archive Tool)
and (Project Owner Tool)
http://projectmadeeasy.com

 

[LAUREEN.]

I didn't know there was a script to hide them. I have researched this before
using the other script and found it was good to remove the deleted tasks. It
did appear to do this, but now my Task IDs are not lining up. There are
tasks that are appearing as "assignments" but are no longer in the schedule.

 

[Gaurav Wason]

Laureen,

You Looking at the query looks like you deleted only the tasks that were
maked for deletion. Is this happening for all projects or Some Projects.

Thanks

Gaurav Wason

 

[Gaurav Wason]

Run this query and see if this resolves the problem.

Update MSP_WEB_Assignments
Set WASSN_Removed_By_Resource = 1, WASSN_LOCKDOWN_BY_MANAGER = 1
Where
WASSN_Removed_By_Resource = 0 and WASSN_Deleted_In_Proj = 1

Thanks

Make sure you test this in Dev

Gaurav

 

[LAUREEN.]

Thansk Gaurav,

What does this query do? It isn't easy to have these run, I have to justify
it and complete forms for our dba group.

It did only delete tasks marked for deletion...the ones with an X next to
the assignment. I still don't understand though...why the tasks in the
project no longer line up with the tasks on the web side? Even with the same
ID number.

We do not use this system to enter time...but we want to use it so manager's
can review which tasks their resources are working on. It has been very
frustrating and I think it most likely will not work.