Secure Agent Services

Back Next

Configuring a separate logging data source

The logs are stored in the activevos database, by default. To reduce the load on the existing database, you can create a separate logging data source and redirect process logging.

To create a separate logging data source in a dedicated schema on a Secure Agent, perform the following steps:

Create a separate database and a schema within the database.

To use a separate schema, execute the following Data Definition Language (DDL) statement to create a structure for the

AeProcessLogData

table and the index within the schema:

CREATE TABLE AeProcessLogData
(
   ProcessId BIGINT NOT NULL,
   SequenceId BIGINT NOT NULL,
   PlanId BIGINT NOT NULL,
   TenantContextId VARCHAR(32),
   LocationPath TEXT NOT NULL, 
   InstanceLocationId INT NOT NULL,
   DefLocationId INT NOT NULL,
   CorrelationId INT NOT NULL,
   EventId INT NOT NULL,
   SessionId INT NOT NULL,
   SourceId INT NOT NULL,
   FaultName VARCHAR(255),
   AncillaryStr TEXT,
   AncillaryInt INT,
   EventTime BIGINT NOT NULL,
   DataDocument TEXT,   
   PRIMARY KEY (ProcessId, SequenceId)
);
CREATE INDEX AeLogDataPidInsId ON AeProcessLogData(PlanId, ProcessId, InstanceLocationId);

Create a user, for example,

logdbuser

, with the following privileges:

CREATE ROLE username WITH
NOLOGIN
NOSUPERUSER
NOCREATEDB
NOCREATEROLE
INHERIT
NOREPLICATION
NOBYPASSRLS
CONNECTION LIMIT -1
PASSWORD 'xxxxxx';
GRANT pg_read_all_data, pg_write_all_data TO username;

Create a system environment variable with the user name and password for the log database user role you created as follows:

PE_DB_LOG_USERNAME

PE_DB_LOG_PASSWORD

Configure the following logging data source properties in the Process Server properties:

logUrl

logMaxActive

logMaxIdle

logMaxWait

logConnection-properties

For more information about configuring the logging data source properties, see Process Server properties.

Rename Saved Search

Table of Contents

Secure Agent Services

Secure Agent Services

Configuring a separate logging data source

Configuring a separate logging data source