SAP Knowledge Base Article - Preview

2880421 - Error SQL325 returned when executing query involving multiprovider - SAP ASE on BW

Symptom

  • Error SQL325 is returned when executing a Query (from RSRT or BEX query):

SQL Error: 325 
[ASE Error SQL325][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Adaptive Server finds no legal query plan for this statement. If an Abstract Plan 
Error Errors occurred during parallel processing of query 1, RC: 3 
Error Error while reading data; navigation is possible

  • Required Correction Collection SAP Note is implemented on the system on last version (see on the "See Also" section the SAP Notes related to your SAP BW version).
  • The ASE version is equal or higher to releases:
    • 16.0 SP02 PL07 HF1
    • 16.0 SP02 PL08
    • 16.0 SP03 PL04
      (if not, then refer to KBA 2422617 - BEX query ending with SQL error 30046 and SQL error 325 )


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

BW, SQL325, sap_olap, legal query, abstract plan, alternative_greedy_search, optimizer, criteria , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , How To

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.