KNTA_INTERRUPTED_EXECUTIONS

When a server is started, any execution workflow steps marked as "In Progress", but not currently being executed by any running servers, are automatically failed - they must have been interrupted when the server was previously stopped. This table stores all occurrences of such interruptions.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KREL_RELEASES

RELEASE_ID

ENTITY_PRIMARY_KEY_ID

KCRT_REQUESTS

REQUEST_ID

ENTITY_PRIMARY_KEY_ID

KDLV_PACKAGES

PACKAGE_ID

ENTITY_PRIMARY_KEY_ID

KNTA_USERS

USER_ID

LAUNCHED_BY_USER_ID

KNTA_SERVER_RESTARTS

SERVER_RESTART_ID

SERVER_RESTART_ID

KNTA_REPORT_SUBMISSIONS

REPORT_SUBMISSION_ID

ENTITY_PRIMARY_KEY_ID

KNTA_ENTITIES_NLS

ENTITY_ID

ENTITY_ID

Column Descriptions

Column Name

Null?

Data Type

Description

INTERRUPTED_EXECUTION_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

SERVER_RESTART_ID

NOT NULL

NUMBER

Foreign key to KNTA_SERVER_RESTARTS, used to group interrupted executions to a particular server restart event

ENTITY_ID

NOT NULL

NUMBER

Type of entity that was the parent of the interrupted execution

ENTITY_PRIMARY_KEY_ID

NOT NULL

NUMBER

Primary key value of the entity that was the parent of the interrupted execution

LAUNCHED_BY_USER_ID

NOT NULL

VARCHAR2(200)

ID of the user who launched the interrupted execution

LAUNCHED_DATE

NOT NULL

DATE

Date [timestamp] on which the interrupted execution had been started

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_INTERRUPTED_EXECUTIONS_U1

UNIQUE

1

INTERRUPTED_EXECUTION_ID

KNTA_INTERRUPTED_EXECUTIONS_U2

UNIQUE

1

SERVER_RESTART_ID

KNTA_INTERRUPTED_EXECUTIONS_U2

UNIQUE

2

ENTITY_ID

KNTA_INTERRUPTED_EXECUTIONS_U2

UNIQUE

3

ENTITY_PRIMARY_KEY_ID

Sequences

Sequence Name

Sequence Type

KNTA_INTERRUPTED_EXECUTIONS_S

INTERRUPTED_EXECUTION_ID