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
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.