Informix Error Messages and Error Codes From Error 29050 to 29051


Informix Error Code -29050 Error accessing schema information (Orig-Msg[Sub=Sub-code,Ifx=Orig-code,Obj=Object-name])
The Gateway encountered an error while accessing catalog information for the object Object-name. The Gateway sends this catalog information to the coordinating database server while processing a distributed query.

Several errors that might occur during catalog access can cause this message. Orig-code is the error code for the underlying error, and Orig-Msg is the message token that is associated with that error code. Sub-code is an Informix internal code in hexadecimal that indicates which catalog access query failed and in which stage of query processing it failed. This diagnostic information field is meant for Informix Technical Support.
Although the error message token might be truncated through programmatic access, the entire message is logged in the Gateway log file gw.log in the directory $INFORMIXDIR/gw/log.

Informix Error Code -29051 Only single-site updates allowed in a transaction.
This Gateway does not support two-phase commit. If any remote server that the Gateway accesses is an update site in a transaction, that site must be the only update site in the transaction. All other sites, including Informix sites, must be read only. Change the application to update only one remote site per transaction. (However, if the sites in a transaction are all read only, any number of sites can be updated in the same transaction).
This error message applies only when the database server that coordinates the transaction is either earlier than Version 7.2 or is Version 7.2 or later and the HETERO_COMMIT configuration parameter is not set.

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 *