How To Fix RSR_PE055 - InfoProvider &1 contains data slice &2 and has no SQLScript procedure

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_PE - TREX Planning Engine

• Message number: 055

• Message text: InfoProvider &1 contains data slice &2 and has no SQLScript procedure

What causes this issue?

InfoProvider &1 contains data slice &2 of type "exit"<(>,<)> and there
is no SQLScript-based implementation. This prevents the whole scenario
from running as SAP HANA-optimized in PAK.

System Response

As described in SAP Note 1637199, this data slice makes the whole
scenario run using classic IP-based planning, rather than as SAP
HANA-optimized with PAK. The performance of planning actions like
executing sequences is the same as in classic BW-IP.

How to fix this error?

You have to remove or deactivate data slice &2 using transaction RSPLAN,
in order to run the scenario as SAP HANA-optimized. Alternatively, you
can implement a PAK-enabled exit either by using the ABAP results as
described in SAP Note 1956085 or by adding an SQLScript-based solution
as described in the SAP standard documentation and/or SAP Note 1928715.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_PE055 - InfoProvider &1 contains data slice &2 and has no SQLScript procedure ?

  The SAP error message RSR_PE055 indicates that the specified InfoProvider contains a data slice, but it does not have an associated SQLScript procedure. This typically occurs in the context of SAP BW (Business Warehouse) or SAP HANA when trying to execute a query or data extraction that requires a SQLScript procedure for processing.
  Cause:
  
  Missing SQLScript Procedure: The InfoProvider is expected to have a SQLScript procedure defined for it, but it is either not created or not activated.
  Data Slice: The data slice mentioned in the error message indicates that there is a specific subset of data that the system is trying to access, but without the necessary SQLScript procedure, it cannot process the request.
  Configuration Issues: There may be configuration issues in the InfoProvider or the associated data model that prevent the SQLScript procedure from being generated or recognized.
  
  Solution:
  
  
  Check SQLScript Procedure:
  
  Go to the SAP HANA Studio or the relevant development environment.
  Check if the SQLScript procedure for the InfoProvider exists. If it does not, you may need to create it.
  If it exists, ensure that it is activated and properly configured.
  
  
  
  Generate SQLScript Procedure:
  
  If the procedure is missing, you can generate it by navigating to the InfoProvider in the SAP BW modeling tools and using the option to generate the SQLScript procedure.
  Ensure that all necessary settings and parameters are correctly defined during the generation process.
  
  
  
  Data Model Configuration:
  
  Review the configuration of the InfoProvider and ensure that it is set up correctly to work with SQLScript.
  Check for any inconsistencies or errors in the data model that might prevent the procedure from being recognized.
  
  
  
  Transport Requests:
  
  If you are working in a development environment, ensure that any changes made to the InfoProvider or SQLScript procedure are included in the appropriate transport requests and have been transported to the target system.
  
  
  
  Consult Documentation:
  
  Refer to SAP documentation or notes related to the specific version of SAP BW or HANA you are using for any additional troubleshooting steps or known issues.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  SAP Community: Engage with the SAP Community forums for insights from other users who may have encountered similar issues.
  Performance Considerations: If you are frequently encountering this error, it may be worth reviewing the overall performance and design of your InfoProviders and queries to ensure they are optimized for your data model.
  
  By following these steps, you should be able to resolve the RSR_PE055 error and ensure that your InfoProvider is functioning correctly with the necessary SQLScript procedures.