In this blog post, let’s learn about the error message “320 Not owner of index.” in Hydra and the description of the error. Error Message 320 Not owner of index. Error Details This statement tries to do something, such as dropping an index, that only the owner of the index or a user who has Database Administrator privileges can do. Check that the statement names…

In this blog post, let’s learn about the error message “109 ISAM error: the key is the file’s primary key.” in Hydra and the description of the error. Error Message 109 ISAM error: the key is the file’s primary key. Error Details The ISAM processor has been asked to create an index that already exists. For C-ISAM programs, review the program logic. The program must…

In this blog post, let’s learn about the error message “019 No such device.” in Hydra and the description of the error. Error Message 019 No such device. 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 “344 Cannot delete row – row in table does not match row in audit trail.” in Hydra and the description of the error. Error Message 344 Cannot delete 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…

In this blog post, let’s learn about the error message “390 Synonym already used as table name or synonym.” in Hydra and the description of the error. Error Message 390 Synonym already used as table name or synonym. Error Details This CREATE SYNONYM statement names a synonym that is already in use. To see all the synonym and table names currently defined, query systables as…

In this blog post, let’s learn about the error message “061 Connection refused.” in Hydra and the description of the error. Error Message 061 Connection refused. 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. If not, please note…

In this blog post, let’s learn about the error message “056 Socket is already connected.” in Hydra and the description of the error. Error Message 056 Socket is already connected. 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 “261 Cannot create file for table table-name.” in Hydra and the description of the error. Error Message 261 Cannot create file for table table-name. Error Details The current statement refers to a cursor that has not been opened. Review the logic of the program to see how it failed to execute the OPEN statement before…

In this blog post, let’s learn about the error message “308 Corresponding column types must be compatible for each UNION statement.” in Hydra and the description of the error. Error Message 308 Corresponding column types must be compatible for each UNION statement. Error Details All rows produced in a union of SELECT statements must have the same format, so the corresponding columns for each UNION…

In this blog post, let’s learn about the error message “150 The limits of the INFORMIX Demo Version have been exceeded.” in Hydra and the description of the error. Error Message 150 The limits of the INFORMIX Demo Version have been exceeded. Error Details The database server administrator sees this error. You cannot remove a dbspace until all tables that are in it have been…

In this blog post, let’s learn about the error message “143 ISAM error: deadlock detected.” in Hydra and the description of the error. Error Message 143 ISAM error: deadlock detected. Error Details The database server is configured to handle a certain number of open tblspaces (which correspond approximately to tables). This limit has been reached, so a table that is used in this statement could…

In this blog post, let’s learn about the error message “264 Could not write to a temporary file.” in Hydra and the description of the error. Error Message 264 Could not write to a temporary file. Error Details This internal error should not occur. Note all the details of the network software in use and the version number of the database servers in this and…

In this blog post, let’s learn about the error message “124 ISAM error: no begin work yet.” in Hydra and the description of the error. Error Message 124 ISAM error: no begin work yet. Error Details This implementation of ISAM uses shared memory; however, the shared-memory partition has not been established. Contact the system administrator or the person who installed the product.

In this blog post, let’s learn about the error message “126 ISAM error: bad row id.” in Hydra and the description of the error. Error Message 126 ISAM error: bad row id. Error Details The ISAM processor has been asked to open a file that is located on a disk attached to another computer and that is accessed using the Network File System (NFS). This…

In this blog post, let’s learn about the error message “133 ISAM error: audit trail exists.” in Hydra and the description of the error. Error Message 133 ISAM error: audit trail exists. Error Details The limit on a single row is the disk page size that the database server supports. Define the table differently, so that each row is shorter. Consider splitting the table into…

In this blog post, let’s learn about the error message “116 ISAM error: cannot allocate memory.” in Hydra and the description of the error. Error Message 116 ISAM error: cannot allocate memory. Error Details The ISAM processor has been asked to access a file or row using locking. Because this operating system uses files for locking, ISAM must create a tablename.lok file. When it tried…

In this blog post, let’s learn about the error message “251 ORDER BY or GROUP BY column number is too big.” in Hydra and the description of the error. Error Message 251 ORDER BY or GROUP BY column number is too big. Error Details When you select INTO TEMP, you are creating a table. As with any table, the columns of a temporary table must…

In this blog post, let’s learn about the error message “273 No UPDATE permission.” in Hydra and the description of the error. Error Message 273 No UPDATE permission. Error Details This problem has many possible causes, including a locked table or a full disk. Check the accompanying ISAM error code for more information.

In this blog post, let’s learn about the error message “108 ISAM error: key already exists.” in Hydra and the description of the error. Error Message 108 ISAM error: key already exists. Error Details Another user request has locked the record that you requested or the file (table) that contains it. This condition is normally transient. A program can recover by rolling back the current…

In this blog post, let’s learn about the error message “078 Deadlock situation detected/avoided.” in Hydra and the description of the error. Error Message 078 Deadlock situation detected/avoided. 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. Under AIX, this code means connection timed…