2143542 - ODBC: Internal error thrown when command timeout occurs and resource accessed is locked - SDK for SAP ASE

• Under certain timing conditions, such as when the ASE is local to application, multi-threaded app will throw these errors on some of the threads when the command timeout/cancel is issued to ASE:

The command has timed out.
Operation Canceled
Internal Error

• Occurs when several similar stored procedures performing multiple functions, are blocked during an update command. 
• If the procedure has sent responses back to client, it can be interupted by the cancel during read timeout. 
• Sometimes this occurs with the Internal Error message:

Thread[1]: ProcStmt: exec sp_gemed 2, 'two'
Thread[7]: Error occured in SQLExecSeq: SQLExecDirect:
Thread[7]: Error: SQLState: HYT00, Native Error: 30149, Message: [SAP][ASE ODBC Driver]The command has timed out., Message Length: 48
Thread[7]: Error: SQLState: HY008, Native Error: 30086, Message: [SAP][ASE ODBC Driver]Operation Canceled., Message Length: 41
Thread[7]: Error: SQLState: 1ZZ00, Native Error: 30002, Message: [SAP][ASE ODBC Driver]Internal Error, Message Length: 36

• SAP Sybase Software Developer Kit (SDK) 15.7
• SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
• Adaptive Server Enterprise ODBC Driver by Sybase

canceling, attn, threads , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error