Teradata Database Message 7836 - 17.10 - 7836 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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.