15.00 - 3128 Transaction aborted due to exceeding the maximum consume statement limit. - 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)

3128 Transaction aborted due to exceeding the maximum consume statement limit.

Explanation:

This error occurs when there are too many SELECT AND CONSUME statements running concurrently. The system maximum for SELECT AND CONSUME statements is 20% of the session limit for the system. A limit is imposed because the SELECT AND CONSUME statement may enter a wait state holding up a session.

Generated By:

Dispatcher.

For Whom:

End Users.

Remedy:

Resubmit the aborted transaction after other SELECT AND CONSUME statements are released.