In this blog post, let’s learn about the error message “324 Ambiguous column column-name.” in Hydra and the description of the error. Error Message 324 Ambiguous column column-name. Error Details The column name appears in more than one of the tables that are listed in the FROM clause of this query. The database server needs to know which columns to use. Revise the statement so…

In this blog post, let’s learn about the error message “348 Could not read a row from the table.” in Hydra and the description of the error. Error Message 348 Could not read a row from the table. Error Details While the database server was trying to fetch a row from a table, it received an unexpected error. Check the accompanying ISAM error code for…

In this blog post, let’s learn about the error message “272 No SELECT permission.” in Hydra and the description of the error. Error Message 272 No SELECT permission. 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 an error when it tried to position (seek) within it….

In this blog post, let’s learn about the error message “149 ISAM error: INFORMIX-OnLine daemon is no longer running.” in Hydra and the description of the error. Error Message 149 ISAM error: INFORMIX-OnLine daemon is no longer running. Error Details The database server administrator sees this error. The action that you have requested cannot be carried out while an archive is being made. For example,…

In this blog post, let’s learn about the error message “319 Index does not exist.” in Hydra and the description of the error. Error Message 319 Index does not exist. Error Details This statement refers to an index that does not exist. Review the spelling of the index name; if it is as you intended, and you are sure it should exist, make sure you…

In this blog post, let’s learn about the error message “347 Could not open table for exclusive access.” in Hydra and the description of the error. Error Message 347 Could not open table for exclusive access. Error Details The database server cannot complete a LOCK TABLE statement or the implicit LOCK TABLE that must be performed as part of other statements that change the definition…

In this blog post, let’s learn about the error message “103 ISAM error: illegal key descriptor (too many parts or too long).” in Hydra and the description of the error. Error Message 103 ISAM error: illegal key descriptor (too many parts or too long). Error Details A parameter that was presented to one of the C-ISAM functions is outside the range of acceptable values. For…

In this blog post, let’s learn about the error message “031 Too many links.” in Hydra and the description of the error. Error Message 031 Too many links. 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, especially which file or files are involved. If the…

In this blog post, let’s learn about the error message “160 ISAM error: only one TEXT or BYTE field may be open at any time.” in Hydra and the description of the error. Error Message 160 ISAM error: only one TEXT or BYTE field may be open at any time. Error Details You are attempting to use a collation sequence that is either not supported…

In this blog post, let’s learn about the error message “343 Row from audit trail was added to a different position than expected.” in Hydra and the description of the error. Error Message 343 Row from audit trail was added to a different position than expected. Error Details While the database server was reconstructing a table from the audit trail, it found a discrepancy between…

In this blog post, let’s learn about the error message “234 Cannot insert into virtual column column-name.” in Hydra and the description of the error. Error Message 234 Cannot insert into virtual column column-name. Error Details You cannot alter the contents of a column with the SERIAL data type in the UPDATE statement, even when the updating value is zero. (You can specify a value…

In this blog post, let’s learn about the error message “029 Illegal seek.” in Hydra and the description of the error. Error Message 029 Illegal seek. 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, such as the device on which the error occurred. If the…

In this blog post, let’s learn about the error message “371 Cannot create unique index on column with duplicate data.” in Hydra and the description of the error. Error Message 371 Cannot create unique index on column with duplicate data. Error Details This CREATE UNIQUE INDEX statement cannot be completed because the column (or columns) contains one or more duplicate rows. You can either create…

In this blog post, let’s learn about the error message “214 Cannot remove file for table table-name.” in Hydra and the description of the error. Error Message 214 Cannot remove file for table table-name. Error Details This statement attempts to add an index, either explicitly with CREATE INDEX or implicitly as part of processing a SELECT on multiple unindexed tables. In any case, some error…

In this blog post, let’s learn about the error message “012 Not enough core.” in Hydra and the description of the error. Error Message 012 Not enough core. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Core probably refers to data space in memory that an operating-system function needed. Look for other operating-system error messages that…

In this blog post, let’s learn about the error message “307 Illegal subscript definition.” in Hydra and the description of the error. Error Message 307 Illegal subscript definition. 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 column, or…

In this blog post, let’s learn about the error message “312 Cannot update system catalog table-name.” in Hydra and the description of the error. Error Message 312 Cannot update system catalog table-name. Error Details The database server cannot record a change in the system-catalog table. Check the accompanying ISAM error code for more detailed information. Insufficient disk space is a common cause of this error.

In this blog post, let’s learn about the error message “279 Cannot grant or revoke database privileges for table or view.” in Hydra and the description of the error. Error Message 279 Cannot grant or revoke database privileges for table or view. Error Details This UPDATE WHERE CURRENT OF cursor statement refers to a different table than the table referenced by the SELECT statement that…

In this blog post, let’s learn about the error message “076 Not a data message.” in Hydra and the description of the error. Error Message 076 Not a data message. 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 “381 Cannot grant to someone who has granted you the same privilege before.” in Hydra and the description of the error. Error Message 381 Cannot grant to someone who has granted you the same privilege before. Error Details The privilege you are trying to grant is one that was first granted to you WITH GRANT…