AGL
Newbie
Karma: 0
Posts: 10
|
 |
« on: August 22, 2008, 11:02:30 am » |
|
Hi! My client wants to delete a Person (not User or Labor) on a Maximo 6.2 142 build, wich doesn't belong to any security groups or whatsoever. We tried to delete that Person too, using a VPN connection, but a error message keeps popping up:
"Attribute PROCESSREV does not exist" - (translated from spanish)
Server OS - Windows 2003 Server R2
Client OS- Windows XP SP2
DB - ORACLE 10.2.1
Application Server Windows 2003 Server R2
Does this ring any bells to any of you?
Muchas Gracias / Thank you
|
|
|
|
|
Logged
|
"Making it all count!!"
|
|
|
|
amdisuk
|
 |
« Reply #1 on: August 22, 2008, 12:07:17 pm » |
|
Not to me. Is this a popup or in the app server console log?
Is there some custom code?
Al
|
|
|
|
|
Logged
|
Big Al
|
|
|
AGL
Newbie
Karma: 0
Posts: 10
|
|
« Reply #2 on: August 22, 2008, 12:24:37 pm » |
|
it's a popup, with no error code... this error is clearly associated with a workflow process, but I can't figure it out...  have you ever had anything similar to this? tnx again |
|
|
|
|
Logged
|
"Making it all count!!"
|
|
|
|
amdisuk
|
|
« Reply #3 on: August 22, 2008, 01:11:02 pm » |
|
OK, if it's a workflow process then there may be a misconfigured action or something. Can you look at the workflow, see where this PROCESSREV exists?
|
|
|
|
|
Logged
|
Big Al
|
|
|
AGL
Newbie
Karma: 0
Posts: 10
|
|
« Reply #4 on: August 22, 2008, 02:14:27 pm » |
|
done, it's a very common process associated with interactions between nodes.  |
|
|
|
|
Logged
|
"Making it all count!!"
|
|
|
AGL
Newbie
Karma: 0
Posts: 10
|
|
« Reply #5 on: August 25, 2008, 02:23:48 pm » |
|
mmm. i guess no one can help me on this.... |
|
|
|
|
Logged
|
"Making it all count!!"
|
|
|
|
maurogrz
|
|
« Reply #6 on: August 25, 2008, 03:27:29 pm » |
|
did you try to "stop WF" if the record is in the workflow ?
the field you described mean the revision of the Workflow process..... maybe the revision referenced by the record is deleted or unavailable ?
|
|
|
|
|
Logged
|
|
|
|
AGL
Newbie
Karma: 0
Posts: 10
|
|
« Reply #7 on: August 26, 2008, 09:11:59 am » |
|
No, I didn't... the problem is that there are a lot of "PROCESSREV"'... I'm having dificulties in identifying the process that originates the error. The Person that we need to delete is not associated to any visible process (no groups or assignments in any workflow)... must be something hidden. Any tips of how to efficiently search for all assignments related to a person? I tried a lot of SQL sentences, and nothing came out...
|
|
|
|
|
Logged
|
"Making it all count!!"
|
|
|
|
maurogrz
|
|
« Reply #8 on: August 26, 2008, 10:52:54 am » |
|
If I'm not too wrong, you can select from WFASSIGNMENT table to get the current workflow assignment of the record.
you have to select values where OWNERID=PERSONID.
From this table you can get WFID, PROCESSID, PROCESSREV and the other assignemt information referencing your record.
Using WFID you can also select values from WFCALLSTACK table to see the current active node (for all the process/subprocess)
Using WFID you can select value from WFTRANSACTION table to have a look of all the workflow nodes passed by your record.
|
|
|
|
|
Logged
|
|
|
|
AGL
Newbie
Karma: 0
Posts: 10
|
|
« Reply #9 on: August 26, 2008, 11:19:38 am » |
|
mmm... I'll try that. Thank you very much!  |
|
|
|
|
Logged
|
"Making it all count!!"
|
|
|
AGL
Newbie
Karma: 0
Posts: 10
|
|
« Reply #10 on: August 26, 2008, 12:38:11 pm » |
|
Problem solved. Person was once a User. The client eliminated the User, but he forgot to disassociate these same User with an active workflow. We sugested him to create a new user for these person, since stopping the worflow process didn't work. After that he simply eliminated both User and Person. Done! Thank you!  |
|
|
|
|
Logged
|
"Making it all count!!"
|
|
|
|
maurogrz
|
|
« Reply #11 on: August 26, 2008, 01:12:49 pm » |
|
Good !
I'm very happy to hear this........
|
|
|
|
|
Logged
|
|
|
|
|
