Skip to main content

Managing the Applications Lifecycle

 

OutSystems

Log data reference

This document lists the fields and descriptions of the database views associated with the platform log records. The views are built on top of the database tables.

Request Event

Purpose Log of application events as generated by the Performance Monitoring system (as documented [here](https://success.outsystems.com/Docum...Monitoring_API)) in web application or responsive (mobile) web applications.
Database view name oslog_RequestEvent
OutSystems entity name (System).Log_RequestEvent
Field Description Data type Mapped Entity
Instant Date and time when the event occurred in the front-end (server log) or in the mobile device (client log). Date Time
Request_Key Correlation field of the several log types to a single request. GUID
RequestEventName The name of the event. Text
ModuleKey Unique identifier of the module where the event occurred. Text (System).eSpace
ModuleName Name of the module where the event occurred. Text (System).eSpace
ApplicationKey Unique identifier of the application where the event occurred. Text
ApplicationName Name of the application where the event occurred. Text
EventDetails A JSON object with the details about the event. Each built-in request event has its own details: WebScreenClientExecuted; WebScreenServerExecuted; QueryExecuted; ConsumedIntegrationExecuted; ExtensionExecuted. Text
Cycle ID [0-9] of the table from which the log is being read. Int

Error

Purpose Log of application, environment and native mobile errors.
Database view name oslog_Error
OutSystems entity name (System).Log_Error
Field Description Data type Mapped Entity
Id Unique identifier of the error message. GUID
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Session_Id User Session Identifier Text ASP.NET_SessionId
User_Id User identifier. 0 if no user logged in (anonymous navigation). Int (System).User
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).eSpace
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Message Error message logged by the application / OutSystems services. Text
Stack Error stack logged by the application / OutSystems service. Instructions for reading [here](https://www.outsystems.com/forums/di...s-error-stack/). Text
Module_Name Label used to identify specific types of error messages. Text
Server Front-end server that originated the error (server log) or empty (client log). Text n/a. List of servers can be obtained from (System).Server
Cycle ID [0-9] of the table from which the log is being read. Int
Environment Information Detailed low-level information on environmental context of the application (eSpaceVer, RequestUrl, AppDomain, Path, Locale, DateFormat, PID, TID, Thread Name and .NET version). Text
Request_key Correlation field of the several log types to a single request. GUID n/a. Can be used to connect other log entries in multiple log types (via request_key fields).
Entrypoint_ Name The name of the web screen that was handling the request. Text
Action_Name The name of the action that was handling the request. Actions include the Preparation action and Screen Actions. Note: If the web screen does not have a Preparation action, or if a cached version was served, then the ActionName is "(PageRender)". Text

Error Detail

Purpose Detailed log of application, environment and native mobile errors.
Database view name oslog_Error_Detail
OutSystems entity name n/a
Field Description Data type Mapped Entity
Id Unique identifier of the error message. GUID (System).Log_Error
FullStackTrace Detailed stack trace that is used for larger stack traces (more than 2000 chars). Text

General

Purpose Logs generated by audits, slow SQL and native mobile warnings.
Database view name oslog_General
OutSystems entity name (System).Log_General
Field Description Data type Mapped Entity
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Session_Id User Session Identifier Text
User_Id User identifier. 0 if no user logged in (anonymous navigation). Int (System).User
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Error_Id Identifier of the related error log. Correlation with the Error Log table. Text (System).Log_Error
Message Log message Text
Message_Type Message type Text
Module_Name Name of the originating module. Correlation with the Error Log table. Information regarding Slow calls (SLOWSQL, SLOWEXTENSION). Text
Cycle ID [0-9] of the table from which the log is being read. Int
Request_Key Key of the request that originated the log. Correlation field of the several log types to a single request. GUID
Action_Name Name of the action being called. Text
Entrypoint_Name Name of the entry point being called. Text
Client_IP Client IP address. Text

Screen

Purpose Screen usage logs (web and web/responsive applications).
Database view name oslog_Screen
OutSystems entity name (System).Log_Screen
Field Description Data type Mapped Entity
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Duration Duration of the request, as measured on the server side, in milliseconds. Int
Screen Name of the screen as declared in the eSpace where it is present. For SMS Flows, name of the SMS Node. Text
Session_Id User Session Identifier Text
User_Id User identifier. 0 if no user logged in (anonymous navigation). Int (System).User
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Msisdn Cell phone number if screen belongs to a SMS flow. Text
Screen_Type Type of screen (WEB, MOBILE). Text
Cycle ID [0-9] of the table from which the log is being read. Int
Executed_By Front-end server that originated the log. Text n/a. List of servers can be obtained from (System).Server
Session_Bytes Size of the session associated with this request, in bytes, at the beginning of the request. Int
Viewstate_Bytes Size of the viewstate associated with this request. 0 if the request has no viewstate (GET); greater than 0 if the request is a POST or AJAX request. Int
Session_Requests Number of requests to user session. Int
Access_Mode Type of web request access (AJAX, SCREEN). Text
Request_Key Key of the request that originated the log. Correlation field of the several log types to a single request. GUID
Action_Name Name of the action being called Text
Client_IP IP of the end-user as identified by the platform. This the client IP, if there is a X-FORWARD it appears with the first (Client) and last IP (last proxy IP). Text

Integration

Purpose Logs built-in integrations (SOAP and REST).
Database view name oslog_Integration
OutSystems entity name (System).Log_Integration
Field Description Data type Mapped Entity
Id Unique identifier of the error message. Text
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Duration Duration of the execution of the integration, in milliseconds. For CONSUME type, this is the time from the beginning of the request to the external system until the response finished transmission to the platform; for EXPOSE type, this is the time from the beginning of execution on the platform until end of transmission to the external system. Int
Source Empty / meaningless for CONSUME type; for EXPOSE type this is the source IP of the external system. Text
Endpoint For CONSUME type this is the URL of the external system; empty / meaningless for EXPOSE type. Text
Action Name of the service and action being consumed / exposed. For SOAP (CONSUME), in the form of <service> (<method> For all other types, in the form of <service>.<method>. Text
Type One of: SOAP (Consume); SOAP (Expose); REST (Consume); REST (Expose). Text
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Error_Id Correlation with the Error Log table. Text (System).Log_Error
Executed_By Front-end server that served the service (EXPOSE) or that called the external system (CONSUME). Text
Cycle ID [0-9] of the table from which the log is being read. Int
Is_Expose True if log refers to an integration being exposed. False if calling an integration. Bool
Request_Key Key of the request that originated the log. Correlation field of the several log types to a single request. Text

Integration Detail

Purpose Detail logs of built-in integrations (SOAP and REST).
Database view name oslog_Int_Detail
OutSystems entity name (System).Log_Integration_Detail
Field Description Data type Mapped Entity
Id Unique identifier of the error message. text (System).Integration
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Message Short log information. Text
Detail Detailed log information. Text
DetailLabel Informative label about what is being logged. Text
Cyle ID [0-9] of the table from which the log is being read. Int

Web Reference (legacy)

Purpose Logs of SOAP integration calls from the OutSystems platform to external systems. This view exists for legacy reasons only. Logs in this view are extracted from the Integration log tables; the same information can be consulted in the Integration views.
Database view name oslog_Web_Reference
OutSystems entity name (System).Log_Web_Reference
Field Description Data type Mapped Entity
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Duration Time from the beginning of the request to the external system until the response finished transmission to the platform. Int
URL URL of the external system. Text
Method Name of the service and action being consumed. Text
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Executed_By Front-end server that originated the log. Text n/a. List of servers can be obtained from (System).Server
Error_Id Correlation with the Error Log table. Int (System).Log_Error
IntegrationLog_Id ID to the related integrationLog table row. Int (System).Log_Integration
Cycle ID [0-9] of the table from which the log is being read. Int

Web Service (legacy)

Purpose Logs of SOAP integration calls from external systems to the OutSystems platform. This view exists for legacy reasons only. Logs in this view are extracted from the Integration log tables; the same information can be consulted in the Integration views.
Database view name oslog_Web_Service
OutSystems entity name (System).Log_Web_Service
Field Description Data type Mapped Entity
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Duration This is the time from the beginning of execution on the platform until end of transmission to the external system. Int
Name Name of the web service exposed. Text
Method Name of the service and action being exposed. Text
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Client_IP IP of the client that invoked the service action. Text
Executed_By Front-end server that originated the log. Text n/a. List of servers can be obtained from (System).Server
Error_Id Correlation with the Error Log table. Int (System).Log_Error
Cycle ID [0-9] of the table from which the log is being read. int

Cyclic Job

Purpose Logs of Timer executions
Database view name oslog_Cyclic_Job
OutSystems entity name (System).Log_Cyclic_Job
Field Description Data type Mapped Entity
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Duration Duration, in seconds, of the execution of the job. Int
Cyclic_Job_Key Unique identifier of the cyclic job that was executed. GUID (System).Cyclic_Job
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Executed_By Front-end server that originated the log. Text n/a. List of servers can be obtained from (System).Server
Error_Id Correlation with the Error Log table Text (System).Log_Error
Should_Have_Run_At Scheduled time for execution of this cyclic job. Instant of execution is expected to be equal or bigger than this field. Date Time
Next_Run Schedule for next run Date Time
Cycle ID [0-9] of the table from which the log is being read. Int
Request_Key Correlation field of the several log types to a single request. GUID

Extension

Purpose Logs of the integration calls implemented as [custom code / Extensions](https://success.outsystems.com/Docum...ode/Extensions)
Database view name oslog_Extension
OutSystems entity name (System).Log_Extension
Field Description Data type Mapped Entity
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Duration Time in seconds the extension call took. Int
Action_Name Name of the action being called. Text
Session_Id User Session Identifier. Text
User_Id User identifier. 0 if no user logged in (anonymous navigation). Int (System).User
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Extension_Id Extension from where the log was originated. Int (System).Extension
Executed_By Front-end server that originated the log. Text n/a. List of servers can be obtained from (System).Server
Error_Id Identifier of the related error log. Text (System).Log_Error
Cycle ID [0-9] of the table from which the log is being read. Int
Request_Key Correlation field of the several log types to a single request. GUID

Mobile Request

Purpose Logs of mobile applications requests to the back-end endpoints.
Database view name oslog_Mobile_Request
OutSystems entity name (System).Log_Mobile_Request
Field Description Data type Mapped Entity
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Id Unique identifier of the log entry. GUID
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Screen Application screen mobile request took place. Text
Source Source IP address Text
Endpoint Endpoint being called Text
Duration Time in seconds request took. Int
Executed_By Front-end server that originated the log. Text n/a. List of servers can be obtained from (System).Server.
Error_Id Correlation with the Error Log table. Int (System).Log_Error
Cycle ID [0-9] of the table from which the log is being read. Int
Request_Key Correlation field of the several log types to a single request. GUID
Login_Id Authenticated session identifier. Text
User_Id User identifier. 0 if no user logged in (anonymous navigation). Int (System).User

Mobile Request Detail

Purpose Detail logs of mobile applications requests to back-end endpoints.
Database view name oslog_MR_Detail
OutSystems entity name (System).Log_Mobile_Request_Detail
Field Description Data type Mapped Entity
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Id Unique identifier of the log entry. GUID (System).Log_MobileRequest
Cyle ID [0-9] of the table from which the log is being read. Int
Message Log message Text
Detail Log detailed information. Text
DetailLabel Type of detail Text

SMS

Purpose Logs of SMS (text messages) sent or received by the OutSystems platform by means of an [SMS Flow](https://success.outsystems.com/Docum...n/SMS/SMS_Flow).
Database view name oslog_Sms
OutSystems entity name (System).Log_Sms
Field Description Data type Mapped Entity
Instant Time of log generation in the front-end (server log) or of log generation in the mobile device (client log). Date Time
User_Id User identifier. 0 if no user logged in (anonymous navigation). Int (System).User
Espace_Id Module from where the log was originated. 0 if the message originates from an OutSystems service. Int (System).Espace
Tenant_Id Id of the tenant where the message was logged. 0 if message originates from an OutSystems service. Int (System).Tenant
Message SMS Text message. Text
Message_Id Message Identifier as specified by the caller or unique identifier generated. Text
Type Type of the message. MO (Mobile Originated) or MT (Mobile Terminated). Text
Cycle ID [0-9] of the table from which the log is being read. Int
Original_Message_Id When replying to a MobileOriginatedMessage, this property contains the MessageId from the MobileOriginatedMessage. Text
Msisdn User phone number. Can also be a space separated list of numbers. Text
Large_Account Service Large Account phone number (sometimes called Short Code). Text
Billing_Code Used for billing purposes to define the tariff. Text
Billing_Description Description about the billing. Text
Connection SMS connection. Text
Operator_Code Network or Operator code. Text
Custom_Id Just used for compatibility purposes. Int
Custom_1 Custom SMS properties provided by the SMS gateway. Text
Custom_2 Custom SMS properties provided by the SMS gateway. Text
Custom_3 Custom SMS properties provided by the SMS gateway. Text
Tenant_Path The module name for single tenant eSpaces or module name/tenant_name for multitenant eSpaces. Text
Screen_Name Screen name containing the message. Text
DLR_Status SMS delivery status code. Int
Error_Id Identifier of the related error log. Int (System).Log_Error
  • Was this article helpful?