get_transaction()#
relationalai.api
#get_transaction_problems(id STRING)
A function that retrieves errors and warnings for the transaction with the specified id.
Requires the all_resource_admin application role.
Parameters#
| Name | Type | Description |
|---|---|---|
id | STRING | The ID of the transaction to retrieve. |
Returns#
A table with the following columns:
| Column Name | Data Type | Description |
|---|---|---|
| TYPE | STRING | The type of the problem. |
| ERROR_CODE | STRING | The error code. |
| MESSAGE | STRING | A short description of the problem. |
| REPORT | STRING | Full server-side report of the problem. |
| PATH | STRING | Information printed as part of the header in API requests. |
| IS_ERROR | BOOLEAN | Whether the problem causes execution errors. |
| IS_EXCEPTION | BOOLEAN | Whether the problem was caused by an exception. |
| JSON | OBJECT | A JSON object with the same information as the rest of the columns. |
Example#
Use the api.get_transaction_problems() procedure to retrieve details for problems in a transaction:
#-- Retrieve the details for the transaction with ID '02c8fa31-1234-5678-90ab-abcdef123456'.
SELECT * FROM TABLE(relationalai.api.get_transaction_problems('02c8fa31-1234-5678-90ab-abcdef123456'));
/*+----------------+--------------+----------------------------------------------------+------------------------------------------------+------+-------------+--------------+-----------------------------------------+
| TYPE | ERROR_CODE | MESSAGE | REPORT | PATH | IS_ERROR | IS_EXCEPTION | JSON |
|---------------+---------------+----------------------------------------------------+------------------------------------------------+------+-------------+--------------+-----------------------------------------|
| ClientProblem | PARSE_PROBLEM | Invalid token `.`. Expecting `(`, `=`, `[` or `{`. | 60| def p.foo = \'bar\' | | TRUE | FALSE | { |
| | | | ^~~~~~~~~~~~~~~ | | | | "error_code": "PARSE_PROBLEM", |
| | | | | | | | "is_error": true, |
| | | | | | | | "is_exception": false, |
| | | | | | | | "message": "Invalid token `.`. ...", |
| | | | | | | | "path": "", |
| | | | | | | | "report": "60| ...\n ^~~~~~~~~~~\n", |
| | | | | | | | "type": "ClientProblem" |
| | | | | | | | } |
+---------------+---------------+----------------------------------------------------+------------------------------------------------+------+-------------+--------------+------------------------------------------+ */
Transaction IDs can be found in the ID column of the api.transactions view.
IDs are also reported by the RAI debugger.
See Compute Resources for more information on managing transactions.