In this blog post, let’s learn about the error message “270 Could not position within a temporary file.” in Hydra and the description of the error.
Error Message
270 Could not position within a temporary file.
Error Details
During execution of this statement, a duplicate value was introduced into a column or columns that a unique constraint protects. The row with the duplicate value was not allowed into the table (not inserted or not updated). For Informix Dynamic Server, any changes that this statement made prior to the discovery of the duplicate value have been rolled back. (The effects of preceding statements in the transaction, if there were any, remain in effect. They must be explicitly rolled back or committed.)
This error occurs in a logging database. However, if you are using repeatable read isolation, error -239 will display instead.