| Author |
Message
|
| MaheshPN |
 Posted: Thu May 22, 2003 4:47 pm Post subject: Can i Get Container Data? |
 |
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Hi,
For monitoring perpose I am using Audit trial data. Along with that i need know the data that was entered at each activity level(container data) so that I can take it for forther calculation.
Could some body please tell me which table I must use to get process instace's activity data??
Thanks,
Mahesh |
|
| Back to top |
|
 |
| Ratan |
| Posted: Thu May 22, 2003 5:06 pm Post subject: |
|
|
Grand Master
Joined: 18 Jul 2002
Posts: 1245
|
This depends on your process instance duration settings. If you can get the container data if the Process instance is still in your DB ( that is if the process is still in the running state or if you specified a duration to keep it in your DB).
You can use the API calls to get a handle of the processinstance and then accesss an activity instance and retrieve its container data. If you have any difficulty with the API calls, post it.
_________________
-Ratan |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Thu May 22, 2003 6:12 pm Post subject: Can i Get Container Data? |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Thanks Ratan,
I have problem like I want the summary of how many processes (completed and running) had order amount > 1000 and who performed one specific task. The user detail can be found in the audit trail.
I have used the API to put and get the data from the container while running a task. Is it the same? If u have some good stuff on monitoring including API's please send it to me.
Thanks
mahesh |
|
| Back to top |
|
|
| jmac |
| Posted: Fri May 23, 2003 6:19 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Mahesh:
You might want to look into WBI Modeler/Monitor it does exactly what you want
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Fri May 23, 2003 10:06 am Post subject: Can i Get Container Data? |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
I am using monitor for some purpose. The requirement for which i am looking at cannot be achived by monitor since there we have to create business measures and I can aggregate only the completed process.
I feel we may need to write our own JSP pages using API's provided by holosofx to achieve this. Does anybody explored the API's of holosofx I need some samples.
Thanks
mahesh |
|
| Back to top |
|
|
| jmac |
| Posted: Fri May 23, 2003 10:15 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Mahesh:
You might want to inquire of IBM as to whether or not they are fixing that. I am led to believe that this is an issue that is being worked on.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Fri May 23, 2003 11:25 am Post subject: Can i Get Container Data? |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Thanks jmac,
I am trying to get the work done by using Global container, as its data can be accessed in audit trail. I will try putting the required data in Global container and retrieve from auditdb for my queries.
Hope it will work!!!
----------------------
Mahesh
IBM Certified Solution Expert - MQWorkflow |
|
| Back to top |
|
|
| jmac |
| Posted: Fri May 23, 2003 11:42 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Mahesh:
You will find that the Global Container stores the container as some type of blob.
If you are using the Audit to MQ, it shows up nice and pretty... I don't believe I've ever seen it documented how to process the container info thats in the Audit DB record.
PLEASE post the method you use to access this.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| MaheshPN |
| Posted: Fri May 23, 2003 12:05 pm Post subject: Can i Get Container Data? |
|
|
Master
Joined: 21 May 2003
Posts: 245
Location: Charlotte, NC
|
Yes jmac,
You are right. I thought of using it, now it seems to be difficult.
We may need to think of some solution 
Mahesh |
|
| Back to top |
|
|
|
|
