SAP Knowledge Base Article - Preview

3051457 - ASE Error SQL1009 - SAP ASE for Business Warehouse

Symptom


SAP BW jobs and/or queries fail with the following error after applying Correction Collection Notes:

ERROR: -1 in function StartSelect (execute) [line 30566] (1009) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Abstract Plan (AP) : The SQL query does not contain a base table to match the base table '/BIC/ECUBE' described in the AP. The base table will be ignored. Check the AP syntax and its correspondence to the query.

ERROR: -1 in function StartSelect (execute) [line 30566] (1009) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Abstract Plan (AP) : The SQL query does not contain a base table to match the base table '/BIC/FCUBE' described in the AP. The base table will be ignored. Check the AP syntax and its correspondence to the query.





Read more...

Environment

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

Product

SAP NetWeaver 7.4

Keywords

SQL 1009, 1009, BW, AP hint, "abstract plan" , 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 for Me (Login required).

Search for additional results

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