Category: Hydra
Hydra Error 263 Could not lock row for UPDATE.
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…
Hydra Error 271 Could not insert new row into the table.
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…
Hydra Error 309 ORDER BY column or expression must be in SELECT list.
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…
Hydra Error 054 Connection reset by peer.
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….
Hydra Error 034 Result too large.
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.
Hydra Error 189 Message number -189 not found.
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.
Hydra Error 304 HAVING can only have expressions with aggregates or columns in GROUP BY clause.
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,…
Hydra Error 016 Mount device busy.
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…
Hydra Error 240 Could not delete a row.
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.
Hydra Error 364 Column column-name not declared for UPDATE OF.
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…
Hydra Error 345 Cannot update row – row in table does not match row in audit trail.
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…
Hydra Error 138 ISAM error: dbspace table overflow.
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…