SAP Knowledge Base Article - Preview

2209638 - BW errors: SQL422, SQL702, SQL325 - SAP BW on ASE

Symptom

  • BW Dataloads and Compression of Infocubes fail on SAP ASE with errors:

Error 422: "Too many nested expressions or logical operators to compile returned" (limiting AND & OR)

Error 702: "Memory request for 17164 bytes exceeds the size of single page of 16384 bytes."

  • BEx query fails with error:

    [ASE Error SQL325][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adaptive Server finds no legal query plan for this statement.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Warehouse
  • SAP Business Warehouse - All versions 
  • SAP Solution Manager 7.1, 7.2

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Business Warehouse all versions

Keywords

compression, SQL422, SQL702, F table, F fact table, Infocube, partitions, SQL325, BEx, BW , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

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.