In this blog post, let’s learn about the error message “075 No message of desired type.” in Hydra and the description of the error. Error Message 075 No message of desired type. 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 “146 ISAM error: the other copy of this disk is currently disabled or non-existent.” in Hydra and the description of the error. Error Message 146 ISAM error: the other copy of this disk is currently disabled or non-existent. Error Details The current operation inserts a row with a certain primary key value or updates a…

In this blog post, let’s learn about the error message “221 Cannot build temporary file for new table table-name.” in Hydra and the description of the error. Error Message 221 Cannot build temporary file for new table table-name. Error Details The WHERE clause in this statement includes a test of a noncharacter column using the LIKE or MATCHES keyword and the special characters that stand…

In this blog post, let’s learn about the error message “293 IS [NOT] NULL predicate may be used only with simple columns.” in Hydra and the description of the error. Error Message 293 IS [NOT] NULL predicate may be used only with simple columns. Error Details The current LOCK TABLE statement cannot be executed because you have already locked the same table using a different mode (EXCLUSIVE…

In this blog post, let’s learn about the error message “382 Same number of columns must be specified for view and select clause.” in Hydra and the description of the error. Error Message 382 Same number of columns must be specified for view and select clause. Error Details In this VIEW statement, you have listed the names of the columns of the view. However, their…

In this blog post, let’s learn about the error message “113 ISAM error: the file is locked.” in Hydra and the description of the error. Error Message 113 ISAM error: the file is locked. Error Details The ISAM processor has been asked to return the current record, but none has been established. For C-ISAM programs, review the program logic. Before the program uses the ISCURR…

In this blog post, let’s learn about the error message “068 Too many users.” in Hydra and the description of the error. Error Message 068 Too many users. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. This error probably reflects a limit configured in your operating system. Look for other operating-system error messages that might give…

In this blog post, let’s learn about the error message “107 ISAM error: record is locked.” in Hydra and the description of the error. Error Message 107 ISAM error: record is locked. Error Details The ISAM processor has been asked to add or drop an index but it does not have exclusive access. For C-ISAM programs, the file must be opened with exclusive access before…

In this blog post, let’s learn about the error message “062 Too many levels of symbolic links.” in Hydra and the description of the error. Error Message 062 Too many levels of symbolic links. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. The database server does not normally use symbolic links. Look for other operating-system error…

In this blog post, let’s learn about the error message “270 Could not position within a temporary file.” in Hydra and the description of the error. Error Message 270 Could not position within a temporary file. Error Details During execution of this statement, a duplicate value was introduced into a column or columns that a unique constraint protects. The row with the duplicate value was…

In this blog post, let’s learn about the error message “026 Text file busy.” in Hydra and the description of the error. Error Message 026 Text file busy. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the current operation requires the use of a text file (such as the input file to LOAD or to…

In this blog post, let’s learn about the error message “158 ISAM error: Operation disallowed on SMI pseudo table.” in Hydra and the description of the error. Error Message 158 ISAM error: Operation disallowed on SMI pseudo table. Error Details An interrupt that was detected from client process has terminated the operation. Restart the operation.

In this blog post, let’s learn about the error message “119 ISAM error: bad log record.” in Hydra and the description of the error. Error Message 119 ISAM error: bad log record. Error Details The ISAM processor is trying to roll back a transaction or recover a file but has encountered an error while reading the transaction log. Look for operating-system error messages that might…

In this blog post, let’s learn about the error message “327 Cannot unlock table table-name within a transaction.” in Hydra and the description of the error. Error Message 327 Cannot unlock table table-name within a transaction. Error Details The statement UNLOCK TABLE is not allowed within a transaction, that is, following the execution of BEGIN WORK. You can still use LOCK TABLE when you use…

In this blog post, let’s learn about the error message “165 ISAM error: TEXT or BYTE column does not exist.” in Hydra and the description of the error. Error Message 165 ISAM error: TEXT or BYTE column does not exist. Error Details This operation has returned an invalid BYTE or TEXT value. Possibly the data pages have been corrupted. Roll back the current transaction. Have…

In this blog post, let’s learn about the error message “009 Bad file number.” in Hydra and the description of the error. Error Message 009 Bad file number. 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…

In this blog post, let’s learn about the error message “129 ISAM error: too many users.” in Hydra and the description of the error. Error Message 129 ISAM error: too many users. Error Details The ISAM processor was called for a function that requires a transaction log, but none exists for this file. For C-ISAM programs, review the creation of the data file. Before the…

In this blog post, let’s learn about the error message “155 ISAM error: Primary and Mirror chunks are bad.” in Hydra and the description of the error. Error Message 155 ISAM error: Primary and Mirror chunks are bad. Error Details The ISAM processor has been asked to lock or unlock the current file (table), but the file was not opened in the appropriate mode. For…

In this blog post, let’s learn about the error message “168 ISAM error: archive is blocking storage space allocation.” in Hydra and the description of the error. Error Message 168 ISAM error: archive is blocking storage space allocation. Error Details The database server administrator sees this error. When you define a storage space, you must specify a page size that is an integral multiple of…

In this blog post, let’s learn about the error message “245 Could not position within a file via an index.” in Hydra and the description of the error. Error Message 245 Could not position within a file via an index. Error Details The database server cannot set the file position to a particular row within the file that represents a table. Check the accompanying ISAM…