Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Statement not allowed during snapshot Next Page

Statement size or complexity exceeds server limits


Item

Value

Constant

SQLE_SYNTACTIC_LIMIT

ODBC 2 State

37000

ODBC 3 State

54000

Severity

19

SQLCODE

-890

SQLSTATE

54W01

Sybase error code

404

Probable cause

The statement contains one or more constructs whose size make it impossible to process. Increasing the maximum cache size, page size, or stack size may resolve this error. Consider rewriting the query so that the internal limit is not exceeded. For example, if the query contains a large IN-list, consider inserting the IN-list's values into a temporary table. Then rewrite the query to join this temporary table to the other table(s) in the original statement.