15.00 - 7836 The XSP %DBID.%TVMID submitted a request subsequent to receiving a trigger fail message. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

7836 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

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.