Recording failed session error messages

[jisoo23]

Hello all,

I'm trying to figure out how I can compile a list of error message generated by recent sessions into a nice neat format...like a target table or even a text file. Specifically I'm looking to record the session name, date/timestamp, and error message that told why it failed. I figure that maybe there's an OPB table that I can read off of to compile this information but I haven't been able to find out which one (I'm rather new to INFA administration). I did a couple of searches and one guy created a handy perl script that combs previously created session logs for errors, but unfortunately for me Perl is out of the question. Any help is appreciated!

Thanks,
Jisoo23

 

[blom0344]

Version 6:

table: OPB_SESS_TASK_LOG

FIRST_ERROR_CODE
FIRST_ERROR_MSG

Ties Blom
Information analyst

 

[jisoo23]

Thanks Ties, I'm working on version 7.1. Hopefully it's the same table there too =)