Teradata Database Message 7835 - 7835 - Analytics Database - Teradata Vantage

Analytics Database Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
15.xx,16.xx,17.xx
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-01-05
dita:mapPath
sfx1628096178347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1096
lifecycle
latest
Product Category
Teradata Vantageā„¢
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.