![Server failure when running sa_text_index_vocab procedure [CR #627966]](arrow-left.gif){kind=icon}
![dbisql reports Java stack trace error [CR #624363]](arrow-right.gif){kind=icon}
NO PASSTHRU and PARTIAL PASSTHRU modes are useful in remote queries that use Component Integration Services (CIS) functional compensation, or in remote queries that join Sybase IQ tables to SQL Anywhere tables. When you execute a remote query in NO PASSTHRU or PARTIAL PASSTHRU mode and the query execution plan contains a group-by hash, distinct hash, join hash, or sort operator, a statement may fail and issue this error:
-728,Update operation attempted on non-updatable remote query error
The affected statement fails, but no other statements or connections are impacted.
This error occurs only when the result computed by the operator is much larger than the available memory. Other operations in the query plan may reduce the amount of available memory. If available memory is small—for example, if fewer than 20 rows can be held in the available memory at one time—then Sybase IQ may report the above error. If the result set is very large—for example, if it contains more than 520x10^9 rows—then Sybase IQ may report the above error.
To avoid this problem, increase the amount of memory allocated to SQL Anywhere by increasing the SQL Anywhere cache, or wait for the load on the server to decrease, or rewrite the query so that it can be executed in FULL PASSTHRU mode.
