How To Fix RSR_PE017 - NULL values contained in planning artifacts from external sources &1

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_PE - TREX Planning Engine

• Message number: 017

• Message text: NULL values contained in planning artifacts from external sources &1

What causes this issue?

Customer exits in HANA<(>,<)> like SQLScript procedures or
VirtualProvider/master data based on HANA views<(>,<)> can generate NULL
values<(>,<)> which cannot be handled in HANA optimized planning (PAK).
This occurs in method &1.

System Response

NULL values cannot be handled<(>,<)> and the result is unclear. The
system stops the current planning process .

How to fix this error?

Contact your administrator.

Procedure for System Administrators

Check your customer exits on NULL values.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_PE017 - NULL values contained in planning artifacts from external sources &1 ?

  The SAP error message RSR_PE017 indicates that there are NULL values present in planning artifacts that are sourced from external systems. This can occur in various scenarios, particularly when integrating data from external sources into SAP BW (Business Warehouse) or SAP Analytics Cloud (SAC) for planning purposes.
  Cause:
  
  Data Source Issues: The external data source may contain NULL values that are not handled properly during the data extraction or loading process.
  Mapping Problems: There may be issues with how fields are mapped between the external source and the SAP system, leading to NULL values being introduced.
  Transformation Logic: If there are transformations applied to the data during the ETL (Extract, Transform, Load) process, they may not account for NULL values correctly.
  Incompatible Data Types: The data types in the external source may not match the expected data types in SAP, leading to NULL values being generated.
  
  Solution:
  
  Data Validation: Check the external data source for NULL values and clean the data before it is loaded into SAP. This may involve filtering out NULLs or replacing them with default values.
  Mapping Review: Review the mapping of fields between the external source and SAP to ensure that all necessary fields are correctly mapped and that NULL values are handled appropriately.
  Transformation Adjustments: Modify the transformation logic in the ETL process to handle NULL values. This could involve using functions to replace NULLs with default values or ensuring that NULLs are not passed into the planning artifacts.
  Error Handling: Implement error handling in the data loading process to catch and log instances of NULL values, allowing for easier troubleshooting in the future.
  Testing: After making changes, conduct thorough testing to ensure that the issue is resolved and that no new issues have been introduced.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional guidance or patches related to this error message.
  Documentation: Review SAP documentation on data integration and planning processes to understand best practices for handling NULL values.
  Community Forums: Engage with SAP community forums or support channels to see if others have encountered similar issues and what solutions they have implemented.
  Monitoring: Set up monitoring for data loads to catch NULL values early in the process, allowing for quicker resolution.
  
  By addressing the root causes and implementing the suggested solutions, you should be able to resolve the RSR_PE017 error and ensure that your planning artifacts are free of NULL values.