Teradata Database Message 3128 - 3128 - Analytics Database - Teradata Vantage

Message

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.

Notes

None

Remedy

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