Teradata Database Message 7835 - 7835 - Analytics Database - 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.