SAP Knowledge Base Article - Preview

2415057 - Msg 442 - Maximum number of user tables under all sides of a UNION statement can not exceed 512 - ASE

Symptom

  • Query reference tables which are heavily partitioned
  • The following error may be reported:

Msg 442, Level 16, State 34, Server <server>, Line 1 - Sybase Database Error: Maximum number of user tables under all sides of a UNION statement can not exceed 512. Please simplify the query and retry

  • Error 702 may be encountered with stacktrace in memalloc, memalloc_zero, CgLavaUtils::allocRange

terminate_process
s_handle
exc__raise
exc_raise
memalloc
memalloc_zero
CgLavaUtils::allocRange
GenLava
s_compile_stmt
s_compile
sequencer
execproc
s_execute
sequencer

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Error 702, Msg 442, memalloc, memalloc_zero , KBA , ase , sybase , 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.