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.