Informix Error Messages and Error Codes From Error 9054 to 9060

SQLServerF1

Informix Error Code -9054 The ACE report was compiled by version A compiler. This runner can only run 5 through B. Recompile your ACE report specification using SACEPREP and then rerun SACEGO.
The versions of ACEPREP and ACEGO must agree. (To check the version of either program, run it from the command line with the -v option.) To recompile the report, use a version of the compiler, ACEPREP, that is identical to the version of the runner, ACEGO. If the versions are already the same, recompile the report anyway to ensure that the .ace file has not been corrupted. If the error recurs, please note all circumstances and contact Informix Technical Support.

Informix Error Code -9055 The compiled report file filename could not be found or opened.
The report filename was named on the ACEGO command line. It expects to locate the file filename.arc in the current directory or a path that the DBPATH environment variable names, but it could not find the file or could not open it for reading. Check that the filename was spelled correctly and that your account has read access to it.

Informix Error Code -9059 A select statement which is not the final select statement in an ACE report must select into a temporary table.
The SELECT section of the report can contain more than one SELECT statement. However, only the last one of these statements can produce the rows that are the report contents. The preceding SELECT statements are used to prepare data in temporary tables that the final statement delivers to the report. Change the report specification so that all but the last SELECT statement contain INTO TEMP clauses.
Informix Error Code -9060 The values m and n used to subscript name are outside the bounds for the column’s defined length.
A column substring in the ORDER BY clause is incorrect. When taking a substring of a column, the first number in brackets specifies the position of the first character, and the second number specifies the position of the last character of the substring. Both numbers must be at least 1 and not greater than the total length of the column or variable.

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.

Thanks,
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 *