Informix Error -4624: Owner name identifier has exceeded 8 characters in length.
Cause and resolution
Owner name identifier has exceeded 8 characters in length.
The name shown appears in this statement where an owner name is expected, for example preceding the name of a table: identifier.table. However, the name exceeds eight characters, and the database server only allows eight-character owner names. Review the punctuation of the statement and the spelling of the identifier.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-4624 fires when an owner-name identifier, used in a position such as preceding a table name
(identifier.table), exceeds 8 characters — per the official guidance, the database server
only allows eight-character owner names.
- An owner-name identifier longer than 8 characters, per the official guidance — the direct, only cause.
- Mispunctuation causing a different name to be parsed as an owner name, per the official guidance — a specific, named contributing scenario worth checking too.
Solutions / Resolution
- Review the punctuation of the statement, per the official guidance, to confirm the flagged name really is intended as an owner name.
- Review the spelling of the identifier, per the official guidance, and shorten it to 8 characters or fewer if it's genuinely an owner name.
Examples
An oversized owner name
SELECT * FROM accountingdept.orders
-- -4624: "accountingdept" exceeds the 8-character owner-name limit
Diagnostic Checks
- Check the punctuation around the flagged identifier, and confirm whether it's genuinely intended as an owner name; if so, shorten it to 8 characters or fewer.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -4624 in this set yet.
An owner-name identifier exceeds the database server's 8-character limit — review the statement's punctuation and shorten the name.