| Author |
Message
|
| ajomillar |
 Posted: Fri May 14, 2004 1:53 pm Post subject: Process_State Values in Work_Item table |
 |
|
Centurion
Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI
|
I am troubleshooting Workflow v3.4 running in AIX 5.2 by looking at the Work_item table. There are 2765 work items: 5 of the records have Process_State=2, the rest are Process_State=128. What does these values mean?
I'm also seeing the following error:
| Code: |
| > 05/14/04 16:48:53 FMCSYS: FMC12310E The cleanup server for system FMCSYS is not responding to control requests. |
So the records flagged for deletion remain in the runtime db.
Any thoughts? |
|
| Back to top |
|
 |
| jmac |
| Posted: Fri May 14, 2004 5:02 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I am not sure if the values in the tables are documented anywhere. You could easily figure this out by simply displaying a workitem with the standard client, and noting its process state.
If you compile a list of these values please publish it here.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| manoj |
| Posted: Sat May 15, 2004 9:29 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
i think the state values(constants) in the database is different when you get it using the API...i guess there is a mapping at the C++ layer..
_________________
-manoj |
|
| Back to top |
|
|
| amittalekar |
| Posted: Wed May 19, 2004 11:20 am Post subject: |
|
|
Disciple
Joined: 03 Apr 2002
Posts: 166
Location: VA, USA
|
Process_State=2 :- RUNNING
Process_State=128 :- DELETED (will be chosen by cleanup server to cleanup)
Rebind the database and run cleanup server again. |
|
| Back to top |
|
|
| CHF |
| Posted: Thu May 20, 2004 6:20 am Post subject: |
|
|
Master
Joined: 16 Dec 2003
Posts: 297
|
| Quote: |
| 5 of the records have Process_State=2, the rest are Process_State=128. What does these values mean? |
Do a search for "fmcjcrun.h" file in your IBM WebSphere MQ Workflow installation directory. This file has all the values that WF stores for Process instances, workitems, etc... in DB.
C:\Program Files\IBM WebSphere MQ Workflow\API\fmcjcrun.h
Thanks
CHF  |
|
| Back to top |
|
|
|
|
