Informix Error -19804: The role does not exist.

Cause and resolution

The role does not exist.

For a role to exist, the DBA must first use the CREATE ROLE statement to create the role. For a list of roles, see the informix.sysusers table.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19804 fires when an operation references a role that hasn't been created — per the official guidance. A role must first be created via CREATE ROLE by the DBA.

A role referenced before it was created, per the official guidance — the direct, only cause.

Solutions / Resolution

Have the DBA run CREATE ROLE to create the role first, per the official guidance.
Check informix.sysusers for the list of existing roles, per the official guidance.

Examples

Checking existing roles

SELECT username FROM informix.sysusers WHERE usertype = 'R';

Diagnostic Checks

Query informix.sysusers for the role name, and create it if missing.

Related Errors / Related Topics

-19805 — "No privilege to set to the role." A related role-usage error, about the role existing but not being granted, rather than not existing at all.

The named role doesn't exist — check informix.sysusers and create it with CREATE ROLE if needed.