SAP Knowledge Base Article - Preview

2282196 - Error 702 "Memory request exceeds the size of single page..." on UPDATE with a large IN list - SAP ASE

Symptom

  • An UPDATE statement with a large IN list failed with Error: 702, Severity: 20, State: 1.

Error: 702, Severity: 20, State: 1 Memory request for 31524 bytes exceeds the size of single page of 16384 bytes.

  • This is the UPDATE statement reported in the ASE errorlog:

SQL Text: update xxx..C_C_CL
set C_B_ID = @@@V0_VCHAR1
where C_B_ID = @@@V1_VCHAR1 AND C_R_T = @@@V2_VCHAR1 AND C_ID
NOT IN (@@@V3_VCHAR1, @@@V4_VCHAR1, @@@V5_VCHAR1, ........  @@@V1852_VCHAR1 )

  • The stacktrace following the error includes modules: 

memalloc.fdpr
LeSQLRep::_sqlRepParamSet(ExeCtxt&,e_param*,SQLBuf*)
LeSQLRep::SqlRepFixMatrix(ExeCtxt&,int)
LeUpdateOp::_LeOpNext.fdpr.chunk.12(ExeCtxt&)
LeEmitNoSndOp::_LeOpNext(ExeCtxt&)
LePlanNext


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 pre-SP137

Product

SAP Adaptive Server Enterprise 15.7

Keywords

"sql statement", replication, CR777190, CR#777190, 777190, "IN list" , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.