Symptom
- ASE has statement cache and literal autoparam enable.
- When running sp_showplan the following error reported in ASE errorlog:
Error: 718, Severity: 20, State: 1
Memory allocation from process private memory is being performed by an incorrect process. Current Spid: '16943'. Owning Spid: '10857'. Memory: '0x0x2ab690dbf800'. This is an Adaptive Server internal error. Please contact SAP Tech Support. - The stack includes:
memalloc
CgpGenerateSQL::_findVariableValue(OmniVariableInfo*, constant**, e_param**)
CgpGenerateSQL::stripMarkersForTrace(SQLBuf&, SQLBuf const&, OmniSubstValue*)
LeRemScanOp::_LeOpShowOp(ExeCtxt&, int)
LeOperator::LeOpShowOp(ExeCtxt&, int)
LeEmitSndOp::_LeOpShowOp(ExeCtxt&, int)
LeOperator::LeOpShowOp(ExeCtxt&, int)
le_showPlanOp
showMainE_STEPs+0x158()
showE_STMT
showplan
show_plan
LeRun
LeEvals::LeEvRun(LeRunMode, LeRunStack*, short, LeDataRow*, unsigned char*, int*)
LeScalarOp::_LeOpNext(ExeCtxt&)
LeEmitNoSndOp::_LeOpNext(ExeCtxt&)
LePlanNext
le_execerr
exec_lava
s_execute
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
sp_showplan, CR825572 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.
SAP Knowledge Base Article - Preview