Oninit
Talk to an expert →

Informix HPL message 23271: Error preparing query, SQL error %d, ISAM error %d

Message

Program: onpload

Error preparing query, SQL error %d, ISAM error %d

Placeholders, in order: %d %d

Oninit® Troubleshooting Guidance

What it means

The server rejected the query onpload tried to prepare (used for an unload). SQL and ISAM errors give the reason.

Common causes
  • The query references a table or column that no longer exists, or is not valid SQL.
What to do
  • Decode the errors with finderr and fix the query in the job.