BC_MSG_LOG growing...

[Former Member]

Hi,

we are using Pi 7.31 and table BC_MSG_LOG keeps growing. We have set property messaging.log.retainTime to 3 of service XPI Service: Messaging System to  3 days but messages keep on being logged in PI. We look in the table BC_MSG and messages seem to be flagged for delete only after 7 days.

We also have property  xiadapter.logger.conf  of service XPI Adapter: XI  set to MS=3,AM=3

How can we have synchronous messages in Java stack deleted before 7 days ?

Thank you.

[former_member182742]

Synchronous messages are only logged in BC_MSG_LOG without a corresponding entry in BC_MSG table. Therefore these entries have their own retention period specified in parameter "messaging.log.retainTime" under service XPI Service: Messaging System. The value specified here is in days and by default these logged message versions are persisted for 7 days. The logged versions of synchronous messages will also be deleted by the standard PI message deletion job and no additional job has to be scheduled.

If you would like to have synchronous messages in Java stack deleted before 7 days, for example, 3 days, you can reduce the value of parameter "messaging.log.retainTime". After that please resatrt the j2ee engine to make the change to take effect.

[markus_schalk]

Dear Thierry,

we changed the parameter messaging.log.retainTime from 7 to 14 days. No change in behaviour.

But after a system restart a few weeks after, the parameter works now. Hence, it is not online modifiable and needs a restart.

According to SAP support, this should be fixed with SAP Note 2218407.

Best regards,

Markus

[sewoon_oh]

Hi.

Probably, message with status (error) of BC_MSG_LOG table are not deleted automatically by schedule job.

Error messages should be "cancel" in Message Monitoring and then message will be deleted automatically when next deletion schedule job is execute or executing schedule job manually.

Regards,

Sewoon

[ambrish_mishra]

Hi,

please check this link

http://help.sap.com/SAPHELP_470/Helpdata/EN/0e/80553b4d53273de10000000a114084/content.htm

Ambrish