Category: Hydra

Hydra Error 129 ISAM error: too many users.

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…

Hydra Error 155 ISAM error: Primary and Mirror chunks are bad.

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…

Hydra Error 168 ISAM error: archive is blocking storage space allocation.

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…

Hydra Error 245 Could not position within a file via an index.

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…

Hydra Error 217 Column column-name not found in any table in the query

In this blog post, let’s learn about the error message “217 Column column-name not found in any table in the query” in Hydra and the description of the error. Error Message 217 Column column-name not found in any table in the query Error Details The database server cannot open the operating-system file or files in which the table is stored. Check the accompanying ISAM error…

Hydra Error 265 Load or insert cursors must be run within a transaction.

In this blog post, let’s learn about the error message “265 Load or insert cursors must be run within a transaction.” in Hydra and the description of the error. Error Message 265 Load or insert cursors must be run within a transaction. Error Details This statement, probably a FETCH statement that names a cursor declared FOR UPDATE, failed because the row it should have fetched…

Hydra Error 269 Cannot add column column-name that does not accept nulls.

In this blog post, let’s learn about the error message “269 Cannot add column column-name that does not accept nulls.” in Hydra and the description of the error. Error Message 269 Cannot add column column-name that does not accept nulls. Error Details The FREE statement released the resources that are attached to the cursor named in this statement. Before you can use the cursor, you…

Hydra Error 287 Cannot add serial column column-name to table.

In this blog post, let’s learn about the error message “287 Cannot add serial column column-name to table.” in Hydra and the description of the error. Error Message 287 Cannot add serial column column-name to table. Error Details The cursor that this statement uses has not been properly declared or prepared, or the FREE statement has released it. Review the program logic to ensure that…

Hydra Error 123 ISAM error: no shared memory.

In this blog post, let’s learn about the error message “123 ISAM error: no shared memory.” in Hydra and the description of the error. Error Message 123 ISAM error: no shared memory. Error Details The ISAM processor has been asked to mark the start or end of a transaction, but transaction logging is not in effect. For C-ISAM programs, this file was not opened with…

Hydra Error 300 There are too many GROUP BY columns.

In this blog post, let’s learn about the error message “300 There are too many GROUP BY columns.” in Hydra and the description of the error. Error Message 300 There are too many GROUP BY columns. Error Details The number of columns that can be listed in the GROUP BY clause is an implementation limit of the database server. All database servers support at least…

Hydra Error 053 Software caused connection abort.

In this blog post, let’s learn about the error message “053 Software caused connection abort.” in Hydra and the description of the error. Error Message 053 Software caused connection abort. 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….

Hydra Error 018 Cross-device link.

In this blog post, let’s learn about the error message “018 Cross-device link.” in Hydra and the description of the error. Error Message 018 Cross-device link. 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.