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

Right truncation of string data Next Page

Rollback occurred due to deadlock during prefetch


Item

Value

Constant

SQLE_ROLLBACK_ON_PREFETCH

ODBC 2 State

40001

ODBC 3 State

40001

Severity

13

SQLCODE

-684

SQLSTATE

WW019

Sybase error code

1205

Probable cause

One of the cursors that was opened with prefetch enabled was performing fetch operations, and a deadlock occurred during a prefetch. This is a deadlock situation and your transaction has been chosen as the one to rollback. The request that received this error was not executed, unless the request was to close the cursor, in which case the cursor was closed.