SAP Knowledge Base Article - Preview

2736509 - Abstract Plan not working for ASE 16 CIS query


When running a CIS (i.e. remote server) query with an abstract plan which worked in ASE 15.7, ASE 16.0 gives the following error:

Abstract Plan (AP) Warning : An error occured while applying the AP:
<your plan here>

The children of the <your join operator> operator don't have the required properties, as ordering, partitioning. The logical relational operation is valid at this point but it can not be implemented by this physical operator.
The AP property enforcer operators 'sort', 'xchg' or 'enforce' can be used to create the needed physical properties.

There may also be a suggested template abstract plan in the error message which also gives the same error.



  • SAP Adaptive Server Enterprise (ASE)
  • SAP Adaptive Server Enterprise Cluster Edition (ASE CE)
  • Component Integration Services (CIS)


SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition


Sybase, ASEServer, SAPASE, dataserver, CR817834, CR#817834 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.