How To Fix RSRV086 - Check foreign key relationship between &1 &2 and &3 &4

SAP Error Message - Details

• Message type: E = Error

• Message class: RSRV -

• Message number: 086

• Message text: Check foreign key relationship between &1 &2 and &3 &4

What causes this issue?

This test checks the foreign key relationship between &V1& &V2& and
&V3& &V4&.

System Response

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

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSRV086 - Check foreign key relationship between &1 &2 and &3 &4 ?

  The SAP error message RSRV086 indicates an issue with a foreign key relationship in the context of data modeling or data extraction in SAP BW (Business Warehouse). This error typically arises when there is a mismatch or inconsistency between the data in the tables involved in the foreign key relationship.
  Cause:
  The error message RSRV086 is triggered when the system detects that the foreign key relationship between two tables (or between a table and a characteristic) is not valid. This can happen due to several reasons, including:
  
  Data Inconsistency: There may be records in the child table that do not have corresponding entries in the parent table.
  Missing Entries: The foreign key field in the child table may contain values that do not exist in the primary key field of the parent table.
  Incorrect Data Types: The data types of the foreign key and primary key fields may not match.
  Changes in Data Model: If there have been recent changes to the data model (e.g., changes in InfoObjects, InfoProviders, or transformations), it may lead to inconsistencies.
  
  Solution:
  To resolve the RSRV086 error, you can follow these steps:
  
  
  Check Data Consistency:
  
  Use transaction code RSRV to access the Data Consistency Check tool.
  Execute the check for the specific InfoObject or InfoProvider mentioned in the error message.
  Identify any inconsistencies reported by the system.
  
  
  
  Analyze Foreign Key Relationships:
  
  Review the foreign key relationships defined in the data model.
  Ensure that the foreign key fields in the child table correctly reference the primary key fields in the parent table.
  
  
  
  Correct Data Issues:
  
  If you find records in the child table that do not have corresponding entries in the parent table, you may need to either delete those records or add the missing entries in the parent table.
  If there are incorrect data types, you may need to adjust the data types in the data model.
  
  
  
  Re-activate Data Model:
  
  If changes were made to the data model, consider re-activating the affected InfoObjects or InfoProviders to ensure that the changes are properly reflected.
  
  
  
  Run Data Load:
  
  After making the necessary corrections, run the data load again to see if the issue is resolved.
  
  
  
  Related Information:
  
  Transaction Codes: 
  
  RSRV: Data Consistency Check
  RSA1: Data Warehousing Workbench
  
  
  Documentation: Refer to SAP Help documentation for detailed information on data modeling and foreign key relationships in BW.
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to RSRV086 or foreign key relationships.
  
  By following these steps, you should be able to identify and resolve the underlying issues causing the RSRV086 error in your SAP BW environment.