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

RSR_PE017 - Overview

• 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