Category: Hydra
Hydra Error 291 Cannot change lock mode of table.
In this blog post, let’s learn about the error message “291 Cannot change lock mode of table.” in Hydra and the description of the error. Error Message 291 Cannot change lock mode of table. Error Details The table is already locked in exclusive mode. You will have to wait for the table to be unlocked before you proceed.
Hydra Error 035 Operation would block.
In this blog post, let’s learn about the error message “035 Operation would block.” in Hydra and the description of the error. Error Message 035 Operation would block. 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 276 Cursor not found.
In this blog post, let’s learn about the error message “276 Cursor not found.” in Hydra and the description of the error. Error Message 276 Cursor not found. Error Details The person who created this table has not granted Delete privilege to your account name or to the public. The owner of the table or the DBA must grant this privilege before you can delete…
Hydra Error 105 ISAM error: bad ISAM file format.
In this blog post, let’s learn about the error message “105 ISAM error: bad ISAM file format.” in Hydra and the description of the error. Error Message 105 ISAM error: bad ISAM file format. Error Details The ISAM processor has reached its limit of open files. For C-ISAM programs, review the program logic and change it so that fewer files are open concurrently. Use isclose…
Hydra Error 322 Cannot create a trigger on, alter, rename view view-name.
In this blog post, let’s learn about the error message “322 Cannot create a trigger on, alter, rename view view-name.” in Hydra and the description of the error. Error Message 322 Cannot create a trigger on, alter, rename view view-name. Error Details Starting with version 9.40, you can only create an INSTEAD OF trigger on a view. You cannot create an INSTEAD OF trigger on…
Hydra Error 219 Wildcard matching may not be used with non-character types.
In this blog post, let’s learn about the error message “219 Wildcard matching may not be used with non-character types.” in Hydra and the description of the error. Error Message 219 Wildcard matching may not be used with non-character types. Error Details (or SLV is undefined). The name appears in the select list or WHERE clause of this query but is not defined in a…
Hydra Error 284 A subquery has returned not exactly one row.
In this blog post, let’s learn about the error message “284 A subquery has returned not exactly one row.” in Hydra and the description of the error. Error Message 284 A subquery has returned not exactly one row. Error Details Inspect the current statement, examining the punctuation of all quoted strings. To include the quote character in a literal string, use single apostrophes as string…
Hydra Error 231 Cannot perform aggregate function with distinct on expression.
In this blog post, let’s learn about the error message “231 Cannot perform aggregate function with distinct on expression.” in Hydra and the description of the error. Error Message 231 Cannot perform aggregate function with distinct on expression. Error Details The database server cannot create a temporary disk file. The file should be created in the directory that the DBTEMP environment variable specifies (or /tmp…
Hydra Error 003 No such process.
In this blog post, let’s learn about the error message “003 No such process.” in Hydra and the description of the error. Error Message 003 No such process. 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 306 Subscript out of range.
In this blog post, let’s learn about the error message “306 Subscript out of range.” in Hydra and the description of the error. Error Message 306 Subscript out of range. Error Details This statement refers to a substring of a character variable. The substring values (two numbers in square brackets) are incorrect. The first is less than zero or greater than the length of the…
Hydra Error 005 I/O error.
In this blog post, let’s learn about the error message “005 I/O error.” in Hydra and the description of the error. Error Message 005 I/O error. 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. In particular, try to determine what device produced the error and…
Hydra Error 232 A SERIAL column column-name may not be updated.
In this blog post, let’s learn about the error message “232 A SERIAL column column-name may not be updated.” in Hydra and the description of the error. Error Message 232 A SERIAL column column-name may not be updated. Error Details The database server created a temporary file in the directory specified by the DBTEMP environment variable (or /tmp by default on UNIX systems) but encountered…