Clear error logs(messages) in DOE.

[former_member185875]

Dear all,

I have configure the "Message Store and Log Reorganization" job with variant Days to hold = '10' every day 4:00am in sdoe_bg_job_monitor. But in "SMMW_MSG_HDR" table contain 9750868 entries because of this I have some doubts

Is the entries in the table are valid or invalid?

how can i validate?

i need to configure any other jobs to delete entries form the table "SMMW_MSG_HDR"?

and because of these 'message monitoring' in doe admin portal take log time show error messages.

Regards

lakshman balanagu

Edited by: lakshman balanagu on Sep 17, 2010 11:51 AM

[rohith_deraje]

Hi Lakshman.

Please check if your problem is same as the one mentioned in note "1325684: Logs cleanup report not working properly for large"

Also check note :"1476959: Message Reorg report not deleting entries".

Regards

Rohith

Edited by: Rohith Deraje on Sep 24, 2010 11:09 AM