Open topic with navigation

TIBCO iProcess® Engine 11.10.0

# casenum_gaps

The `casenum_gaps` table holds the free case number gaps.

If the case number or the subcase number generated from the `sequence` table reaches the maximum case number, 4294967295, then the following cases cannot be started. This table is used to create more available case numbers by reusing previous blocks of case numbers, which no longer exist. The free case numbers are available either because the case numbers have never been used or from the original cases that have been purged.

TIBCO iProcess Engine checks the `casenum_gaps` table to find out whether any free case numbers are available for reuse before allocating a sequence from the end of the case numbers.

The `CASENUM_FIND_GAPS` stored procedure adds a list of free case number gaps to the `casenum_gaps` table, it scans a range of case numbers and create available blocks of free case numbers for reuse. For more information, see CASENUM_FIND_GAPS.

Note: This table is not populated by the system and it remains empty unless the `CASENUM_FIND_GAPS` stored procedure is running to populate it.

## Structure

The `casenum_gaps` table has the following structure:

    TABLE casenum_gaps(
    	casenum_min	number(20)	NOT NULL,
    	casenum_max	number(20)	NOT NULL)

Column | Description
`casenum_min` | The minimum case number in a gap.
`casenum_max` | The maximum case number in a gap.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s) | Index Tablespace
`pk_casenum_gaps` | `casenum_min` | MASSIVETABLESPACE

## Foreign Keys

None.

## Triggers

None.

## Indexes

None.

## Storage

The following STORAGE values are defined for this table.

Value | Definition
Initial | MASSIVETABLESIZE
Percentage Increase | MASSIVETABLEPCTINCREASE
Tablespace | MASSIVETABLESPACE

## Table Activity

The `casenum_gaps` 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 | running the `CASENUM_FIND_GAPS` stored procedure.
updated | running TIBCO iProcess Engine.
deleted | running TIBCO iProcess Engine.

## See Also

CASENUM_FIND_GAPS

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