Skip to main content

 

Managing the Applications Lifecycle

 

 

OutSystems

Log data reference

  • Edit
    Collaborate with us
    Edit this page on GitHub
  • 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.

    Mapping of the database views and Entities

    You can access the log data in Service Studio, by using the PlatformLogs extension. Each entry has the corresponding _Previous entry. For example, for the oslog_General view you have both oslog_General_Previous in the database views and Log_General_Previous in the Entity list.

    Database view Entity
    oslog_Cyclic_Job Log_Cyclic_Job
    oslog_Error Log_Error
    oslog_Extension Log_Extension
    oslog_General Log_General
    oslog_Int_Detail Log_Integration_Detail
    oslog_Integration Log_Integration
    oslog_mobile_request Log_Mobile_Request
    oslog_MR_Detail Log_Mobile_Request_Detail
    oslog_RequestEvent Log_RequestEvent
    oslog_Screen Log_Screen
    oslog_Sms Log_Sms
    oslog_SrvAPI Log_ServiceAPI
    oslog_SrvAPI_Detail Log_ServiceAPI_Detail
    oslog_Web_Reference Log_Web_Reference
    oslog_Web_Service Log_Web_Service

    Request Event

    Purpose Log of application events as generated by the Performance Monitoring system in web application or responsive (mobile) web applications.
    Database view name oslog_RequestEvent
    OutSystems entity name (System).Log_RequestEvent

    The Performance Monitoring system is documented here.

    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
    REQUESTKEY 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. 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
    Espace_Name The name of the eSpace. Text
    Application_Name The name of the app. Text
    Application_Key Unique identifier for the application. Text
    Username 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
    Espace_Name The name of the eSpace. Text
    Application_Name The name of the app. Text
    Application_Key Unique identifier for the application. Text
    Username 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
    Espace_Name The name of the eSpace. Text
    Application_Name The name of the app. Text
    Application_Key Unique identifier for the application. Text
    Username 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. 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
    Espace_Name The name of the eSpace. Text
    Application_Name The name of the app. Text
    Application_Key Unique identifier for the application. 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. 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
    Cycle ID [0-9] of the table from which the log is being read. Int

    Web Reference (deprecated)

    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
    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
    Action
    Endpoint
    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. Int (System).Log_Error
    Cycle ID [0-9] of the table from which the log is being read. Int
    Id
    Is_Expose True if log refers to an integration being exposed. False if calling an integration. Bool

    Web Service (deprecated)

    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
    Source
    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
    Action
    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
    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

    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
    Espace_Name The name of the eSpace. Text
    Application_Name The name of the app. Text
    Application_Key Unique identifier for the application. Text
    Cyclic_Job_Name

    Extension

    Purpose Logs of the integration calls implemented as custom code / 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
    Espace_Name The name of the eSpace. Text
    Extension_Name
    Application_Name The name of the app. Text
    Application_Key Unique identifier for the application. Text
    Username Text

    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
    Espace_Name The name of the eSpace. Text
    Application_Name The name of the app. Text
    Application_Key Unique identifier for the application. Text
    Username Text

    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
    Cycle 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 (deprecated)

    Purpose Logs of SMS (text messages). This is a legacy table.
    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
    Custom_Id
    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_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
    Espace_Name The name of the eSpace. Text
    Application_Name The name of the app. Text
    Application_Key Unique identifier for the application. Text
    Username Text
    • Was this article helpful?