Category: Hydra

Hydra Error 386 Column contains null values.

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…

Hydra Error 391 Cannot insert a null into column column-name.

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…

Hydra Error 065 Host is unreachable.

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

Hydra Error 388 No resource permission.

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…

Hydra Error 060 Connection timed out.

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

Hydra Error 323 Cannot grant permission on temporary table.

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

Hydra Error 042 Option not supported by protocol.

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.

Hydra Error 164 ISAM error: TEXT or BYTE stamp is incorrect.

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…

Hydra Error 383 Need to specify view column names in the view definition.

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…

Hydra Error 321 Cannot group by aggregate column.

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…

Hydra Error 331 Cannot drop database directory.

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…

Hydra Error 025 Not a typewriter.

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…