Oninit
Talk to an expert →

Informix Error -26197: Reached maximum error limit during load: errno, filename.

Cause and resolution

Reached maximum error limit during load: errno, filename.

When the database server tried to load the data from the external table, the server reached the MAXERRORS limit defined for the external table.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-26197 fires when loading from an external table hits the table's MAXERRORS limit — per the official guidance.

  1. The number of load errors reached the external table's configured MAXERRORS limit, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Check the reject file (if configured) for the specific rows/errors that accumulated, per the official guidance's implication, and fix the source data.
  2. Raise MAXERRORS if the error rate is expected and acceptable, per the official guidance's implication.
Examples
N/A

No specific triggering statement is documented beyond exceeding MAXERRORS.

Diagnostic Checks
  1. Check the reject file/log for the accumulated load errors, and fix the source data or raise MAXERRORS.
Related Errors / Related Topics
  • -26168 — "Conversion error: errno, filename." The individual per-row load-error condition that, accumulated past MAXERRORS, triggers this error.

Loading from an external table hit its MAXERRORS limit — check the reject file/log and fix the source data, or raise the limit.