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…

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…

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…

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…

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…

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…

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….

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.

In this blog post, let’s learn about the error message “305 Subscripted column column-name is not of type CHAR, VARCHAR, TEXT nor BYTES.” in Hydra and the description of the error. Error Message 305 Subscripted column column-name is not of type CHAR, VARCHAR, TEXT nor BYTES. Error Details You may select substrings only from columns of the types mentioned. Review all uses of square brackets…

In this blog post, let’s learn about the error message “125 ISAM error: can’t use nfs.” in Hydra and the description of the error. Error Message 125 ISAM error: can’t use nfs. Error Details The ISAM processor has been asked to mark the end of a transaction, but no transaction has been started. For C-ISAM programs, review the program logic to make sure that it…

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

In this blog post, let’s learn about the error message “122 ISAM error: transaction not available.” in Hydra and the description of the error. Error Message 122 ISAM error: transaction not available. Error Details The ISAM processor is trying to add a record to the transaction log but has received an error from the operating system. The disk might be full. Look for operating-system error…

In this blog post, let’s learn about the error message “252 Cannot get system information for table.” in Hydra and the description of the error. Error Message 252 Cannot get system information for table. Error Details The database server cannot get a row of a table prior to update. Check the accompanying ISAM error code for more information. Possibly another user has locked the row…

In this blog post, let’s learn about the error message “142 ISAM error: overflow of tblspace page.” in Hydra and the description of the error. Error Message 142 ISAM error: overflow of tblspace page. Error Details A DR secondary server is meant for read-only operations. Any kind of write operation to a nontemporary dbspace is not allowed. For example, you cannot create a table in…

In this blog post, let’s learn about the error message “170 ISAM error: illegal use of a storage space for TEXT or BYTE data.” in Hydra and the description of the error. Error Message 170 ISAM error: illegal use of a storage space for TEXT or BYTE data. Error Details When a storage space containing TEXT or BYTE data has been extended by adding a…

In this blog post, let’s learn about the error message “296 Referenced table table-name not found.” in Hydra and the description of the error. Error Message 296 Referenced table table-name not found. Error Details In a grouping SELECT, you must list every nonaggregate column in the GROUP BY clause to ensure that a well-defined value exists for each selected column in each grouped row. A…

In this blog post, let’s learn about the error message “074 Out of stream resources.” in Hydra and the description of the error. Error Message 074 Out of stream resources. 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 “335 There is no audit trail for the specified table.” in Hydra and the description of the error. Error Message 335 There is no audit trail for the specified table. Error Details This statement requires an audit trail to work, but no current audit trail exists for the table. Either none was ever started, or…

In this blog post, let’s learn about the error message “072 Not a stream device.” in Hydra and the description of the error. Error Message 072 Not a stream device. 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, particularly which device is involved. If the…

In this blog post, let’s learn about the error message “359 Cannot drop current database.” in Hydra and the description of the error. Error Message 359 Cannot drop current database. Error Details The database that is currently open cannot be dropped. First use the CLOSE DATABASE statement; then you can drop it.