Informix Error Messages and Error Codes From Error 748 to 754


Informix Error Code -748 Exceeded limit on maximum number of cascaded triggers.
You exceeded the maximum number of cascading triggers, which is 61. You may be setting off triggers without realizing it. You can query the systriggers system catalog table to find out what triggers exist in the database. To trace the triggered actions, place the action clause of the initial trigger in a stored procedure, and use the SPL TRACE statement.
Informix Error Code -749 Remote cursor operation disallowed with pre-5.01 server.
An external database server before Version 5.01 sent the triggering statement or cursor operation. This action is not allowed.

Informix Error Code -750 Invalid distribution format found for table_name.
This internal error should not occur unless the database has been corrupted in some way. To rebuild the distribution, use UPDATE STATISTICS. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -751 Remote procedure execution disallowed with pre-5.01 server.
The action clause of the trigger contains a stored procedure that is not called in a data manipulation statement, and an external database server before Version 5.01 will execute the procedure. This action is not allowed. A stored procedure that is called within a data manipulation statement cannot execute certain SQL statements, including transaction-related statements. Transaction-related statements are not allowed within a stored procedure that is a triggered action. A database server before Version 5.01 cannot check for this condition, so the procedure is not allowed. If possible, execute the procedure on a Version 5.01 or later database server.

Informix Error Code -752 All Smart Disk devices are busy.
Wait a while and retry your Smart Disk operation.
Informix Error Code -753 Access denied – Single user limit has been exceeded.
Licensing enforcement is configured for only one user; multiple users cannot use the product at the same time. If you are using the product from a remote computer, the product is licensed only for a nonnetworked environment.If you are using the product from a local computer, wait until the current user exits and try again.
Informix Error Code -754 Cannot access the license file.
The system cannot find the user license file. The user license file might not have been installed, or it might have been installed improperly. Also, you might not have the correct file or directory permissions to access the user license file. Consult your installation documentation.

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 *