Teradata Database Message 7697 - 7697 - Analytics Database - Teradata Vantage

Message

Response limit exceeded during execution of stored procedure.

Explanation

This implies that we have exceeded response limit while processing the dynamic fetch.

Generated By

RTS modules.

For Whom

End User.

Notes

While executing a stored procedure, DBS can have 16 open request contexts, if there are either open cursors or nested call statements in the SP definition. At this point if there is a dynamic fetch statement, then it would fail with 3130 internally because dynamic fetch requires a new request context to generate the EVL code.

Remedy

Reduce or close any existing open requests (either nested call statements or open cursors) and then recompile and execute the stored procedure.