| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Accessing container data after complete, audit info |
« View previous topic :: View next topic » |
| Author |
Message
|
| david_sorrento |
 Posted: Tue Nov 12, 2002 8:49 am Post subject: Accessing container data after complete, audit info |
 |
|
Newbie
Joined: 12 Nov 2002
Posts: 8
Location: Dublin, Ireland
|
Hi,
There are 2 parts (kind of) to this question:
1.
I am wondering if it is possible to access items that were held in the data container of a process instance once it has completed. Is this data dumped or does it get recorded somewhere in the database?
If it is too tricky or un-reliable to get the data from the MQWF database, I am going to write the data I want to keep to one of my own application tables.
which leads me to part 2...
I am naming my process instances with a more meaningful ID than is automatically given it by runtime, so instead of for example 'VwAAAAEAHIEWAAAAAAAAAABX', I will give it a number from a sequence in Oracle e.g. 12345.
In my application I need to be able to access historic items that have been completed (hence keeping some of the data in part one above). Are there API's for accessing data in the MQWF Audit tables (I have audit switched on for process) ? If I have to go direct to the tables I'll use my Workitem ID (e.g. 12345) that I've kept track off and use this to retrieve rows from audit.
Things I need from Audit are 'Work item history', so what stages a process went through, who performed tasks, how long did they take - that sort of thing.
Any thoughts or comments appreciated.
thanks,
David |
|
| Back to top |
|
 |
| jmac |
| Posted: Tue Nov 12, 2002 9:44 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
David:
You can get at the data in the Input and Output containers of all of the Activities in a Process Instance as long as the Process Instance is still in the database. You do this using the InstanceMonitor object to access the ActivityInstance array of objects. I don't think it's too tricky... If I had to archive this information, I would probably consider a final activity that is a UPES that would go out and access the information and store it someplace more permanent that the MQWF control DB.
There are no API's to go against the Audit Trail. One thing you should consider is using the Audit to MQ facility (possibly with filtering) to have all of your audit records written to a queue, which you could then process and build your own historical repository.
GOOD LUCK
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| david_sorrento |
| Posted: Tue Nov 12, 2002 10:21 am Post subject: |
|
|
Newbie
Joined: 12 Nov 2002
Posts: 8
Location: Dublin, Ireland
|
thanks John, I was thinking along those lines - i.e. archiving data to a table on my application database.
Do you know where I can get more info on setting up the Audit to MQ facility?
David |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Nov 12, 2002 11:32 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
David:
I would start with Chapter 5 of the Admin Guide... And if you need to see the specific FDL you need to add There is an appendix in some of the manuals that shows the full FDL syntax.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| david_sorrento |
| Posted: Wed Nov 13, 2002 12:39 am Post subject: |
|
|
Newbie
Joined: 12 Nov 2002
Posts: 8
Location: Dublin, Ireland
|
ah yes.... read the manual David  !
thanks for your help John |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
