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)
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 pageThis 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.