Writing log messages into DB

[Former Member]

Hi

How to write a log message into database instead of writing into file by using SAP xMII Configuration?

Normally SAP xMII provides configuration for writing the log messages into File.But if i want to write into DB, Is there any configuration for doing this or i need to manage manually?

by

Satheesh

[Former Member]

Hi,

as Jeremy told you.

You have to do this manually using SQL Statements. The best thing is if you create your own xMII DB-Logging Project that you can uses then in several xMII Projects as a kind of Common Module.

Ciao

Martin

[Former Member]

Thanks Martin and Jeremy for your valuable inputs.

[jcgood25]

Have you considered an SQL Query template in Command mode...'INSERT INTO....' ?

[Former Member]

I think he meant xMII log messages, which are now logged into an inaccessible abyss with 12.0...

[salvatore_castro]

Here's the easy way to set up a quick view of the xMII Application Logs...

Goto:

http://<server><:port>/nwa

Select:

Monitoring -> Logs and Traces

Enter the following:

Show: Custom View -> <Create New View>

In the filter:

Application -> Contains -> xmii

Severity -> is greater than or equal to -> warning

Save it as xMII Log (Warning Level)

There's also a stand alone log view named logviewer.bat that can be found in the usr directory on the NetWeaver server.

Hope this helps.

Sam

[Former Member]

Sam,

After creating custom view, it does not show log messages logged by Event Viewer. But I do see message like below:, but I don't see the actual message logged by Event Logger.

Severity: info

Date: 2008-01-10

Time: 17:24:05:463

Message:

IP 192.168.1.236 [Administrator] - Mode: Delete; Type: ; sObject: TMPc0d3fe90-bfca-11dc-9897-e5ddc0a801ec

Category: /Applications/XMII/Xacute/Event

Location: com.sap.xmii.Illuminator.logging.AuditLog

Application: sap.com/xapps_xmiiear

User: Administrator

Host: sapdev2

Node: Server 0 0_91095

Thanks,

Sara