ASG_TRANSACTIONS Table
The ASG_TRANSACTIONS table contains the basic statistics such as facade operation name, target operation name, routing key, the name of the Core Engine for each request. The Central Logger inserts one transaction record for each request in this table.
| Field Name | Description |
|---|---|
| TRN_GUID |
The primary key as an unique reference for the transaction. GUID is generated automatically by the Central Logger component. |
| TRN_TIMESTAMP | The time of the request. |
| TRN_SITE |
The site name which accepts the request. You can use different gateway sites or environments for TIBCO API Exchange Gateway product. The value for the TRN_SITE field is populated from the Common/Deployments/SiteNumber global variable defined in the ASG_CONFIG_HOME/asg_cl.properties file. The default value of Common/Deployments/SiteNumber is 1. Note: For 1.2.x release, the value for the TRN_SITE field is populated from the CL/Logging/siteNumber global variable defined in the ASG_CONFIG_HOME/asg_cl.properties file. |
| TRN_ENGINE | The name of the engine which processes the transaction request.
You can assign different engine names when starting the Gateway core engine. The engine name can be specified using -n parameter to asg-engine command on the command line. |
| TRN_SOURCE | The partner name, such as anon, who is the requestor of the operation. |
| TRN_TARGET | The value returned from the OpCo field of the parsing step of the request processing. |
| TRN_FACADE_OPERATION | The facade operation name. |
| TRN_FACADE_SERVICE | The facade service name. Not currently used, might be used in future. |
| TRN_ROUTING_KEY | The evaluated routing key used to determine the target operation. |
| TRN_TARGET_OPERATION | The target operation name or the target operation group. |
| TRN_TARGET_SERVICE | The target service name. Not currently used, might be used in future. |
| TRN_TRANSACTION_ID | The transaction id passed with the request. |
| TRN_FACADE_I_TIME | The ingress (reception) time (in milliseconds) for the facade operation message. |
| TRN_ROUTER_I_TIME | The egress (emission) time (in milliseconds) for the first target operation message. |
| TRN_FACADE_E_TIME | The egress (emission) time (in milliseconds) for the northbound message. |
| TRN_ROUTER_E_TIME | The (reception) time (in milliseconds) for the last target operation message. |
| TRN_FACADE_DURATION | The total time (in milliseconds) spent in the gateway. |
| TRN_ROUTER_DURATION | The total time (in milliseconds) waiting for the response from the back-end service (target operation). |
| TRN_STATUS | The completion status of the transaction. |
| TRN_ERROR_CODE | The error code for the transaction, if the transaction finished with error. |
| TRN_ERROR_MESSAGE | The error message for the transaction, if the transaction finished with error. |
| TRN_APP_ID | The application ID. |
| TRN_APP_NAME | The name of the application. |
| TRN_PRODUCT_ID | The product ID. |
| TRN_PRODUCT_NAME | The name of the product. |
| TRN_PARTNER_ID | The ID of the partner. |
| TRN_CORRELATION_ID | The correlation id of the request message. |
| TRN_REQUEST_PAYLOAD_SIZE | |
| TRN_RESPONSE_PAYLOAD_SIZE |