PPM_EXCEPTIONS

This table stores the exceptions thrown by the PPM server. By default the past two weeks of exceptions are stored and older exceptions are automatically deleted.

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

PPM_SERVICE_RECORDS

SERVICE_RECORD_ID

SERVICE_RECORD_ID

PPM_STACK_TRACE

STACK_TRACE_ID

STACK_TRACE_ID

KNTA_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

EXCEPTION_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

NAME

NOT NULL

VARCHAR2(128)

This is usually the java class name of the exception

EXCEPTION_TYPE

NOT NULL

VARCHAR2(128)

The type of the exception depending on where it was generated, for example: web, report, execution log or service

REASON

NULLABLE

VARCHAR2(4000)

The reason for the exception

RANDOM_GUID

NULLABLE

VARCHAR2(128)

The GUID associated with the exception, useful in searching for a particular exception. Not all exceptions have a GUID.

NODE_NAME

NOT NULL

VARCHAR2(128)

The PPM node in which the exception occurred.

URL

NULLABLE

VARCHAR2(4000)

The URL for a web exception

USER_ID

NULLABLE

NUMBER

The user that encountered/caused the exception

SERVICE_ID

NULLABLE

NUMBER

The background service id. This field is only relevant for a service exception.

SERVICE_RECORD_ID

NULLABLE

NUMBER

The service run in which the exception occurred. This field is only relevant for a service exception.

STACK_TRACE_ID

NOT NULL

NUMBER

The stack trace associated with the exception.

Indexes

Index Name

Index Type

Sequence

Column Name

PPM_EXCEPTIONS_N1

NONUNIQUE

1

USER_ID

PPM_EXCEPTIONS_N2

NONUNIQUE

1

SERVICE_ID

PPM_EXCEPTIONS_N3

NONUNIQUE

1

CREATION_DATE

PPM_EXCEPTIONS_N4

NONUNIQUE

1

STACK_TRACE_ID

PPM_EXCEPTIONS_PK

UNIQUE

1

EXCEPTION_ID

Sequences

Sequence Name

Sequence Type

PPM_EXCEPTIONS_S

EXCEPTION_ID