How To Fix 6Z901 - Inconsistent dataset leads to division by zero

SAP Error Message - Details

• Message type: E = Error

• Message class: 6Z - Message Class for Error Log of Rate/Price Valuation

• Message number: 901

• Message text: Inconsistent dataset leads to division by zero

What causes this issue?

The dataset is inconsistent.

System Response

Valuation cannot be executed for this position.

How to fix this error?

Execute the 'Update Planned Records' or 'Update Securities Account Cash
Flow' functions. Notify SAP if the message still appears.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message 6Z901 - Inconsistent dataset leads to division by zero ?

  The SAP error message 6Z901 ("Inconsistent dataset leads to division by zero") typically occurs in the context of data processing or calculations within SAP systems, particularly in reporting or analytical applications. This error indicates that the system has encountered a situation where it is attempting to perform a division operation, but the denominator is zero or is inconsistent, leading to an undefined result.
  Causes:
  
  Data Inconsistency: The dataset being processed may have missing or incorrect values, particularly in fields that are used as denominators in calculations.
  Incorrect Configuration: There may be issues with the configuration of the data model or the way calculations are defined in the report or query.
  Data Quality Issues: Poor data quality, such as null values or incorrect data types, can lead to situations where a division by zero occurs.
  Filters or Parameters: If filters or parameters applied to the dataset result in an empty set or zero values, this can trigger the error.
  
  Solutions:
  
  Data Validation: Check the dataset for any inconsistencies or missing values. Ensure that all necessary fields are populated correctly.
  Review Calculations: Examine the calculations in the report or query to ensure that they are correctly defined and that denominators are not zero. You may need to add checks to prevent division by zero.
  Adjust Filters: Review any filters or parameters applied to the dataset. Ensure that they do not lead to an empty dataset or zero values.
  Error Handling: Implement error handling in your calculations to manage cases where a division by zero might occur. For example, you can use conditional statements to check if the denominator is zero before performing the division.
  Consult Documentation: Refer to SAP documentation or support resources for specific guidance related to the version of SAP you are using, as there may be version-specific considerations.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message. SAP frequently updates its knowledge base with solutions for common problems.
  Community Forums: Engage with SAP community forums or user groups where similar issues may have been discussed. Other users may have encountered the same error and can provide insights or solutions.
  Testing: If possible, replicate the issue in a test environment to better understand the conditions that lead to the error. This can help in troubleshooting and finding a solution.
  
  By following these steps, you should be able to identify the root cause of the error and implement a solution to prevent it from occurring in the future.