Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: