Oninit
Talk to an expert →

Informix Error -29080: Target DBMS Error (message_token).

Cause and resolution

Target DBMS Error (message_token).

The target DBMS (Database Management System) to which the Gateway is connected has reported the error that is contained in message_token. Refer to the documentation for the target DBMS to correct the problem.

The format for message_token is as follows:

[DBMS_Error_Code Sqlstate DBMS_Product_id] DBMS_Error_Message

DBMS_Error_Code is the error code of the target DBMS.

Sqlstate is the SQLSTATE that is associated with the error. For a list of SQLSTATE codes, see your ODBC documentation.

DBMS_Error_Code is the error code of the target DBMS.

DBMS_Product_id is the product ID of the target DBMS.

DBMS_Error_Message is the error message that the target DBMS generates. This message is truncated if the entire sqlerrm text is longer than 71 bytes.

DBMS_Product_id in message_token has the following format:

Product_Name:Product_Version

Product_Name is up to the first five characters of the name of the target DBMS product as reported by the ODBC Driver for the product (specifically, the SQL_DBMS_NAME returned by the SQLGetInfo ODBC function).

Product_Version is the first 10 characters of the version of the target DBMS product as reported by the ODBC Driver for the product (specifically, the SQL_DBMS_VER returned by the ODBC SQLGetInfo function).

Product_Version is a character string of the form nn.nn.nnnn, where the first two digits are the major version of the target DBMS, the next two digits are its minor version, and the last four digits are its release version (for example, 03.01.0000). An Oracle7 DBMS_Product_id might be Oracl:07.01.0000.

If the connection attempt to the target DBMS was not completely successful, then DBMS_Product_id will be :00.00.0000.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29080 fires when the target DBMS the Gateway is connected to reports its own error — per the official guidance, message_token is formatted as [DBMS_Error_Code Sqlstate DBMS_Product_id] DBMS_Error_Message, where DBMS_Product_id is Product_Name:Product_Version (from the ODBC driver's SQL_DBMS_NAME/SQL_DBMS_VER). The message is truncated if it exceeds 71 bytes.

  1. An error reported by the target DBMS itself, per the official guidance — the direct, only cause; DBMS_Error_Code/Sqlstate identify the specific condition.
Solutions / Resolution
  1. Refer to the target DBMS's own documentation for DBMS_Error_Code, per the official guidance, to correct the problem.
Examples
N/A

No specific triggering statement is documented beyond a target-DBMS-reported error.

Diagnostic Checks
  1. Extract DBMS_Error_Code, Sqlstate, and DBMS_Product_id from message_token, and consult the target DBMS's documentation.
Related Errors / Related Topics
  • -29081 — "ODBC Error (message_token)." A related passthrough error, from the ODBC layer rather than the target DBMS itself.

The target DBMS reported its own error via message_token — consult the target DBMS's documentation for DBMS_Error_Code.