Informix Error Messages and Error Codes From Error 151 to 158


Informix Error Code 151 ISAM error: Illegal value in varchar length field.
This internal error occurs when the leading byte in a VARCHAR column on disk indicates a VARCHAR length greater than the column was defined to hold when the column was created. If the error recurs, please refer to the Appendix entitled “Trapping Errors” in your Administrator’s Guide to acquire additional diagnostics. Contact Informix Technical Support with the diagnostic information.
Informix Error Code -152 ISAM error: Illegal message type received from remote process.
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. If the error recurs, please note all circumstances and contact Informix Technical Support.

Informix Error Code -153 ISAM error: not in ISMANULOCK mode.
The ISAM processor has been asked to lock or unlock the current file (table), but the file was not opened in the appropriate mode. For C-ISAM programs, review the uses of isopen, and make sure that the ISMANULOCK flag is passed when the program opens a table for manual locking. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -154 ISAM error: Lock Timeout Expired.

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 user request is awaiting a resource that was locked by a user in a different system, which is awaiting a resource that this user owns. Roll back the current transaction, and retry it after a delay. If this error occurs frequently, ask the database server administrator to adjust the length of the deadlock time-out interval.

This code is also returned when an explicit wait time limit expires; that is, if you have SET LOCK MODE TO WAIT 3, and your request is queued for more than 3 seconds for a lock, the operation ends with this ISAM error code.
Informix Error Code -155 ISAM error: Primary and Mirror chunks are bad.
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 defined, and then the system must be restored.
Informix Error Code -157 ISAM error: Interrupted ISAM call.
An interrupt that was detected from client process has terminated the operation. Restart the operation.
Informix Error Code -158 ISAM error: Operation disallowed on SMI pseudo table.
You have attempted an SQL operation that is not supported on System Monitoring Interface (SMI) pseudo tables. Try another operation.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *