Teradata Database Message 7836 - 7836 - Analytics Database - Teradata Vantage

Message

The XSP %DBID.%TVMID submitted a request subsequent to receiving a trigger fail message.

Explanation

If the SQL based XSP is invoked inside of a trigger statement and it submits an SQL statement that causes an error the error is returned to the XSP and the request is marked as aborted inside of a trigger. The only option for the XSP in that case is to set the return SQLSTATE from the XSP to an error condition. If the SQL based XSP fails to do that and submits another request the transaction will be aborted with this error.

Generated By

UDF Subsystem

For Whom

XSP Developer

Notes

None

Remedy

Fix the SQL statement the XSP submits while in a trigger. In addition add code to return an error SQLSTATE and return from the the XSP or return without issuing another request and the original error message will be returned to the caller.