Message Log
The message log is used by a number of processes to provide debugging and troubleshooting information. You can view the message log from the process monitor after clicking on the details hyperlink for a process and the by clicking on the message log hyperlink in the actions area.
You may occasionally want to query the information in the message log. To do this there two tables that you need to use:
PS_MESSAGE_LOGPS_MESSAGE_LOGPARM
You can use the following query to get the message log data for a given process instance:
select
ML.DTTM_STAMP_SEC,
ML.JOBID,
ML.PROGRAM_NAME,
ML.MESSAGE_SET_NBR,
ML.MESSAGE_NBR,
MLP.PARM_SEQ,
MLP.MESSAGE_PARM
from
PS_MESSAGE_LOG ML inner join PS_MESSAGE_LOGPARM MLP
on ML.PROCESS_INSTANCE = MLP.PROCESS_INSTANCE
and ML.MESSAGE_SEQ = MLP.MESSAGE_SEQ
where
ML.PROCESS_INSTANCE = 'PROCESS_INSTANCE'
You can write to the message log with an Application Engine by simply using the log message action or by using the MessageBox function in PeopleCode.
No Comments