Symptom
- Received Error 706:
Error: 706, Severity: 20, State: 3
Process 2424 tried to remove PROC_HDR 0x1017601b800 that it does not hold in Pss.
- This error was detected when a process attempted to create a lightweight procedure (LWP):
SQL causing error : create procedure *ss0084073133_1342856568ss*(@@@V0_VCHAR1 VARCHAR(64)) as select c1 from db.dbo.t1 where c1 = @@@V0_
- It was followed by a stacktrace that included modules:
rm_prochdr
memfree
init_before_msg
- Further errors such as 941 and 6103 may be reported in the ASE errorlog, for example:
Error: 941, Severity: 20, State: 1
Illegal database context operation.
Error: 6103, Severity: 17, State: 1
Unable to do cleanup for the killed process; received Msg 706.
NOTE: The complete stacktrace is available in the attachment.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7
Product
SAP Adaptive Server Enterprise 15.7
Keywords
s_getTreeOrPlan, s_reinstall_lwp_tree, ssql_reparse, CR741786, CR#741786, 741786, statement, procedure, cache, dynamic, regenerate, parse, release_compiler_scratch_space, stack, CR733932 , CR#733932 , 733932 , KBA , cr733932 , cr741786 , 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.