ASG_TRANSACTION_DETAILS Table

The ASG_TRANSACTION_DETAILS table contains the transaction details of the request and response messages exchanged between the facade operation and target operation of the back-end service. The Central Logger inserts six detail rows for each transaction request.

Note: The ASG_TRANSACTION_DETAILS table is populated only when you enable the detail logging. The detail level logging is set in the ASG_CONFIG_HOME/asg.properties file, using the following property:

tibco.clientVar.ASG/Logging/clLogLevel

Columns of ASG_TRANSACTION_DETAILS Table
Field Name Description
DET_TRN_GUID The reference to the transaction in the ASG_TRANSACTIONS table.
DET_SEQ The sequence order number of the transaction.
DET_TYPE The type of the message. The possible values are:
  • nb.request
  • cn.request
  • sb.request
  • sb.response
  • cn.response
  • nb.response
DET_BODY The body of the request or response payload.
DET_SERVICEURI The Service URI from the HTTP headers of request payload.
DET_SOAPACTION The SOAPAction from the HTTP headers of request payload.
DET_HTTPHEADERS The complete HTTP headers of request payload.
DET_PAYLOAD_SIZE