Informix Error -8300: The specified sequence object <sequence-name> is not in the database. </sequence-name>

Cause and resolution

The specified sequence object <sequence-name> is not in the database. </sequence-name>

The database server cannot find the sequence object specified in the statement. The sequence object might have been renamed or dropped from the database.

Check the names of sequence objects in the statement. If the names are spelled as you intended, check that you are using the database you want. To find the names of all sequence objects, query the syssequences table.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8300 fires when the database server can't find the named sequence object — per the official guidance.

A misspelled sequence name, per the official guidance — the first named cause.
The sequence was renamed or dropped, per the official guidance — the second named cause.
The wrong database currently selected, per the official guidance — the third named cause.

Solutions / Resolution

Check the names of sequence objects in the statement, per the official guidance, and confirm the intended database is selected.
Query syssequences to find the names of all sequence objects, per the official guidance.

Examples

Listing sequence objects

SELECT tabname FROM syssequences, systables
    WHERE syssequences.tabid = systables.tabid;

Diagnostic Checks

Query syssequences for the correct name, and confirm the current database is the intended one.

Related Errors / Related Topics

-8301 — "Sequence already exists in the database." The complementary condition — a sequence name colliding with an existing one, rather than not being found.

A named sequence object doesn't exist — check its spelling via syssequences and the current database.