Symptom
- 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
Read more...
Environment
- 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
Product
Keywords
canceling, attn, threads , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.