| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Audit information to Oracle Table |
« View previous topic :: View next topic » |
| Author |
Message
|
| ecarico |
 Posted: Fri May 20, 2005 10:44 am Post subject: Audit information to Oracle Table |
 |
|
Novice
Joined: 18 Aug 2004
Posts: 10
|
| We need to know the contents of the output container for every activity that we have. For Problem Resolution, we have created our own tables in Oracle, as well as a program to log this information, instead of using the Audit Trail. However, in Buildtime, do I have to create an "Audit" activity for every activity that we have? In other words, is there a way to create one "Audit" activity that messages route to every time they leave a queue? Or, is there another way to send output container information to an Oracle table? Hope this makes sense! |
|
| Back to top |
|
 |
| jmac |
| Posted: Fri May 20, 2005 1:49 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
If you are only doing this for Problem resolution, I would suggest another approach. Simply change the interval for "Keep finished" instances and processes to 1 day. Then you can get the information you want by querying the activity instances for any given instance.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| ecarico |
| Posted: Mon May 23, 2005 8:01 am Post subject: |
|
|
Novice
Joined: 18 Aug 2004
Posts: 10
|
| Sorry, I probably did not make myself clear in my original post. We have a UPES program that updates Oracle audit tables between activities, which includes container data as well as custom data. When the UPES activity fails, it sends to a "retry" UPES activity where it runs the same program over again. Since I want output container data stored in the table after every activity in our entire process, do I have to create an "audit" activity and a "retry" activity for every processing "activity" we have? Or, is there another way to do this. Also, please elaborate on the "Keep Finished" resolution you posted. What would I be querying? The audit trail to get the container values? |
|
| Back to top |
|
|
| jmac |
| Posted: Mon May 23, 2005 8:16 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
If you need the data "as each activity completes" to be updated in your DB then I think you have no choice, but to duplicate your UPES activity.
If you only need to have the data for "finished" process instances, or in casses where you need to do some problem solving you can use the fact that the ActivityInstances for a given process instance contain all of the input and output containers. I really don't know exactly what your requirement is, so it is difficult to know how to solve the problem. It is a pretty simple matter to get the activityInstances and look at the output containers for all of the activities. You could have a single upes at the end that would do this query for you and update your table. In addition you could have a utility that invokes the same code, and produce the output containers any time you wanted, as long as the Process was still in the RTDB.
_________________
John McDonald
RETIRED |
|
| 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
|
|
|
|
