How to keep rwb audit log more days

[Former Member]

Hi experts,

Simple question. When I access to the audit log in the runtime workbench of messages which are older than one day, the audit log is empty.

Where I can change the days the audit log is keeping the data?

Thank you!

Ignasi

[Former Member · Accepted solution]

Hi Ignasi,

audit log entries of successful processed messages are not saved to database anymore. Check note 1314974:

"The persistence of audit logs for successfully processed may be required for business reasons or performance analysis therefore to revert to the behaviour of previous XI/PI versions (i.e., all message audit logs are persisted to the database) change the value of the Messaging System service -

com.sap.aii.af.ms.svc

property -

messaging.auditLog.memoryCache

from the default

'true'

to

'false'.

(then Modify -> Save -> Restart Messaging Service ** )

The Netweaver Administrator navigation to change the property is -

Configuration Management -> Infrastructure -> Java System Properties -> Services -> XPI Service : Messaging System"

Regards

Markus

[Former Member]

Stored in table XI_AF_MSG in J2EE DB schema (see SAP Note 500340 how to determine table)

Persistence set in Adapter Framework ( Visual Admin) (see SAP Note 791379 for documentation)

Persistence is only valid for NEW Messages. For old messages SQL must be used to change persistence (see SAP Note 790226)

As of SP11 there is a Web Interface to change the retention period (see SAP Note 807615)

Parameters of the Adapter Framework are documented in note 791655

-sekhar

[venkatasap]

HI

May be you should speak with BASIS Admin to reslove the RWB Audit log Issue,as a pi developer i dont think that we can resove this issue.

regards.

Vrma

[Former Member]

Hi Ignasi,

please have a look into your sxmb_adm -> Integration Engine Configuration.

The Parameters you should check are PERSIST_DURATION and PERSIST_DURATION_ERROR.

But be aware that this could cause a growing Database.

kind regards,

Christoph

[Former Member]

Hi Christoph

Last week we set the following parameters but still not working:

ARCHIVE PERSIST_DURATION ASYNC 5 1

ARCHIVE PERSIST_DURATION_UNIT ASYNC D D

DELETION PERSIST_DURATION ASYNC 5 1

DELETION PERSIST_DURATION HISTORY 30 30

DELETION PERSIST_DURATION SYNC 5 0

DELETION PERSIST_DURATION_ERROR SYNC 5 1

DELETION PERSIST_DURATION_ERROR_UNIT SYNC D D

DELETION PERSIST_DURATION_UNIT ASYNC D D

DELETION PERSIST_DURATION_UNIT HISTORY D D

DELETION PERSIST_DURATION_UNIT SYNC D D

What's what we are doing wrong?

Thank you very much!

[Former Member]

Hi,

The above are related to the messages persist parameters but not related to logs of the adapter...

May be one thing which can be helpful is to take the message id of the message in Moni (integration engine) and search for the same in the adapter messaging system for knowing the logs and status of that message in adapter...

AFAIK, there is no parameters for configuring of the logs of the RWB...

HTH

Rajesh

[Former Member]

Hi,

If I look in the WRB with the id i get if the msg is 'successful', 'system error'... but i can't see the audit log. If the message is in the status 'system error' we need to see why they have failed.

I imagine there have to be some way to configure it. We have an XI 7.0 and the audit log is not empty after 24 hours, but we aren't able to see how to configure it with PI 7.10. I have search through nwa but can't see where.

Best regards,

Ignasi

[Former Member]

If it's working fine in your 7.0, you could compare the integration engine parameters and the scheduled jobs in both systems.

Or maybe this can help you:

CSY

[Former Member]

Hi,

You can check the logs for the system errors ,successful messages in Adapter Messaging system...

url for the same is http://host:port/MessagingSystem and provide the filter as Message id ,remember to convert it to lowercase during the filter criteria..and remove date also..

HTH

Rajesh