I have a scenario to capture all the workflow log information (log file,record count,success,failures,dates etc.......)
Requirement: As soon as any workflow ran(success/failure) in a Particular repository , log info should pass to my target table (XML table)
Note: We should not use OPB tables. If you think that is only the option, in this case you can share your views how to use OPB tables to capture Log information .
Can anyone help me on this please.
Thanks in Advance,
Create a mapping and use the session log file as the src and parse the data to capture all the required details into the table.
PS: We have to Analyze the session log for capturing the required details.
create a assignment task followed by a mapping with session at end of each of your workflow, this is a bit tricky, bcoz 1st you need to assign all the session level parameters or built in parameters to the workflow level parameters(user defined) using assignment task and then asssign all these workflow level paramters to the mapping level paramters using pre session variable assignment of the session .finally use these mapping level paramter to load the control table or whatever target in your case, following information you can get through this.
and even session level information of each session in your workflow.