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 |
|
 |
|