![](/images/new-backgrounds/1300197/300197111x1.webp)
Database Logging
Table 4–2 Contents of the ptg_service_log Table
Column Name | Description |
|
|
service_id | Object Identifier (OID) for the invoked service. |
service_name | Name of the invoked service. |
ptg_instance_id | Unique identifier, for the database instance. |
final_service_id | OID of the final service, for example the master service or folder. |
final_service_name | Name of the final service. |
session_id | Session identifier for which the service was invoked. |
service_arguments | Arguments of the service, in XML format. |
bookmark | External link, if the invoked service is a bookmark. |
service_type | Type of service. |
invocation_hour | Hour when the service was invoked. |
invocation_time | Date when the service was invoked. |
response_time | Response time for the service. |
request_status | Status of the request, a |
| number. |
error_description | Error message, if one occurred while invoking the service. |
user_id | OID for the user. |
user_name | Name of the user. |
remote_address | Host IP address and name. |
logical_device | Logical device which invoked the service. |
external_user_id | External user ID. |
external_user_name | External user name. |
adapter_type | Type of adapter. |
adapter_home | Time taken by the adapter. |
transformation_time | Time taken by the transformer. |
timestamp | Time when the data is logged. |
|
|