How To Fix ER070 - Database inconsistency in street &1

ER070 - Overview

• Message type: E = Error

• Message class: ER - IS-U regional structure

• Message number: 070

• Message text: Database inconsistency in street &1

What causes this issue?

You have attempted to create a street with street number &v1&.
However, grids (EADRCITYGRID records) already exist for this street
number.

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?

INCLUDE NA_SYSADMIN1 OBJECT DOKU ID TX

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 ER070 - Database inconsistency in street &1 ?

  The SAP error message ER070, which indicates a "Database inconsistency in street &1," typically arises when there is a mismatch or inconsistency in the address data stored in the database. This can occur due to various reasons, such as data corruption, incomplete data entries, or issues during data migration or updates.
  Causes:
  
  Data Corruption: The database may have corrupted entries that lead to inconsistencies.
  Incomplete Data: Missing or incomplete address information can trigger this error.
  Data Migration Issues: If data was migrated from another system, inconsistencies may arise if the data was not properly formatted or validated.
  Custom Developments: Custom programs or enhancements that manipulate address data may inadvertently create inconsistencies.
  Incorrect Configuration: Configuration settings related to address management may not be set up correctly.
  
  Solutions:
  
  Data Validation: Check the address data for completeness and correctness. Ensure that all required fields are filled out properly.
  Database Repair: If corruption is suspected, you may need to run database repair tools