Since
OpenEdge 12.1, OpenEdge databases support 32,000 Sequences regardless of the database block size:
- Maximum number of sequences is 32,000 regardless of blocksize for Shared (Global) and Multi-Tenant Sequence in 12.2. 32000 represents combined number of sequences.
- In OpenEdge 12.1, the maximum number of Multi-tenant sequences is (still) limited to: 250 * (Block Size / 1024).
- In OpenEdge 12.2, the maximum number of Multi-tenant sequences is no longer limited to the block size. Maximum number of sequences is 32,000 for Multi-Tenant Sequence.
Multi-tenant sequences can exist in only the first two sequence blocks. This means, a maximum 2000 MT sequences for 8K blocksize, which is similar to behavior in 12.0 and previous versions except you would now have 30,000 shared sequences available. If you try to add more MT sequences it will fail with:
Cannot add any more multi-tenant sequences to the database. (19476)
| Database Block Size | Sequence Blocks |
| 8192 bytes (8K) | 32 |
| 4096 bytes (2K) | 64 |
| 2048 bytes (2K) | 128 |
| 1024 bytes (1K) | 256 |
Since
Progress 9.x to
OpenEdge 12.0 (inclusive), the number of Sequences is limited by the database
Block Size, the formula is:
Maximum Sequence Number = 250 * (Block Size / 1024)
These are database-wide: global maximum number of sequences per database, and the sum of all sequences (shared or tenant sequences) cannot exceed this number.
In other words, an application that uses more than 250 sequences will not work on all database block sizes:
Cannot add any more sequences to the database. (9335)
If you need to maintain more sequences, you must either increase the database block size or add another database to define more sequences or us a control table to generate incremental values in your application. The number of incremental fields you can maintain in a control table is limited only by the number of integer fields you can store in the table.
The number of sequences per database block size are listed in the table below:
| Database Block Size | Maximum number of Sequences |
| 8192 bytes (8K) | 2000 |
| 4096 bytes (2K) | 1000 |
| 2048 bytes (2K) | 500 |
| 1024 bytes (1K) | 250 |
