SAP Knowledge Base Article - Preview

2231172 - select into after deadlock caught errors 1205 and 267 - SAP ASE

Symptom

  • A procedure including a 'select into' command
  • After being victim of deadlock and hitting error 1205
- exec test_deadlock
Msg 1205, Level 13, State 1:

Server 'ASE' Procedure 'test_deadlock', Line 3:

Your server command (family id #0, process id #13) encountered a deadlock situation. Please re-run your command.
  • Hits error 267 on the target table for the select into
- exec test_deadlock  -- rerun of the command
Msg 267, Level 16, State 1:

Server 'ASE', Procedure 'test_deadlock', Line 3:

Object '#table' cannot be found.

(return status = -6)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

"error 1205" , "error 267", Sybase , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.