SOA Governance and API Management : Administering Mediator : Mediator Configurations : Key Performance Indicator Metrics and Run-Time Event Notifications to EDA : Transaction Events Table
Transaction Events Table
Table name: MED_EVENT_TXN
Column
Data Type
Description
EVENT_PK
NUMBER
Sequential primary key. This column will not contain a NULL value.
SESSION_ID
VARCHAR2(128)
Session token. This will be the IS session token or a GUID if the token is missing from the message context.
SERVICE_NAME
VARCHAR2(256)
Virtual service name. This column will not contain a NULL value.
SERVICE_VERSION
VARCHAR2(256)
Version of a virtual service or an API. By default, for every version of a virtual service a system version number is generated. At the same time, user can also provide a version number which is set as a user version.
Note:  
If the version specified by a user is available for the virtual service then this column contains the user version else this column will contain the system version.
OPERATION_NAME
VARCHAR2(256)
Virtual service operation (for example, "invoke" for virtual service connector) hosting the invocation. This column will not contain a NULL value.
BINDING_NAME
VARCHAR2(256)
This column is currently not used.
NATIVE_ENDPOINT
VARCHAR2(4000)
Native service endpoint to which the request has been routed.
TARGET_NAME
VARCHAR2(32)
The target name specified in the Integration Server Administrator's Solutions > Mediator > Administration > CentraSite Communication page.
CONSUMER_NAME
VARCHAR2(128)
Comma-separated consumer names identified based on the policy that triggered the event.
CONSUMER_IP
VARCHAR2(64)
Consumer IP.
CONSUMER_ID
VARCHAR2(256)
The system generated consumer application ID.
STATUS
VARCHAR2(128)
Formatted status based on resource message ID's.
0205.0033=SUCCESS
0205.0034=ERROR {0}
where '{0}' is the fault reason.
RESPONSE
BLOB
BLOB with response data.
REQUEST
BLOB
BLOB with request data.
TOTAL_TIME
NUMBER
Time interval in milliseconds from when a request is received by the virtual service runtime until the response is returned to the caller. This field includes the overhead incurred while the message is passing through the Mediator runtime.
PROVIDER_TIME
NUMBER
Time interval in milliseconds from when Mediator forwards a request to the native provider until it receives the provider's response. This field includes the time it takes a provider to process the request plus any network latency to/from the provider. This field is a better indicator of the time it takes for a provider to process a request and return a response. Subtracting total time from provider time must give a rough indicator of the Mediator overhead.
INSERTTIMESTAMP
TIMESTAMP(6)
Timestamp when the event is persisted to table.
AUDITTIMESTAMP
TIMESTAMP(6)
Timestamp when the event was created by the virtual service runtime.
ROOTCONTEXTID
CHAR(36)
This column is not used by EDA.
PARENTCONTEXTID
CHAR(36)
This column is not used by EDA.
CONTEXTID
CHAR(36)
This column is not used by EDA.
MSGID
CHAR(36)
This column is not used by EDA.
PARTNER_ID
VARCHAR2(256)
This column is not used by EDA.
SERVERID
VARCHAR2(450)
This column is not used by EDA.
EVENT_CREATE_TS
TIMESTAMP(6)
Timestamp when the event was created by the virtual service runtime. This is not the time the database performed its insert (for example, this is calculated by the Mediator policy engine and not a database function).
EVENT_USERNAME
VARCHAR2(256)
Integration Server always provides a value, even if anonymous. 80 is the size of user in IS_USER_TASKS table. This column will not contain a NULL value.
EVENT_SOURCE
VARCHAR2(256)
Policy name that produced the event.
TOTAL_DATA_SIZE
NUMBER
Combined request and response payload sizes.
Copyright © 2015- 2016 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback