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.