How To Fix SCPR797 - Table SCPRSKEYS of BC Set &1 is inconsistent

SAP Error Message - Details

• Message type: E = Error

• Message class: SCPR - BC Sets

• Message number: 797

• Message text: Table SCPRSKEYS of BC Set &1 is inconsistent

What causes this issue?

Table SCPRSKEYS contains all keys stored in the BC Set in raw format.
For BC Set &V1& it is either empty or its keys do not match the keys
stored in the BC Set.

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?

<ZH>The error occurs within SAP:</>
In the original system open the BC Set maintenance transaction SCPR3 and
save the BC Set &V1& or run the update report for the BC Set to
re-calculate table SCPRSKEYS.
<ZH>The error occurs at the customer:</>
Create an error message for component BC-CUS-TOL-BCD

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 SCPR797 - Table SCPRSKEYS of BC Set &1 is inconsistent ?

  The SAP error message SCPR797 indicates that there is an inconsistency in the table SCPRSKEYS related to a Business Configuration (BC) Set. This error typically arises when there are issues with the configuration data or when the BC Set has not been properly activated or transported.
  Cause:
  
  Inconsistent Data: The data in the SCPRSKEYS table may be corrupted or inconsistent, possibly due to incomplete transport or activation of the BC Set.
  Missing Entries: Required entries in the table may be missing, leading to inconsistencies.
  Transport Issues: If the BC Set was transported from one system to another, there may have been issues during the transport process that caused data to be incomplete or inconsistent.
  Manual Changes: Manual changes to the configuration data or the BC Set can lead to inconsistencies.
  
  Solution:
  
  Check BC Set Activation: Ensure that the BC Set has been properly activated. You can do this by navigating to the relevant transaction (e.g., SCPR20 for BC Set management) and checking the status of the BC Set.
  Re-activate the BC Set: If the BC Set is not activated or is in an inconsistent state, try re-activating it. This can often resolve inconsistencies.
  Check for Missing Entries: Use transaction SCPR20 to check for any missing entries in the SCPRSKEYS table. If you find any discrepancies, you may need to manually correct them.
  Transport Logs: Review transport logs to identify any issues that occurred during the transport of the BC Set. If there were errors, you may need to re-transport the BC Set.
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error. There may be patches or updates available that can resolve the issue.
  Database Consistency Check: If the issue persists, consider running a database consistency check to identify and rectify any underlying database issues.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with transaction codes like SCPR20 (for managing BC Sets) and SCPR3 (for BC Set transport).
  SAP Support: If you are unable to resolve the issue, consider reaching out to SAP Support for assistance. Provide them with detailed information about the error and any steps you have already taken.
  Documentation: Review SAP documentation related to Business Configuration Sets and their management for further insights.
  
  By following these steps, you should be able to identify and resolve the inconsistency in the SCPRSKEYS table related to the BC Set.