Oninit
Talk to an expert →

Informix Error -12802: Error in initializing an access_method routine execution sequence.

Cause and resolution

Error in initializing an access_method routine execution sequence.

An access_method routine cannot be made ready to execute. For example, the external name used in the CREATE FUNCTION statement that defined the access method routine might not exist. Check that the routines used for the access method are properly defined.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12802 fires when an access-method routine can't be made ready to execute — per the official guidance.

  1. The external name used in the CREATE FUNCTION statement that defined the routine not existing, per the official guidance — the named example cause.
Solutions / Resolution
  1. Check that the routines used for the access method are properly defined, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an access-method routine failing to initialize.

Diagnostic Checks
  1. Check the CREATE FUNCTION definitions for the access method's routines, and confirm each external name actually exists.
Related Errors / Related Topics
  • -12800 — "Unsuspected internal error." A related access-method error, about a general data inconsistency rather than specifically initialization.
  • -12801 — "An attempt was made to invoke an access_method routine that does not exist." A related access-method error, about a routine not being defined at all rather than a defined one failing to initialize.
  • -12803 — "Error in executing an access_method routine execution sequence." A related access-method error, about execution itself rather than initialization.

An access-method routine couldn't be made ready to execute, possibly due to a missing external name in its CREATE FUNCTION definition — check the routine definitions.