Typically if a transaction errors out, you may get an error message recommending to check for transaction problems with a SQL query like:
SELECT * FROM TABLE(relationalai.api.get_transaction_problems('<TRANSACTION_ID_HASH>'));
However, this function requires the all_resource_admin application role. This is because it allows access to see problems and details of other users' transactions on the account.
If that command fails for you, you can run the similar version below that just checks for problems with transactions that your role has run:
SELECT * FROM TABLE(relationalai.api.get_own_transaction_problems('<TRANSACTION_ID_HASH>'));
This function only requires the basic eng_user role, which we recommend granting to any standard developer role.
Similarly if you try to cancel a transaction with this command it may fail if you have insufficient privileges.
CALL relationalai.api.cancel_transaction('TRANSACTION_ID_HASH>');
In that case you can use this command to cancel a transaction that you yourself ran:
CALL relationalai.api.cancel_own_transaction('TRANSACTION_ID_HASH>');
For more information on related topics, please see our documentation: