In this blog post, let’s learn about the error message “038 Socket operation on non-socket.” in Hydra and the description of the error. Error Message 038 Socket operation on non-socket. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Look for other operating-system error messages that might give more information, particularly the operation in question and the…

In this blog post, let’s learn about the error message “351 Database contains tables owned by other users.” in Hydra and the description of the error. Error Message 351 Database contains tables owned by other users. Error Details This DROP DATABASE or UPDATE STATISTICS statement cannot be carried out for the reason shown. It might destroy the work of others. In order to drop this…

In this blog post, let’s learn about the error message “121 ISAM error: cannot write log record.” in Hydra and the description of the error. Error Message 121 ISAM error: cannot write log record. Error Details The ISAM processor is trying to open the transaction log file but has received an error from the operating system. Look for operating-system error messages that might give more…

In this blog post, let’s learn about the error message “225 Cannot create file for system catalog table-name.” in Hydra and the description of the error. Error Message 225 Cannot create file for system catalog table-name. Error Details The table name appears twice in the list that follows the word FROM. Review the statement to see if you intended to name some other table the…

In this blog post, let’s learn about the error message “266 There is no current row for UPDATE/DELETE cursor.” in Hydra and the description of the error. Error Message 266 There is no current row for UPDATE/DELETE cursor. Error Details The database server created a temporary file in the directory that the DBTEMP environment variable (or /tmp by default on UNIX systems) specifies, but it…

In this blog post, let’s learn about the error message “070 Stale NFS file handle.” in Hydra and the description of the error. Error Message 070 Stale NFS file handle. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. An error exists in a file server on a networked file system. Although Informix database servers do not…

In this blog post, let’s learn about the error message “169 ISAM error: Pages for TEXT or BYTE data can’t be allocated from a chunk until chunk add is logged.” in Hydra and the description of the error. Error Message 169 ISAM error: Pages for TEXT or BYTE data can’t be allocated from a chunk until chunk add is logged. Error Details Allocation of disk…

In this blog post, let’s learn about the error message “378 Record currently locked by another user.” in Hydra and the description of the error. Error Message 378 Record currently locked by another user. Error Details A row of a table that this statement needs is not accessible because it has been locked. Check the accompanying ISAM error code for more detailed information. It will…

In this blog post, let’s learn about the error message “120 ISAM error: cannot open log file.” in Hydra and the description of the error. Error Message 120 ISAM error: cannot open log file. Error Details The ISAM processor is trying to roll back a transaction or recover a file but has encountered bad data in a transaction log record. The dblog or selog utility…

In this blog post, let’s learn about the error message “253 Identifier length exceeds the maximum allowed by this version of the server.” in Hydra and the description of the error. Error Message 253 Identifier length exceeds the maximum allowed by this version of the server. Error Details The ORDER BY or GROUP BY clause uses column-sequence numbers, and at least one of them is…

In this blog post, let’s learn about the error message “077 Identifier removed.” in Hydra and the description of the error. Error Message 077 Identifier removed. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support.

In this blog post, let’s learn about the error message “332 Cannot access audit trail name information.” in Hydra and the description of the error. Error Message 332 Cannot access audit trail name information. Error Details An error occurred while reading the audit-trail file. Re-execute the latest statement; if the error recurs, the audit-trail file is corrupt. In that case you will need to drop…

In this blog post, let’s learn about the error message “112 ISAM error: there is no current record.” in Hydra and the description of the error. Error Message 112 ISAM error: there is no current record. Error Details The ISAM processor cannot locate the requested record. For C-ISAM programs, no record was found with the requested index value or record number, depending on the retrieval…

In this blog post, let’s learn about the error message “033 Argument too large.” in Hydra and the description of the error. Error Message 033 Argument too large. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support.

In this blog post, let’s learn about the error message “051 Network is unreachable.” in Hydra and the description of the error. Error Message 051 Network is unreachable. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. If you are attempting to use INFORMIX-STAR or INFORMIX-NET, contact your system administrator to find out what the network problem…

In this blog post, let’s learn about the error message “257 System limit on maximum number of statements exceeded, maximum is count.” in Hydra and the description of the error. Error Message 257 System limit on maximum number of statements exceeded, maximum is count. Error Details The database server cannot execute this COMMIT WORK or ROLLBACK WORK statement because no BEGIN WORK was executed to…

In this blog post, let’s learn about the error message “153 ISAM error: not in ISMANULOCK mode.” in Hydra and the description of the error. Error Message 153 ISAM error: not in ISMANULOCK mode. Error Details This internal error occurs when the leading byte in a VARCHAR column on disk indicates a VARCHAR length greater than the column was defined to hold when the column…

In this blog post, let’s learn about the error message “052 Network dropped connection on reset.” in Hydra and the description of the error. Error Message 052 Network dropped connection on reset. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. If you are attempting to use INFORMIX-STAR or INFORMIX-NET, contact your system administrator to report a…

In this blog post, let’s learn about the error message “104 ISAM error: too many files open.” in Hydra and the description of the error. Error Message 104 ISAM error: too many files open. Error Details The ISAM processor has been given an invalid key descriptor. For C-ISAM programs, review the key descriptor. Each key descriptor has a maximum of 8 parts and 120 characters….

In this blog post, let’s learn about the error message “050 Network is down.” in Hydra and the description of the error. Error Message 050 Network is down. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. If you are attempting to use INFORMIX-STAR or INFORMIX-NET, contact your system administrator to find out when the network will…