PPM_SERVICE_RECORDS

This table stores information on each run of a background service. By default the last 50 runs are stored and older runs are automatically purged.

To see the data populated in the PPM_SERVICE_RECORDS table, PPM Server administrators need to set the server configuration parameter com.kintana.core.server.LOG_EXCEPTIONS_TO_DB to true.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_SERVICES_NLS

SERVICE_ID

SERVICE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SERVICE_RECORD_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user that created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user that last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column should not be updated manually

SERVICE_ID

NULLABLE

NUMBER

The background service id

RUN_START_DATE

NOT NULL

DATE

The start time of the run

RUN_FINISH_DATE

NULLABLE

DATE

The end time of the run

NODE_NAME

NOT NULL

VARCHAR2(128)

The PPM node in which this run took place

STATUS

NULLABLE

VARCHAR2(4000)

Additional information about the run

Indexes

Index Name

Index Type

Sequence

Column Name

PPM_SERVICE_RECORDS_PK

UNIQUE

1

SERVICE_RECORD_ID

Sequences

Sequence Name

Sequence Type

PPM_SERVICE_RECORDS_S

SERVICE_RECORD_ID