Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# 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 the `case_event`table.

## Structure

The `case_event` table has the following structure:

    TABLE case_event(
    	node_id		number(5)		NOT NULL,
    	proc_id		number(5)		NOT NULL,
    	major_vers	number(5)		NOT NULL,
    	minor_vers	number(5)		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 canceled.
| • | -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) | Index Tablespace
`pk_case_event` | `node_id proc_id casenum eventname` | LARGETABLESPACE

## Foreign Keys

The following foreign key is defined for this table.

Key Name | Column(s) | Referenced in Table...
`fk_case_event` 1 This key enforces the DELETE CASCADE referential action. | `casenum proc_id node_id` | case_information

## Index

The following index is defined for this table.

Index Name | Column(s) Indexed | Tablespace
`idx_case_event_fk` | `casenum proc_id node_id` | LARGETABLESPACE

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | LARGETABLESIZE
Percentage Increase | LARGETABLEPCTINCREASE
Tablespace | LARGETABLESPACE

## 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 canceled.
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 canceled.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine