In this blog post, let’s learn about the error message “352 Column column-name not found.” in Hydra and the description of the error. Error Message 352 Column column-name not found. Error Details The column, or one of the columns, named in this CREATE INDEX statement does not exist. Review the spellings of all columns in the statement. See the discussion of error -328 for a…

In this blog post, let’s learn about the error message “055 No buffer space available.” in Hydra and the description of the error. Error Message 055 No buffer space available. 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 this blog post, let’s learn about the error message “236 Number of columns in INSERT does not match number of VALUES.” in Hydra and the description of the error. Error Message 236 Number of columns in INSERT does not match number of VALUES. Error Details This INSERT statement is directed to a view, not to a real table, and one of the columns that…

In this blog post, let’s learn about the error message “395” in Hydra and the description of the error. Error Message 395 Error Details System catalog corrupted. This internal error should not occur. The database server has encountered something in one or more of the system catalog tables that violates integrity constraints. Run the oncheck utility if you are using Informix Dynamic Server, INFORMIX-Universal Server,…

In this blog post, let’s learn about the error message “340 Cannot open audit trail file.” in Hydra and the description of the error. Error Message 340 Cannot open audit trail file. Error Details The database server needs to use the audit-trail file for this table, but some unexpected problem prevents it. Likely causes include hardware errors, file-permission problems, or the accidental erasure of the…

In this blog post, let’s learn about the error message “247 Rollforward database failed.” in Hydra and the description of the error. Error Message 247 Rollforward database failed. Error Details The database server encountered an error when it attempted to look up a row through an index. Check the accompanying ISAM error code for more information. The table file or the index file might have…

In this blog post, let’s learn about the error message “049 Can’t assign requested address.” in Hydra and the description of the error. Error Message 049 Can’t assign requested address. 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 “290 Cursor not declared with FOR UPDATE clause.” in Hydra and the description of the error. Error Message 290 Cursor not declared with FOR UPDATE clause. Error Details This UNLOCK TABLE statement names a table that has not been locked. If you locked the table earlier, it has already been unlocked. Tables are unlocked automatically…

In this blog post, let’s learn about the error message “243 Could not position within a table table-name.” in Hydra and the description of the error. Error Message 243 Could not position within a table table-name. Error Details The database server cannot execute a ROLLBACK 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 “274 No DELETE permission.” in Hydra and the description of the error. Error Message 274 No DELETE permission. Error Details The person who created this table has not granted Select privilege to your account name or to the public. The owner of the table or the DBA must grant this privilege before you can select…

In this blog post, let’s learn about the error message “349 Database not selected yet.” in Hydra and the description of the error. Error Message 349 Database not selected yet. Error Details This statement cannot be executed because no current database exists. Either no current database has been established yet, or the current database was closed with a CLOSE DATABASE statement. You execute the DATABASE…

In this blog post, let’s learn about the error message “172 ISAM error: Unexpected internal error.” in Hydra and the description of the error. Error Message 172 ISAM error: Unexpected internal error. Error Details A program that uses a particular locking method or index-node size has attempted to access an ISAM file that was created using a different locking method or index-node size. If you…

In this blog post, let’s learn about the error message “297 Cannot find unique constraint or primary key on referenced table .” in Hydra and the description of the error. Error Message 297 Cannot find unique constraint or primary key on referenced table . Error Details Referential constraints cannot cross databases. In other words, both the referenced and referencing columns (or parent and child keys)…

In this blog post, let’s learn about the error message “260 Cannot execute a SELECT statement that is PREPAREd – must use cursor.” in Hydra and the description of the error. Error Message 260 Cannot execute a SELECT statement that is PREPAREd – must use cursor. Error Details The current statement (EXECUTE or OPEN) refers to a prepared SQL statement or a cursor that does…

In this blog post, let’s learn about the error message “048 Address already in use.” in Hydra and the description of the error. Error Message 048 Address already in use. 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 “152 ISAM error: Illegal message type received from remote process.” in Hydra and the description of the error. Error Message 152 ISAM error: Illegal message type received from remote process. Error Details You are using a demonstration version of the database server. This version has severe limits on the number of tables and the size…

In this blog post, let’s learn about the error message “203 An illegal integer has been found in the statement.” in Hydra and the description of the error. Error Message 203 An illegal integer has been found in the statement. Error Details A character that cannot be interpreted as part of an SQL statement is embedded in this statement. If a program constructed the statement,…

In this blog post, let’s learn about the error message “181 ISAM error: No Optical Subsystem connection.” in Hydra and the description of the error. Error Message 181 ISAM error: No Optical Subsystem connection. Error Details A storage space for TEXT or BYTE data has been defined with the same name as an Optical family name.

In this blog post, let’s learn about the error message “136 ISAM error: no more extents.” in Hydra and the description of the error. Error Message 136 ISAM error: no more extents. Error Details This error might indicate corruption of control information in the root dbspace, a serious problem that might require restoring the system from archive. In the short term, roll back the current…

In this blog post, let’s learn about the error message “353 No table or view specified when granting/revoking privileges.” in Hydra and the description of the error. Error Message 353 No table or view specified when granting/revoking privileges. Error Details This statement specifies one of the table-level privileges (ALTER, DELETE, INDEX, INSERT, SELECT, UPDATE, and ALL) but does not specify the table to which the…