In this blog post, let’s learn about the error message “137 ISAM error: chunk table overflow.” in Hydra and the description of the error. Error Message 137 ISAM error: chunk table overflow. Error Details The database server needs to add an extent to a table but cannot do so. Either not enough disk space is available in the dbspace, or the table has been given…

In this blog post, let’s learn about the error message “040 Message too long.” in Hydra and the description of the error. Error Message 040 Message too long. 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 “047 Address family not supported by protocol family.” in Hydra and the description of the error. Error Message 047 Address family not supported by protocol family. 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…

In this blog post, let’s learn about the error message “059 Too many references: can’t splice.” in Hydra and the description of the error. Error Message 059 Too many references: can’t splice. 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 “118 ISAM error: cannot read log record.” in Hydra and the description of the error. Error Message 118 ISAM error: cannot read log record. Error Details No current Informix product displays this message. If the error recurs, please note all circumstances and contact Informix Technical Support.

In this blog post, let’s learn about the error message “373 DBPATH too long.” in Hydra and the description of the error. Error Message 373 DBPATH too long. Error Details While the database server was trying to locate a database using the DBPATH environment variable, it constructed a full-path string that exceeds its limit of 80 characters. A limit exists on the length of one…

In this blog post, let’s learn about the error message “128 ISAM error: no logging.” in Hydra and the description of the error. Error Message 128 ISAM error: no logging. Error Details The ISAM processor was called for a function that requires a unique primary-key index, but no such index exists for this file. For C-ISAM programs, review the design of the data file; it…

In this blog post, let’s learn about the error message “043 Protocol not supported.” in Hydra and the description of the error. Error Message 043 Protocol not supported. 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 “015 Block device required.” in Hydra and the description of the error. Error Message 015 Block device required. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. An error might exist in the configuration of the database software. That error might include an incorrect address in the…

In this blog post, let’s learn about the error message “223 Duplicate table name table-name in the FROM clause.” in Hydra and the description of the error. Error Message 223 Duplicate table name table-name in the FROM clause. Error Details The database server cannot create a temporary disk file. The file should be created in the directory specified by the DBTEMP environment variable. If DBTEMP…

In this blog post, let’s learn about the error message “180 Message number -180 not found.” in Hydra and the description of the error. Error Message 180 Message number -180 not found. Error Details The Optical subsystem is not present. This message usually means that you requested an Optical operation on a database server that is being used without the Optical subsystem or INFORMIX-OnLine/Optical.

In this blog post, let’s learn about the error message “363 CURSOR not on SELECT statement.” in Hydra and the description of the error. Error Message 363 CURSOR not on SELECT statement. Error Details The cursor named in this statement (probably an OPEN) has been associated with a prepared statement that is not a SELECT statement. Review the program logic, especially the DECLARE for the…

In this blog post, let’s learn about the error message “370 Cannot drop last column.” in Hydra and the description of the error. Error Message 370 Cannot drop last column. Error Details This ALTER TABLE DROP statement would drop every column from the table. At least one column must be retained. Revise the statement to leave one column. Or if you do not want the…

In this blog post, let’s learn about the error message “339 The audit trail file name must be given in full directory path.” in Hydra and the description of the error. Error Message 339 The audit trail file name must be given in full directory path. Error Details The audit-trail file that is specified in the CREATE AUDIT statement requires a full directory path. Because…

In this blog post, let’s learn about the error message “238 Cannot commit work.” in Hydra and the description of the error. Error Message 238 Cannot commit work. Error Details Each column that is named or implied in an INSERT statement must have a separate value expression. If the statement does not list specific columns, review the definition of the table for the number of…

In this blog post, let’s learn about the error message “027 File too large.” in Hydra and the description of the error. Error Message 027 File too large. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. Check the documentation for your operating system to find out what too large might mean in the context of the…

In this blog post, let’s learn about the error message “030 Read-only file system.” in Hydra and the description of the error. Error Message 030 Read-only file system. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. An entire file system (a disk or disk partition) has been made read-only. Contact your system administrator to find out…

In this blog post, let’s learn about the error message “249 Virtual column must have explicit name.” in Hydra and the description of the error. Error Message 249 Virtual column must have explicit name. Error Details The database server could not apply an audit trail to roll a database forward. Check the accompanying ISAM error code for more information.

In this blog post, let’s learn about the error message “166 ISAM error: Storage space is full.” in Hydra and the description of the error. Error Message 166 ISAM error: Storage space is full. Error Details This internal error should not occur. The database server has called the isbcreate function for a table column that is not defined as BYTE or TEXT. If the error…

In this blog post, let’s learn about the error message “288 Table table-name not locked by current user.” in Hydra and the description of the error. Error Message 288 Table table-name not locked by current user. Error Details A column that is part of a primary key cannot have null as its default value.