Copyright © Cloud Software Group, Inc. All Rights Reserved

case_event

The case_event table stores information about cases that are interrupted by triggered events when processing the purge, close, resurrect, suspend, or resume operation. The case information is recorded in this table only when the BG process is handling the delayed release EAI steps, which are defined in the triggered event. After finishing the event, the case resumes execution and fetches the temporary case data from this table.

Structure

The case_event table has the following structure:

TABLE case_event(
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
major_vers INTEGER NOT NULL,
minor_vers INTEGER NOT NULL,
eventname VARCHAR(32) NOT NULL,
user_event_name VARCHAR(32) NOT NULL,
casenum NUMERIC(20) NOT NULL,
state INTEGER NOT NULL,
actionparameter VARCHAR(256) )

Column	Description
node_id	ID of the node that this case is hosted on, as defined in the nodes table.
proc_id	ID of the procedure that this procedure event belongs to, as defined in the proc_index table.
major_vers	Major version number of the procedure version that this case belongs to, as defined in the proc_version table.
minor_vers	Minor version number of the procedure version that this case belongs to, as defined in the proc_version table.
eventname	The name of the procedure event. The value of this column is one of the following: • BeforePurge • BeforeClose • AfterClose • BeforeResurrect • AfterResurrect • BeforeSuspend • AfterSuspend • BeforeResume • AfterResume
user_event_name	The name of the event step which you set for the procedure event.
casenum	ID of the case that this event belongs to, as defined in the case_information table.
state	Flag that defines the state of the procedure event after the event is triggered. The meaning for each flag is: • 2  the triggered event is in the processing state. • 3   the triggered event is finished. • 4   the triggered event is cancelled. • -1   the triggered event failed.
actionparameter	When an event is triggered, the processing purge, close, resurrect, suspend, or resume operation is interrupted. This column saves case data of the processing operation when the BG process is handling the delayed release EAI steps, which are defined in the triggered event. After finishing the event, the case resumes execution of the operation and fetches the temporary case data from this column.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)
pk_case_event	node_id proc_id casenum eventname

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_case_event1	casenum proc_id node_id	case_information

---

1

This key enforces the DELETE CASCADE referential action.

Index

The following index is defined for this table.

Index Name	Column(s) Indexed
idx_case_event_fk	casenum proc_id node_id

Table Activity

The case_event table contains one or more rows for each instance of each procedure definition on the system. Rows are added, updated, and deleted in the following situations.

A row is...	When...
added	The procedure event enters the processing state.
updated	The procedure event changes from processing to failed or to cancelled.
deleted	If one of the following conditions occurred: • The case is purged. • The procedure event is finished. • The procedure event failed. • The procedure event is cancelled.

Copyright © Cloud Software Group, Inc. All Rights Reserved