SAP Knowledge Base Article - Preview

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

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

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.