SAP Knowledge Base Article - Preview

3018274 - BW queries fail with Error SQL325 - SAP BW on ASE

Symptom

  • On SAP BW systems running SAP ASE 160 SP03, BW queries (either va RSRT, BEX, BPC reports) fail with SQL Error 325 :

    [ASE Error SQL325][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adaptive Server finds no legal query plan for this statement.
  • t-code SE38 -> Report: RSSYBDBVERSION indicates all GREEN lights (ie. BW Correction Collection note is applied and the ASE configuration is as set required per Best Practice Guide - SAP Note 1680803)

  • t-code SE38 -> Report: RSSYBPARTMON output shows that the offending Infocube has more than 1000 partitions and/or several EMPTY partitions in the F fact table


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL07 and above for Business Warehouse
  • SAP Business Warehouse - All versions 
  • SAP NetWeaver - all versions

Product

SAP NetWeaver 7.4

Keywords

325, SQL325, fact table, partitions, BEX, BPC, forceplan_alternative_greedy , 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 for Me (Login required).

Search for additional results

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