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.