Category: Hydra

Hydra Error 297 Cannot find unique constraint or primary key on referenced table .

In this blog post, let’s learn about the error message “297 Cannot find unique constraint or primary key on referenced table .” in Hydra and the description of the error. Error Message 297 Cannot find unique constraint or primary key on referenced table . Error Details Referential constraints cannot cross databases. In other words, both the referenced and referencing columns (or parent and child keys)…

Hydra Error 260 Cannot execute a SELECT statement that is PREPAREd – must use cursor.

In this blog post, let’s learn about the error message “260 Cannot execute a SELECT statement that is PREPAREd – must use cursor.” in Hydra and the description of the error. Error Message 260 Cannot execute a SELECT statement that is PREPAREd – must use cursor. Error Details The current statement (EXECUTE or OPEN) refers to a prepared SQL statement or a cursor that does…

Hydra Error 048 Address already in use.

In this blog post, let’s learn about the error message “048 Address already in use.” in Hydra and the description of the error. Error Message 048 Address already in use. 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 152 ISAM error: Illegal message type received from remote process.

In this blog post, let’s learn about the error message “152 ISAM error: Illegal message type received from remote process.” in Hydra and the description of the error. Error Message 152 ISAM error: Illegal message type received from remote process. Error Details You are using a demonstration version of the database server. This version has severe limits on the number of tables and the size…

Hydra Error 203 An illegal integer has been found in the statement.

In this blog post, let’s learn about the error message “203 An illegal integer has been found in the statement.” in Hydra and the description of the error. Error Message 203 An illegal integer has been found in the statement. Error Details A character that cannot be interpreted as part of an SQL statement is embedded in this statement. If a program constructed the statement,…

Hydra Error 181 ISAM error: No Optical Subsystem connection.

In this blog post, let’s learn about the error message “181 ISAM error: No Optical Subsystem connection.” in Hydra and the description of the error. Error Message 181 ISAM error: No Optical Subsystem connection. Error Details A storage space for TEXT or BYTE data has been defined with the same name as an Optical family name.

Hydra Error 136 ISAM error: no more extents.

In this blog post, let’s learn about the error message “136 ISAM error: no more extents.” in Hydra and the description of the error. Error Message 136 ISAM error: no more extents. Error Details This error might indicate corruption of control information in the root dbspace, a serious problem that might require restoring the system from archive. In the short term, roll back the current…

Hydra Error 353 No table or view specified when granting/revoking privileges.

In this blog post, let’s learn about the error message “353 No table or view specified when granting/revoking privileges.” in Hydra and the description of the error. Error Message 353 No table or view specified when granting/revoking privileges. Error Details This statement specifies one of the table-level privileges (ALTER, DELETE, INDEX, INSERT, SELECT, UPDATE, and ALL) but does not specify the table to which the…

Hydra Error 384 Cannot modify non simple view.

In this blog post, let’s learn about the error message “384 Cannot modify non simple view.” in Hydra and the description of the error. Error Message 384 Cannot modify non simple view. Error Details This statement attempts to modify (insert, delete, or update) rows in a view which does not have an appropriate INSTEAD OF trigger defined. Starting with version 9.40, you can define an…

Hydra Error 334 Cannot create audit trail.

In this blog post, let’s learn about the error message “334 Cannot create audit trail.” in Hydra and the description of the error. Error Message 334 Cannot create audit trail. Error Details Some problem prevents the database server from initializing the audit-trail file. Check that you specified a complete, correct pathname for the file. Look for operating-system error messages that might give more information. Common…

Hydra Error 044 Socket type not supported.

In this blog post, let’s learn about the error message “044 Socket type not supported.” in Hydra and the description of the error. Error Message 044 Socket type not supported. 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 226 Cannot create index for system catalog table-name.

In this blog post, let’s learn about the error message “226 Cannot create index for system catalog table-name.” in Hydra and the description of the error. Error Message 226 Cannot create index for system catalog table-name. Error Details The database server cannot open the file in which transaction-log entries are made. No transactions can start until this file is repaired. (In an ANSI-compliant database, nothing…