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 |