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