Sequences

A sequence is an Oracle object that acts as a generator that provides a sequential series of numbers. This topic describes the warnings that database sequences can contain.

In this topic:

Extra Sequence

OpenText Application Quality Management schemas should contain only the sequences that are defined in the schema configuration file.

Problem: If the verification process finds an extra sequence, it generates an Extra Sequence warning.

Solution: Do one of the following:

• Change the Schema. Move the sequence to a new database user schema. Before doing so, consult with your database administrator. For details, see Change the database user schema.

• Use the Exception File.

Missing Sequence

Problem: If the verification process finds that one of the sequences that should be defined on the OpenText Application Quality Management schema is missing, it generates a Missing Sequence warning.

Solution: Do the following:

• Run the repair process to fix the problem.

• See Change the database user schema.

Incorrect Sequences

Problem: Sometimes the Oracle object sequence numbers become incorrect, for example, if an export of the database is done on a live activated project, in which users are still modifying tables. If the verification process finds that Oracle sequences objects are not fully synchronized with OpenText Application Quality Management schema table IDs, the verification process generates an Incorrect Oracle sequences found warning.

Solution: Run the repair process to fix the problem.

Back to top