Informix Error -19846: You cannot access a nonlogging table (%s) in a logged database on a secondary server.

Reasons / Common Causes

-19846 fires when a nonlogging (RAW) table is accessed in a logged database on an HDR secondary server — per the official guidance. Nonlogging tables aren't replicated to secondaries, so they simply aren't available there.

1. A RAW table accessed on a secondary server, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Access the table on the primary server instead, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond accessing a RAW table on a secondary.

Diagnostic Checks

1. Check whether the accessed table is RAW and the server is a secondary, and redirect the access to the primary.

Related Errors / Related Topics

• -19844 — "Tables of type RAW are not allowed in a logged database on an HDR primary server." A related HDR/logging restriction, about creating a RAW table on the primary rather than accessing one on the secondary.
• -19845 — "You cannot alter the logging mode of a table in a logged database on a primary server." A related HDR/logging restriction, about altering logging mode on the primary.

A nonlogging (RAW) table isn't available on an HDR secondary — access it on the primary.