Data Description

The MSS_DB02_ELOG event is used in SAP to view the error log for a Microsoft SQL database.

Potential Use Cases

This event could be used in the following scenarios:

  • Alert on specific database errors.

  • Correlate the database errors with other performance issues in the environment.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

Log into the managed system and execute the dbacockpit transaction code. Expand the Diagnostics menu option on the left side of the screen and double-click SQL Error Logs option. The information displayed will match the data that is extracted and sent to Splunk.

Field Mapping

Field

Description

Unit of Measure

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

EVENT_SUBTYPE

String

EVENT_TYPE

MSS_DB02_ELOG

String

OFFSET

Natural Number

Number

PROCESS

Process ID

String

SEQNO

Natural Number

Number

TEXT

Message text

String

UTCDIFF

The UTC OFFSSET in HHMMSS that the data was collected in

HHMMSS

UTCSIGN

The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.

+ | -