In this blog post, let’s learn about the error message “161 ISAM error: no TEXT or BYTE field is open.” in Hydra and the description of the error. Error Message 161 ISAM error: no TEXT or BYTE field is open. Error Details This internal error should not occur. The database server has called the isbopen function twice in a row. If the error recurs, please…

In this blog post, let’s learn about the error message “367 Sums and averages cannot be computed for character columns.” in Hydra and the description of the error. Error Message 367 Sums and averages cannot be computed for character columns. Error Details This statement contains a use of the SUM or AVG function applied to a column that has a character data type (CHAR or…

In this blog post, let’s learn about the error message “342 Remote host cannot execute statement.” in Hydra and the description of the error. Error Message 342 Remote host cannot execute statement. Error Details This statement was sent to a database server in a different system for execution. However, that database server does not support the requested function, possibly because it is an earlier version.

In this blog post, let’s learn about the error message “021 Is a directory.” in Hydra and the description of the error. Error Message 021 Is a directory. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. A file-type operation has been directed to a directory. Some database servers store tables, indexes, and lock files as files…

In this blog post, let’s learn about the error message “148 ISAM error: dbspace is not empty.” in Hydra and the description of the error. Error Message 148 ISAM error: dbspace is not empty. Error Details The database server administrator sees this error. You must bring the other chunk of this mirror pair to on-line status before you can take this chunk off line.

In this blog post, let’s learn about the error message “004 Interrupted system call.” in Hydra and the description of the error. Error Message 004 Interrupted system call. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. You might have pressed the interrupt key at a crucial moment, or the software might have generated an interrupt signal…

In this blog post, let’s learn about the error message “268 Unique constraint violated.” in Hydra and the description of the error. Error Message 268 Unique constraint violated. Error Details The current statement uses the WHERE CURRENT OF cursor-name clause, but that cursor has not yet been associated with a current row. Either no FETCH statement has been executed since it was opened, or the…

In this blog post, let’s learn about the error message “278 Too many ORDER BY columns.” in Hydra and the description of the error. Error Message 278 Too many ORDER BY columns. Error Details The cursor that is named in this statement was not declared in the current session. The current session runs from the execution of a DATABASE statement to the next DATABASE or…

In this blog post, let’s learn about the error message “263 Could not lock row for UPDATE.” in Hydra and the description of the error. Error Message 263 Could not lock row for UPDATE. Error Details In general, the database server cannot create the file that will represent this table. Check the accompanying ISAM error code for more information. The file would be created in…

In this blog post, let’s learn about the error message “271 Could not insert new row into the table.” in Hydra and the description of the error. Error Message 271 Could not insert new row into the table. Error Details This statement requests a new column that has the NOT NULL constraint. However, when a column is added to an existing table, null values have…

In this blog post, let’s learn about the error message “309 ORDER BY column or expression must be in SELECT list.” in Hydra and the description of the error. Error Message 309 ORDER BY column or expression must be in SELECT list. Error Details An expression or column name is in the ORDER BY clause of this SELECT statement, but the expression or column name…

In this blog post, let’s learn about the error message “054 Connection reset by peer.” in Hydra and the description of the error. Error Message 054 Connection reset by peer. 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 network problem….

In this blog post, let’s learn about the error message “034 Result too large.” in Hydra and the description of the error. Error Message 034 Result 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 “189 Message number -189 not found.” in Hydra and the description of the error. Error Message 189 Message number -189 not found. Error Details An operation was executed on a temporary dbspace that required functionality that temporary dbspaces do not provide (most likely logging). Use a nontemporary dbspace for this operation.

In this blog post, let’s learn about the error message “304 HAVING can only have expressions with aggregates or columns in GROUP BY clause.” in Hydra and the description of the error. Error Message 304 HAVING can only have expressions with aggregates or columns in GROUP BY clause. Error Details The HAVING clause is used to select completed rows after grouping has been done. Therefore,…

In this blog post, let’s learn about the error message “016 Mount device busy.” in Hydra and the description of the error. Error Message 016 Mount device busy. 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. If the error recurs, please note all circumstances and…

In this blog post, let’s learn about the error message “240 Could not delete a row.” in Hydra and the description of the error. Error Message 240 Could not delete a row. Error Details The database server cannot execute a COMMIT WORK statement. Check the accompanying ISAM error code for more information. A problem probably exists in accessing the transaction log.

In this blog post, let’s learn about the error message “364 Column column-name not declared for UPDATE OF.” in Hydra and the description of the error. Error Message 364 Column column-name not declared for UPDATE OF. Error Details This UPDATE…WHERE CURRENT OF cursor-name statement refers to at least one column that does not appear in the FOR UPDATE OF clause of the DECLARE statement that…

In this blog post, let’s learn about the error message “345 Cannot update row – row in table does not match row in audit trail.” in Hydra and the description of the error. Error Message 345 Cannot update row – row in table does not match row in audit trail. Error Details While the database server was reconstructing a table from the audit trail, it…

In this blog post, let’s learn about the error message “138 ISAM error: dbspace table overflow.” in Hydra and the description of the error. Error Message 138 ISAM error: dbspace table overflow. Error Details If nused is less than npages, and nextns is large (over 200), the table has too many extents. The upper limit of extents per table is between 200 and 50. The…