15.00 - 7835 The XSP %DBID.%TVMID ended before completing an outstanding SQL request. The returned SQLSTATE is: %VSTR. - 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)

7835 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

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.