In this blog post, let’s learn about the error message “244 Could not do a physical-order read to fetch next row.” in Hydra and the description of the error. Error Message 244 Could not do a physical-order read to fetch next row. Error Details The database server cannot begin reading a table. Check the accompanying ISAM error code for more information. The problem might be…

In this blog post, let’s learn about the error message “372 Cannot alter table with audit trail on.” in Hydra and the description of the error. Error Message 372 Cannot alter table with audit trail on. Error Details Once an audit trail has been started for a table, the table should not be altered. If you must alter the table, do the following. Copy the…

In this blog post, let’s learn about the error message “329 Database not found or no system permission.” in Hydra and the description of the error. Error Message 329 Database not found or no system permission. Error Details The database you tried to open is not visible to the database server. Check the spelling of the name. Possibly the database is located in a different…

In this blog post, let’s learn about the error message “365 Cursor must be on simple SELECT for FOR UPDATE.” in Hydra and the description of the error. Error Message 365 Cursor must be on simple SELECT for FOR UPDATE. Error Details The cursor named in this statement (probably an OPEN statement) was declared with the FOR UPDATE clause. However, it has been associated with…

In this blog post, let’s learn about the error message “289 Cannot lock table table-name in requested mode.” in Hydra and the description of the error. Error Message 289 Cannot lock table table-name in requested mode. Error Details You cannot add a column of SERIAL data type to an existing table. Such columns may not contain null values, but when you add a column, the…

In this blog post, let’s learn about the error message “135 ISAM error: tblspace does not exist.” in Hydra and the description of the error. Error Message 135 ISAM error: tblspace does not exist. Error Details The ISAM processor needs to lock a row or an index page, but no locks are available. The number of locks that an operation requires depends primarily on the…

In this blog post, let’s learn about the error message “357 Dependent table for view view-name has been altered.” in Hydra and the description of the error. Error Message 357 Dependent table for view view-name has been altered. Error Details The view is based on data from a table that has been altered since the view was defined. The alteration removed or renamed a column…

In this blog post, let’s learn about the error message “102 ISAM error: illegal argument to ISAM function.” in Hydra and the description of the error. Error Message 102 ISAM error: illegal argument to ISAM function. Error Details The program attempted to use an unopened file, table, partition, tablespace, or other storage object, or one of these whose access mode did not support the requested…

In this blog post, let’s learn about the error message “375 Cannot create log file for transaction.” in Hydra and the description of the error. Error Message 375 Cannot create log file for transaction. Error Details While the database server was trying to execute a START statement, it got an unexpected error in trying to create the transaction-log file. Check the accompanying ISAM error code…

In this blog post, let’s learn about the error message “211 Cannot read system catalog .” in Hydra and the description of the error. Error Message 211 Cannot read system catalog . Error Details This statement contains a file pathname that exceeds the maximum length of 64 characters. Inspect the statement to make sure that the pathname is that long. It is possible a punctuation…

In this blog post, let’s learn about the error message “179 ISAM error: No free disk space for sort.” in Hydra and the description of the error. Error Message 179 ISAM error: No free disk space for sort. Error Details While performing a sort, the database server did not find enough contiguous free disk space to create necessary temporary files. You might have insufficient disk…

In this blog post, let’s learn about the error message “286 Default value of the primary key column column-name is NULL.” in Hydra and the description of the error. Error Message 286 Default value of the primary key column column-name is NULL. Error Details A subquery that is used in an expression in the place of a literal value must return only a single row…

In this blog post, let’s learn about the error message “241 Cannot rollback work.” in Hydra and the description of the error. Error Message 241 Cannot rollback work. Error Details The row that is being inserted (or being updated to have a new primary key) contains a duplicate value of some row that already exists, in a column or columns that are constrained to have…

In this blog post, let’s learn about the error message “156 Message number -156 not found.” in Hydra and the description of the error. Error Message 156 Message number -156 not found. Error Details This network operation has been suspended, awaiting a response from another database server, for the maximum duration allowed. The local database server assumes that a distributed deadlock exists and that this…

In this blog post, let’s learn about the error message “258 System error – invalid statement id received by the sqlexec process.” in Hydra and the description of the error. Error Message 258 System error – invalid statement id received by the sqlexec process. Error Details You cannot begin a transaction in this database because it does not have a transaction log. In order to…

In this blog post, let’s learn about the error message “237 Cannot begin work.” in Hydra and the description of the error. Error Message 237 Cannot begin work. Error Details This statement specifies a width for a column of CHAR data type that is greater than 32,767, or a width for a VARCHAR column that exceeds 255. If you need a column of this size,…

In this blog post, let’s learn about the error message “224 Cannot open transaction log file.” in Hydra and the description of the error. Error Message 224 Cannot open transaction log file. Error Details The database server created a temporary disk file but received an error while it attempted to write into the file. Check the accompanying ISAM error code, and look for operating-system messages…

In this blog post, let’s learn about the error message “346 Could not update a row in the table.” in Hydra and the description of the error. Error Message 346 Could not update a row in the table. Error Details While the database server was processing an UPDATE, it received an unexpected error. Check the accompanying ISAM error code for more detailed information on the…

In this blog post, let’s learn about the error message “106 ISAM error: non-exclusive access.” in Hydra and the description of the error. Error Message 106 ISAM error: non-exclusive access. Error Details The contents of an ISAM file (table or index) have been corrupted. For C-ISAM, if you used transaction logging, you can use the isrecover program to recover the file. Otherwise, re-create the file…

In this blog post, let’s learn about the error message “110 ISAM error: end or beginning of the file.” in Hydra and the description of the error. Error Message 110 ISAM error: end or beginning of the file. Error Details The ISAM processor has been asked to delete the primary key index. For C-ISAM programs, the isdelindex call cannot delete the primary key. If the…