# Logging_ActiveRoles: Big Data JSON Trace Messages Gets all trace logging events Trace messages of Invantive products. Every process writes the messages it traces to a file of its own under a folder per day (the UTC date) below this directory, in parts: a part being written carries -writing in its name and a closed part -c, and a closed part is compressed to a .zst file beside which the uncompressed part is removed. The first lines of every part are the status lines of the process: product, version, machine, user, settings. A part being written can be read; its last line may be incomplete. ## Documentation Trace messages of Invantive products. Every process writes the messages it traces to a file of its own under a folder per day (the UTC date) below this directory, in parts: a part being written carries -writing in its name and a closed part -c, and a closed part is compressed to a .zst file beside which the uncompressed part is removed. The first lines of every part are the status lines of the process: product, version, machine, user, settings. A part being written can be read; its last line may be incomplete. - Catalog: `BigData` - Schema: `Logging` - Label: Trace Messages The data in this table is partitioned per value of the `partition` column. This is a read-only table. The Big Data JSON API may not support changing the data or the Invantive UniversalSQL driver for Big Data JSON does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Big Data JSON API. ## Table Columns The columns of the table `Logging_ActiveRoles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BillingId` | `varchar2` | Billing Id | ☐ | Billing identifier of the work. | | `BillingPoolIdentityId` | `varchar2` | Billing Pool Identity Id | ☐ | Pool identity the work is billed to, when it differs from the pool identity. | | `BillingReference` | `varchar2` | Billing Reference | ☐ | Billing reference of the work. | | `CallerAudSid` | `int32` | Caller Aud Sid | ☐ | Auditing session identifier of the calling database session (Oracle AUDSID). | | `CallerClientCharset` | `varchar2` | Caller Client Charset | ☐ | Character set of the client of the calling database session. | | `CallerClientDriver` | `varchar2` | Caller Client Driver | ☐ | Driver of the client of the calling database session. | | `CallerClientIdentifier` | `varchar2` | Caller Client Identifier | ☐ | Client identifier of the calling database session. | | `CallerClientInfo` | `varchar2` | Caller Client Info | ☐ | Client information of the database session which called into Invantive, when the process runs inside a database (Oracle). | | `CallerClientVersion` | `varchar2` | Caller Client Version | ☐ | Version of the client of the calling database session. | | `CallerContext` | `varchar2` | Caller Context | ☐ | Context of the calling database session. | | `CallerDatabase` | `varchar2` | Caller Database | ☐ | Name of the calling database. | | `CallerEvent` | `varchar2` | Caller Event | ☐ | Event of the calling database session. | | `CallerLogonTime` | `datetime` | Caller Logon Time | ☐ | Log-on time of the calling database session. ISO 8601 date and time; a moment in UTC carries the suffix Z. | | `CallerPort` | `int32` | Caller Port | ☐ | Port of the calling database session. | | `CallerProcess` | `varchar2` | Caller Process | ☐ | Process of the calling database session. | | `CallerProgram` | `varchar2` | Caller Program | ☐ | Program of the calling database session. | | `CallerSid` | `int32` | Caller Sid | ☐ | Session identifier of the calling database session (Oracle SID). | | `CallingProviderAlias` | `varchar2` | Calling Provider Alias | ☐ | Alias of the data container - the connection to a data source - from which the message was written. | | `DurationMs` | `double` | Duration Ms | ☐ | Duration in milliseconds of the operation the message reports on, when it reports on one which took time. | | `ExecutableName` | `varchar2` | Executable Name | ☐ | Name of the executable of the process. | | `ExecutionOptionsId` | `guid` | Execution Options Id | ☐ | Identifier of the execution options - the unit of work - the message was written under. | | `file_name` | `varchar2` | File Name | ☑ | The name of the file the row was read from, within its directory. | | `file_path` | `varchar2` | File Path | ☑ | The directory of the file the row was read from. | | `file_row_number` | `int64` | File Row Number | ☑ | The number of the record the row was read from, counted from one per file: the line of a file with one record per line, the element of a JSON array. | | `GuiAction` | `varchar2` | Gui Action | ☐ | Action of the user interface being executed when the message was written. | | `GuiExternalIpAddress` | `varchar2` | Gui External Ip Address | ☐ | External IP address of the user interface. An IP address as text, in IPv6 notation. | | `GuiExternalIpPort` | `int32` | Gui External Ip Port | ☐ | External port of the user interface. | | `GuiLanguage` | `varchar2` | Gui Language | ☐ | Language of the user interface, as a culture code. | | `GuiModuleName` | `varchar2` | Gui Module Name | ☐ | Name of the module of the user interface. | | `GuiModuleVersion` | `varchar2` | Gui Module Version | ☐ | Version of the module of the user interface. | | `GuiOsUser` | `varchar2` | Gui Os User | ☐ | Operating system user of the user interface. | | `GuiUser` | `varchar2` | Gui User | ☐ | User of the user interface, as logged on to the product. | | `Id` | `int64` | Id | ☐ | Sequence number of the record within the process, incremented per message; orders records which share OccurredUtc. | | `InboundCorrelationIds` | `varchar2` | Inbound Correlation Ids | ☐ | Correlation identifiers received with the inbound request. | | `LoggingLevel` | `varchar2` | Logging Level | ☐ | Severity of the message. An enumeration (Invantive.Basics.LoggingLevel) written as the name of its member. Members: Failure = 0: Failure of the system itself.; Error = 1: Error caused by the user, the data or the data source.; Warning = 2: Warning: something to look at, no failure.; Info = 3: Information.; Debug = 4: Debug output, the bulk of a trace.; Audit = 5: Audit record of an action.; License = 6: Licensing.; Unknown = 7: Unknown.. | | `MachineNameFull` | `varchar2` | Machine Name Full | ☐ | Full name of the machine the process runs on. | | `ManagedThreadId` | `int32` | Managed Thread Id | ☐ | Identifier of the managed .NET thread which wrote the message. | | `Message` | `varchar2` | Message | ☐ | Text of the message. | | `MessageCode` | `varchar2` | Message Code | ☐ | Message code of the event: itgen followed by three letters naming the component and three digits, unique per place in the product where a message is written. Documented per code on https://forums.invantive.com. | | `MetadataType` | `varchar2` | Metadata Type | ☐ | Full name of the .NET type of the record, Invantive.Basics.TraceContext, which tells a reader of a mixed stream what shape the line has. | | `MetadataUid` | `guid` | Metadata Uid | ☐ | Reference to the metadata object the message concerns. | | `NaturalKey` | `varchar2` | Natural Key | ☐ | Natural key of the subject of the message, when the event is about one thing with a name such as a customer or a document, so that the messages about it can be found together. | | `Ns` | `int32` | Ns | ☐ | Sub-millisecond part of OccurredUtc in nanoseconds - the 100 ns ticks within the millisecond, times 100 - so that records within one millisecond keep their order for a reader whose timestamps stop at the millisecond. | | `OccurredUtc` | `datetime` | Occurred Utc | ☐ | Moment the message was registered, in UTC, with a resolution of 100 ns. ISO 8601 date and time; a moment in UTC carries the suffix Z. | | `Parameter1` | `varchar2` | Parameter1 | ☐ | Free parameter 1 of the message, as text: a value the writer of the message records separately from the text, such as a file name, a count or an identifier. | | `Parameter10` | `varchar2` | Parameter10 | ☐ | Free parameter 10 of the message, as text. | | `Parameter2` | `varchar2` | Parameter2 | ☐ | Free parameter 2 of the message, as text. | | `Parameter3` | `varchar2` | Parameter3 | ☐ | Free parameter 3 of the message, as text. | | `Parameter4` | `varchar2` | Parameter4 | ☐ | Free parameter 4 of the message, as text. | | `Parameter5` | `varchar2` | Parameter5 | ☐ | Free parameter 5 of the message, as text. | | `Parameter6` | `varchar2` | Parameter6 | ☐ | Free parameter 6 of the message, as text. | | `Parameter7` | `varchar2` | Parameter7 | ☐ | Free parameter 7 of the message, as text. | | `Parameter8` | `varchar2` | Parameter8 | ☐ | Free parameter 8 of the message, as text. | | `Parameter9` | `varchar2` | Parameter9 | ☐ | Free parameter 9 of the message, as text. | | `ParentSpanId` | `varchar2` | Parent Span Id | ☐ | Span identifier of the span this record's span runs inside, in W3C trace context notation. Absent on the outermost span of a process. | | `partition` | `varchar2(255)` | Partition | ☑ | The partition of the row: the first subdirectory under the directory of the connection on the way to the file, or the name of that directory for a file in its root. | | `PartitionCode` | `varchar2` | Partition Code | ☐ | Code of the partition - the company, division or administration within the data source - the message concerns, when it concerns one. | | `PoolIdentityId` | `varchar2` | Pool Identity Id | ☐ | Identifier of the pool identity: the identity a pooled process or connection works under. | | `ProcessId` | `int64` | Process Id | ☐ | Operating system process identifier. | | `ProviderName` | `varchar2` | Provider Name | ☐ | Name of the data source driver (provider) the message concerns, when it concerns one. | | `Quantity` | `int64` | Quantity | ☐ | A count the message reports, such as a number of rows or of bytes, so that it can be summed or plotted without parsing the text. | | `RemoteCorrelationIds` | `varchar2` | Remote Correlation Ids | ☐ | Correlation identifiers received from remote systems, as a comma-separated list of key: value. | | `RequestId` | `varchar2` | Request Id | ☐ | Identifier of the request being handled, for a web application. | | `SessionId` | `varchar2` | Session Id | ☐ | Identifier of the logical session - a connection, a request - the message belongs to. | | `SpanId` | `varchar2` | Span Id | ☐ | Span identifier of the unit of work this record was written in, in W3C trace context notation. | | `StackTrace` | `varchar2` | Stack Trace | ☐ | Stack trace at the moment of the message, when the writer asked for one. | | `TableName` | `varchar2` | Table Name | ☐ | Name of the table the message concerns, when it concerns one. | | `Tags` | `varchar2` | Tags | ☐ | Tags classifying the message, such as the tags of the logger itself, used to select the messages of one kind. The JSON text of the array. | | `TaskId` | `int32` | Task Id | ☐ | Identifier of the .NET task which wrote the message, when written from within a task. | | `TEXT` | `varchar2` | | ☐ | | | `ThreadCpuTimeNs` | `int64` | Thread Cpu Time Ns | ☐ | Cumulative CPU time in nanoseconds, kernel plus user, the OS thread had consumed since it started, at the moment of the record. The same running total and the same SessionId caveat as ThreadHeapAllocatedBytes. | | `ThreadHeapAllocatedBytes` | `int64` | Thread Heap Allocated Bytes | ☐ | Cumulative bytes the OS thread had allocated on the managed heap since it started, at the moment of the record. A running total and not a delta: subtract an earlier record with the same ManagedThreadId and SessionId to get the bytes allocated in between; a change of SessionId on the same thread means another logical session reused the thread and the reference point moved. | | `TraceId` | `varchar2` | Trace Id | ☐ | Trace identifier of the distributed trace this record belongs to, in W3C trace context notation and taken from the activity of the runtime; the same identifier every monitoring product reads. | | `TransactionId` | `varchar2` | Transaction Id | ☐ | Identifier of the outermost span of the work inside this process: what Elastic APM calls the transaction, where W3C knows spans only. The span identifier of the root activity of the process. | | `Uid` | `guid` | Uid | ☐ | Unique identifier of the record. | | `UserEmailAddress` | `varchar2` | User Email Address | ☐ | E-mail address of the user of the session, when known. | | `UserName` | `varchar2` | User Name | ☐ | Operating system user of the process. |