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 underlying Infocube has 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 , 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.