In this blog post, let’s learn about the error message “386 Column contains null values.” in Hydra and the description of the error. Error Message 386 Column contains null values. Error Details This ALTER TABLE statement contains a MODIFY clause that assigns the NOT NULL attribute to an existing column. However, that column already contains one or more null values. The modification cannot be made…

In this blog post, let’s learn about the error message “391 Cannot insert a null into column column-name.” in Hydra and the description of the error. Error Message 391 Cannot insert a null into column column-name. Error Details This statement tries to put a null value in the noted column. However, that column has been defined as NOT NULL. Roll back the current transaction. If…

In this blog post, let’s learn about the error message “065 Host is unreachable.” in Hydra and the description of the error. Error Message 065 Host is unreachable. 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 “388 No resource permission.” in Hydra and the description of the error. Error Message 388 No resource permission. Error Details If you issued a CREATE TABLE, CREATE INDEX, or CREATE PROCEDURE statement, you cannot execute this statement because your account has not been granted the RESOURCE privilege for this database. You need the RESOURCE privilege…

In this blog post, let’s learn about the error message “060 Connection timed out.” in Hydra and the description of the error. Error Message 060 Connection timed out. 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 “323 Cannot grant permission on temporary table.” in Hydra and the description of the error. Error Message 323 Cannot grant permission on temporary table. Error Details This GRANT statement names a temporary table. That action is not supported. Privileges are recorded only for permanent tables. Because temporary tables are not recorded in the system catalogs,…

In this blog post, let’s learn about the error message “042 Option not supported by protocol.” in Hydra and the description of the error. Error Message 042 Option not supported by protocol. 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 “164 ISAM error: TEXT or BYTE stamp is incorrect.” in Hydra and the description of the error. Error Message 164 ISAM error: TEXT or BYTE stamp is incorrect. Error Details The database server is reporting evidence of corruption of the database. Each disk page has time stamps at each end that should be identical when…

In this blog post, let’s learn about the error message “383 Need to specify view column names in the view definition.” in Hydra and the description of the error. Error Message 383 Need to specify view column names in the view definition. Error Details In this VIEW statement, you have not listed specific names for columns. That action is allowed when the SELECT statement selects…

In this blog post, let’s learn about the error message “321 Cannot group by aggregate column.” in Hydra and the description of the error. Error Message 321 Cannot group by aggregate column. Error Details The GROUP BY clause in this statement refers to a selected value that is an aggregate function. This action is not supported. (It does not make sense to group rows using…

In this blog post, let’s learn about the error message “331 Cannot drop database directory.” in Hydra and the description of the error. Error Message 331 Cannot drop database directory. Error Details While the database server was executing the DROP DATABASE statement, it removed all database-related files from the dbname.dbs directory and tried to remove the directory itself, but an error occurred. Check the accompanying…

In this blog post, let’s learn about the error message “025 Not a typewriter.” in Hydra and the description of the error. Error Message 025 Not a typewriter. 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 “350 Index already exists on column.” in Hydra and the description of the error. Error Message 350 Index already exists on column. Error Details This CREATE INDEX statement cannot be executed because an index on the same column or combination of columns already exists.At most two indexes can exist on any combination of columns, one…

In this blog post, let’s learn about the error message “017 File exists.” in Hydra and the description of the error. Error Message 017 File exists. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. This error may reflect an attempt in a REPORT TO specification to replace an existing file. Look for other operating-system error messages…

In this blog post, let’s learn about the error message “154 ISAM error: Lock Timeout Expired.” in Hydra and the description of the error. Error Message 154 ISAM error: Lock Timeout Expired. Error Details This internal error should not occur. Note all the details about the network software in use and the version level of the database servers in this and the other host system….

In this blog post, let’s learn about the error message “366 The scale exceeds the maximum precision specified.” in Hydra and the description of the error. Error Message 366 The scale exceeds the maximum precision specified. Error Details A problem exists with the precision or scale of a DECIMAL or a MONEY data type in this statement. Review all uses of these types. The first…

In this blog post, let’s learn about the error message “174 ISAM error: An error has occurred during archive back up.” in Hydra and the description of the error. Error Message 174 ISAM error: An error has occurred during archive back up. Error Details This generic message indicates that the logical-log backup has failed. The SQL API also contains useful error text that is associated…

In this blog post, let’s learn about the error message “310 Table table-name already exists in database.” in Hydra and the description of the error. Error Message 310 Table table-name already exists in database. Error Details This statement tries to create a table with the name that is shown, but one with that name already exists. Only one table with a given name can exist…

In this blog post, let’s learn about the error message “130 ISAM error: no such dbspace.” in Hydra and the description of the error. Error Message 130 ISAM error: no such dbspace. Error Details This implementation of ISAM uses shared memory, and it has reached the maximum number of concurrent users for which the shared memory was configured. You might need to increase the value…

In this blog post, let’s learn about the error message “325 Filename must be specified with a full path name.” in Hydra and the description of the error. Error Message 325 Filename must be specified with a full path name. Error Details This error occurs if you attempt to create a table using the WITH LOG IN clause but do not specify a complete path…