Teradata Database Message 7835 - 17.10 - 7835 - 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 ended before completing an outstanding SQL request. The returned SQLSTATE is: %VSTR.
Explanation
If the a XSP submits an SQL request to the database it should not exit (return) until the SQL request completes. Doing so will generate this error and cause the transaction to be rolled back. It maters not whether the XSP is returning an error, warning or no error SQLSTATE. This condition will override any XSP generated error.
Generated By
UDF Subsystem
For Whom
XSP Developer
Notes
None
Remedy
To avoid this situation don't just return from the XSP without making sure that an SQL request submitted by the XSP has completed.