| Author |
Message
|
| Srinip |
 Posted: Tue Oct 25, 2005 7:02 am Post subject: how to delete the person who owns work items |
 |
|
Newbie
Joined: 24 Oct 2005
Posts: 5
|
i was trying to delete the person who owns 16 work items i received the following errors
FMC25700E delete.fdl(14):DELETE cannot be performed for PERSON N'XXXXXX'. The PERSON owns 16 work items.
_________________
srini |
|
| Back to top |
|
 |
| jmac |
| Posted: Tue Oct 25, 2005 7:14 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Yep... working as designed.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| Srinip |
| Posted: Tue Oct 25, 2005 7:25 am Post subject: |
|
|
Newbie
Joined: 24 Oct 2005
Posts: 5
|
can any one send the procedure to delete a person who owns the work items.
_________________
srini |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Oct 25, 2005 7:38 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
If you can't delete the person because the person owns the workitems, then maybe if the person no longer owns the workitems you will be able to delete them.... Have you ever looked at the API?
I would suggest doing a transfer of the workitems to another user, or maybe just deleting the workitems if they are available to other users.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| vinoth |
| Posted: Tue Oct 25, 2005 10:48 pm Post subject: |
|
|
Apprentice
Joined: 03 Mar 2005
Posts: 31
|
Hi,
Simple thing is to delete the rows for the userid in the DB2 table WORKITEMS,and the follow the procedure to delete the userid.
Vinoth |
|
| Back to top |
|
|
| hos |
| Posted: Wed Oct 26, 2005 12:18 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
|
| Back to top |
|
|
| jmac |
| Posted: Wed Oct 26, 2005 5:20 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| vinoth wrote: |
Hi,
Simple thing is to delete the rows for the userid in the DB2 table WORKITEMS,and the follow the procedure to delete the userid.
Vinoth |
I will second Volker's answer. DO NOT DELETE ROWS FROM ANY MQWF TABLE....
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| kotha |
| Posted: Wed Oct 26, 2005 7:12 pm Post subject: |
|
|
Partisan
Joined: 12 Mar 2005
Posts: 333
|
| Why do you bother???. Login as Admin and transfer the items to admin's list then delete it him forever!!!. Or login as admin and change that user password and login as that user and and do whatever you want. concider the impact if the product is already in production. |
|
| Back to top |
|
|
| hos |
| Posted: Wed Oct 26, 2005 11:31 pm Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
Hi,
please have a look at the Substitute Person Tool described in the Administration Guide. |
|
| Back to top |
|
|
|
|
