Problems deleting an assign task in Project Server

[Ricardo]

Hi,

I´m having a problem with my Project Server.

Whenever I assign a task to someone and some time later I remove the
assignment, the task is no longer asigned to anyone and I cannot delete it.
It works like if it´s still assigned to someone. Because of that I have a
couple of tasks that are marked for deletion, but i´m not being able to.

What happens is with others (not all) is that the assigned person does no
longer view the task, but the assigner has the task always in his web
project. Whenever he tries to hide, he gets this error:

"You cannot hide this task for one of the following reasons:
*It´s a delegated task that you are lead for.
*It´s a summary task with existing subtasks.
*It´s a nonproject time task defined by the server administrator
*It´s a task transfered from the Outlook"


And when he tries to reject, he gets this error:

"None of the tasks in your selection can be deleted. Reason:

xxxxxxxxxxxxxx(the name of the task)
This task is only a tracking delegation copy"

How can I erase them?

The deleted task is not an Administrative project.



Does any knows how can I solve this?



Thanks,

 

[Keoni]

Ricardo,

I had something similar to this where I couldn't delete a cancelled task in
a resource's task view in PWA. I found this exerpt on
www.projectserverexperts.com written by Dale A. Howard. Unfortunately, their
site is down right now, so you can't exactly search for this exerpt, but I
had a copy of it. Anyhow, below is Dale's suggestion on what to do. It
worked for me, hopefully it works for you.

[Your Project Server administrator can easily delete completed tasks from
each team member's timesheet in PWA by completing the following steps:

1. Log into PWA with administrator permissions
2. Click the Admin menu
3. Click the Clean up Project Server database link
4. Select the Tasks option
5. Click the Delete drop-down list and select Only completed task
assignments from the list
6. Select the drop-down list on the right and select the desired deletion
option
7. At the bottom of the page, select whether to delete completed tasks for
all resources or a single resource
8. Click the Delete button

If you want to delete cancelled tasks (indicated by the big black X
indicator on each user's timesheet in PWA), a SQL Server DBA can use a query
and a script for this process. Following is a SQL Server Query to see list
of cancelled tasks:

select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME, 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
order by 1

Following is the SQL Server script to delete cancelled task assignments from
PWA timesheets:

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
)

]

 

[Ricardo]

Thank You very much!!!!!!!

It worked fine.


--
Regards,

Ricardo

Ricardo,

I had something similar to this where I couldn't delete a cancelled task in
a resource's task view in PWA. I found this exerpt on
www.projectserverexperts.com written by Dale A. Howard. Unfortunately, their
site is down right now, so you can't exactly search for this exerpt, but I
had a copy of it. Anyhow, below is Dale's suggestion on what to do. It
worked for me, hopefully it works for you.

[Your Project Server administrator can easily delete completed tasks from
each team member's timesheet in PWA by completing the following steps:

1. Log into PWA with administrator permissions
2. Click the Admin menu
3. Click the Clean up Project Server database link
4. Select the Tasks option
5. Click the Delete drop-down list and select Only completed task
assignments from the list
6. Select the drop-down list on the right and select the desired deletion
option
7. At the bottom of the page, select whether to delete completed tasks for
all resources or a single resource
8. Click the Delete button

If you want to delete cancelled tasks (indicated by the big black X
indicator on each user's timesheet in PWA), a SQL Server DBA can use a query
and a script for this process. Following is a SQL Server Query to see list
of cancelled tasks:

select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME, 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
order by 1

Following is the SQL Server script to delete cancelled task assignments from
PWA timesheets:

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
)

]

Hi,

I´m having a problem with my Project Server.

Whenever I assign a task to someone and some time later I remove the
assignment, the task is no longer asigned to anyone and I cannot delete it.
It works like if it´s still assigned to someone. Because of that I have a
couple of tasks that are marked for deletion, but i´m not being able to.

What happens is with others (not all) is that the assigned person does no
longer view the task, but the assigner has the task always in his web
project. Whenever he tries to hide, he gets this error:

"You cannot hide this task for one of the following reasons:
*It´s a delegated task that you are lead for.
*It´s a summary task with existing subtasks.
*It´s a nonproject time task defined by the server administrator
*It´s a task transfered from the Outlook"


And when he tries to reject, he gets this error:

"None of the tasks in your selection can be deleted. Reason:

xxxxxxxxxxxxxx(the name of the task)
This task is only a tracking delegation copy"

How can I erase them?

The deleted task is not an Administrative project.



Does any knows how can I solve this?



Thanks,

 

[Alistair]

Does this process work with Project Server 2007 or only 2003?

I have only seen the scripts below referenced for 2003 and therefore I am
hesitant to apply them to the 2007 system just in case something goes wrong.

Thank you.

Alistair

 

[Ricardo (SA)]

I´ve only tried in Project 2003, not in 2007, so I don´t know the impact in
2007.

 

[Alistair]

Thanks Ricardo.

Hopefully someone can help me answer this question.

 

[Gary L. Chefetz [MVP]]

Alistair:

Perhaps you can be more specific in your question. I can't figure out what
you're asking.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Alistair]

Thanks Gary,

Essentially I am wondering whether there is a way to ensure that a person's
timesheets stay consistent with the tasks assigned in the projects (for
Project Server 2007).

Currently it seems that, with our system, tasks will continue to appear in
someone's timesheets even if they have been removed from that task (ie they
have been taken off the task in the project). This creates an overly complex
"Add Lines" drop down list in the timesheets functionality.

I have seen a few SQL scripts on your website and on this forum that can be
used to clean up these tasks (remove them from the timesheet add lines drop
down list), but they all seem to relate to Project Server 2003. I was
wondering whether these same scripts can be used for Project Server 2007
without causing issues.

Thank you for your help.

 

[Gary L. Chefetz [MVP]]

Alistair,

Tasks remain on the My tasks page for as many days as you set the current
tasks value in PWA. By default, this is 10 days. As long as the task is on
the current view in the My Tasks page, then it populates to the timesheet
when you generate it. You many want to try reducing the current tasks value
to 5, and see if this helps.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Alistair]

Thank you very much. I will give that a go. I did not realise the
relationship between the My Tasks "expiration" and the population of the
timesheets.

Thanks again.