SAP Knowledge Base Article - Preview

3399905 - A query with many union clauses on a table with many columns reports error 422 - SAP ASE

Symptom

  • A query containing many union clauses
  • On a table with high number of columns
  • Returns error 422 to client and ASE errorlog

    Error: 422, Severity: 19, State: 3
    Too many nested expressions or logical operators to compile. Try splitting query or limiting ANDs and ORs.

  • The query can be run successfully under 'compatibility mode'


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
    • Applies to all ASE versions from 15.0
    • 'compatibility mode' configuration setting

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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.