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 for Me (Login required).

Search for additional results

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