| Author |
Message
|
| sujitsahu |
 Posted: Mon Apr 23, 2007 7:25 am Post subject: Deleting Process Instance |
 |
|
Newbie
Joined: 05 Mar 2007
Posts: 8
|
I am facing a small issue.
I have many process instances whose state is in undefined state.
I tried terminating,deleting ,restarting,nothing happens.
I want to get rid of these process instances ASAP.
Let me know if there is some other way of undating there state in workflow database and calling the terminate API. |
|
| Back to top |
|
 |
| sujitsahu |
| Posted: Mon Apr 23, 2007 7:29 am Post subject: Deleting Process Instance |
|
|
Newbie
Joined: 05 Mar 2007
Posts: 8
|
Little change to my question.
The process Instances are in INACTIVE state,though we never suspended these proceses. |
|
| Back to top |
|
|
| jmac |
| Posted: Mon Apr 23, 2007 10:32 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I am a little confused... I don't believe there is a Process Instance state of Inactive, there is a Workitem/ActivityInstance state of Inactive, but to my knowledge there is no such ProcessInstance state.
Are you certain you are looking at a ProcessInstance?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| vijaycr |
| Posted: Mon Apr 23, 2007 10:43 pm Post subject: |
|
|
Acolyte
Joined: 11 Oct 2006
Posts: 62
Location: Singapore
|
Possible State Values are :
| Quote: |
NotSet = 0,
Ready = 1, Running = 2, Finished = 4,
Terminated = 8, Suspended = 16,
Terminating = 32,Suspending = 64,
Deleted = 128 |
What do you find for these processes in the state column of PROCESS_INST table? |
|
| Back to top |
|
|
| sujitsahu |
| Posted: Mon Apr 23, 2007 11:27 pm Post subject: |
|
|
Newbie
Joined: 05 Mar 2007
Posts: 8
|
I will tell you the main cause.
We have a main process and there is some sub process inside the main.
Due to some reason the creation of sub process went into endless loop and for one process we had 2000 subprocesses,
Finally we decided to terminate this process from the production environment,but while doing so we are not able to do anything.
I queried the processInst table with top_level_name and found for process and subprocess the state value is 32(terminating).
Though i see nothing is getting terminated from past 2 hours |
|
| Back to top |
|
|
| sujitsahu |
| Posted: Mon Apr 23, 2007 11:37 pm Post subject: |
|
|
Newbie
Joined: 05 Mar 2007
Posts: 8
|
I will tell you the main cause.
We have a main process and there is some sub process inside the main.
Due to some reason the creation of sub process went into endless loop and for one process we had 2000 subprocesses,
Finally we decided to terminate this process from the production environment,but while doing so we are not able to do anything.
I queried the processInst table with top_level_name and found for process and subprocess the state value is 32(terminating).
Though i see nothing is getting terminated from past 2 hours |
|
| Back to top |
|
|
|
|
