Informix Error Messages and Error Codes From Error 711 to 718


Informix Error Code -711 Cannot insert encoded BLOB descriptor.
An attempt to insert an encoded blob descriptor by means of the DESCR() function has failed. See the ISAM error for more information.
-712 Cannot insert encoded BLOB descriptor in non-optical BLOB columns.
You have attempted to use the DESCR() function to insert an encoded blob descriptor into a TEXT or BYTE column that is stored in a dbspace or blobspace. You can use this function only to insert descriptors into blob columns that are stored on optical media.

Informix Error Code -713 Cannot decode encoded BLOB descriptor.
The decoding of a blob descriptor prior to its insertion into a data row has failed. See the error from the optical subsystem (an error in the -7000 to -7199 range) for more information.
Informix Error Code -714 Cannot encode BLOB descriptor.
The encoding of a blob descriptor for storage on optical media has failed. See the error from the optical subsystem (in the -7000 to -7199 range) for more information.
Informix Error Code -715 Transaction state error.
An error occurred in retrieving a transaction state. See the ISAM error for more information.

Informix Error Code -716 Possible inconsistent transaction. Unknown servers are server-name-list.
This message appears after an administrator kills a coordinator database server process, thread, or session using tbmode -z or onmode -z any time after the coordinator issues its decision either to commit or roll back a two-phase commit transaction. You must examine the message log or the logical log at each of the database servers for which the status is listed as unknown to determine whether the local transaction was committed or rolled back. If some participating database servers rolled back the transaction, and others committed it, you must determine whether your networked database system is in an inconsistent state. This procedure is described in detail in your Administrator’s Guide.
Informix Error Code -717 Invalid argument passed to system function function-name.
An invalid data type has been passed to one of the arithmetic functions (HEX(), TRUNC(), ROUND()).
Informix Error Code -718 Statement is invalid while a global transaction is suspended.
If a database server that is acting as a Resource Manager in an X/Open distributed transaction-processing environment has suspended a transaction, its next statement must be xa_start. All other statements are disallowed.

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 *