SAP Knowledge Base Article - Preview

3300805 - ASE Error 1025 happens after EHP upgrade -SAP ASE for Business Suite.

Symptom

  • When running the query with a AP which contains table alias after SAP application upgrade , the following error happened

    Abstract Plan (AP) Warning : An error occurred while applying the AP:

    ( i_scan [RESB~Z02] ( table ( T0001 RESB ) ) )
    to the SQL query:

    (omit)
    Failed to apply the top operator 'i_scan ' of the following AP fragment:
    ( i_scan [RESB~Z02] ( table ( T0001 RESB ) ) )
    The following template can be used as a basis for a valid AP:
    ( also_enforce ( group ( also_enforce ( scan ( table ( T1 RESB ) ) ) ) ) )
    The optimizer will try to complete the compilation of this query; on success, the query will be executed normally.
  • The query runs on View and the AP was working without an error before upgrade. 


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Abstract Plan, Hint,  , KBA , BC-DB-SYB , Business Suite 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.