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.
- From SM21 and related dev trace file, you can see the query being executed when the error is returned, and the offending tables from that query.
- RSSYBDBVERSION report (SA38) 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)
- RSSYBPARTMON report (SA38) output shows that the offending Infocube involved in the query has more than 1000 partitions and/or several EMPTY partitions in the F fact table
- The InfoObject Characteristic /Master Data tables referenced in the offending query are much larger (more rows) than the Dimension tables referenced in the same query
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, hint, partitions, BEX, BPC, forceplan_alternative_greedy, CR 825794, CR#825794, CR825794 , 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.