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…

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…

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.

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…

In this blog post, let’s learn about the error message “368 Incompatible sqlexec module.” in Hydra and the description of the error. Error Message 368 Incompatible sqlexec module. Error Details The version of the database server does not agree with the version of the database library routines in the application program. This incompatibility must be resolved before the program can be executed. The database server…

In this blog post, let’s learn about the error message “361 Column size too large.” in Hydra and the description of the error. Error Message 361 Column size too large. Error Details This internal error reflects a communications problem between the database server and the application. You should not see this error. If the error recurs, please note all circumstances and contact Informix Technical Support.

In this blog post, let’s learn about the error message “069 Disc quota exceeded.” in Hydra and the description of the error. Error Message 069 Disc quota exceeded. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. A disk-quota limit is probably configured in your operating system. Look for other operating-system error messages that might give more…

In this blog post, let’s learn about the error message “157 ISAM error: Interrupted ISAM call.” in Hydra and the description of the error. Error Message 157 ISAM error: Interrupted ISAM call. Error Details The primary chunk (and the mirror chunk, if one exists) are unusable. Roll back the current transaction and terminate the application. Contact the database server administrator. New disk chunks must be…

In this blog post, let’s learn about the error message “336 Cannot create or drop audit on a temporary table table-name.” in Hydra and the description of the error. Error Message 336 Cannot create or drop audit on a temporary table table-name. Error Details Temporary tables cannot be audited. The commands regarding audit trails will not accept the names of temporary tables. If you did…

In this blog post, let’s learn about the error message “186 Message number -186 not found.” in Hydra and the description of the error. Error Message 186 Message number -186 not found. Error Details The first chunk of a storage space is never a candidate to be dropped. Select a different chunk.

In this blog post, let’s learn about the error message “356 Data type of the referencing and referenced columns do not match.” in Hydra and the description of the error. Error Message 356 Data type of the referencing and referenced columns do not match. Error Details The data types of the columns in the child constraint must be identical to those in the parent constraint.

In this blog post, let’s learn about the error message “032 Broken pipe.” in Hydra and the description of the error. Error Message 032 Broken pipe. Error Details An operating-system error code with the meaning shown was unexpectedly returned to the database server. A pipe is a data path between two processes; a pipe is broken if one of the processes has unexpectedly quit while…

In this blog post, let’s learn about the error message “178 ISAM error: Database is locked; pending change to logging mode.” in Hydra and the description of the error. Error Message 178 ISAM error: Database is locked; pending change to logging mode. Error Details A request has been made to change the logging status of a database. Until a level-0 archive is done for all…

In this blog post, let’s learn about the error message “387 No connect permission.” in Hydra and the description of the error. Error Message 387 No connect permission. Error Details You cannot access the database that this statement requests because you have not been granted CONNECT privilege to it. Contact a person who has Database Administrator privilege to that database and ask to be granted…

In this blog post, let’s learn about the error message “187 ISAM error: User Defined Routine execution failed.” in Hydra and the description of the error. Error Message 187 ISAM error: User Defined Routine execution failed. Error Details Logical recovery cannot roll forward a chunk add because the chunk already exists. This error results when the chunk is dropped from a storage space, or the…

In this blog post, let’s learn about the error message “159 ISAM error: Collation sequence invalid.” in Hydra and the description of the error. Error Message 159 ISAM error: Collation sequence invalid. Error Details You have attempted an SQL operation that is not supported on System Monitoring Interface (SMI) pseudo tables. Try another operation.

In this blog post, let’s learn about the error message “354 Incorrect database or cursor name format.” in Hydra and the description of the error. Error Message 354 Incorrect database or cursor name format. Error Details This statement contains the name of a database or a cursor in some invalid format. If the statement is part of a program, the name might have been passed…

In this blog post, let’s learn about the error message “167 ISAM error: Storage-space size is not multiple of PAGESIZE.” in Hydra and the description of the error. Error Message 167 ISAM error: Storage-space size is not multiple of PAGESIZE. Error Details This operation attempts to insert or update the value of a BYTE or TEXT column, but not enough space is available in the…

In this blog post, let’s learn about the error message “173 ISAM error: An error has occurred during logical log back up.” in Hydra and the description of the error. Error Message 173 ISAM error: An error has occurred during logical log back up. Error Details You encountered an unanticipated internal event. Consult the online.log to see if the diagnostics preserved any additional information regarding…

In this blog post, let’s learn about the error message “369 Invalid serial number. Please consult your installation instructions.” in Hydra and the description of the error. Error Message 369 Invalid serial number. Please consult your installation instructions. Error Details Some error has been made in the installation of your Informix product(s). Check the value in the SQLEXEC environment variable (for database server versions prior…