How To Fix ER070 - Database inconsistency in street &1

SAP Error Message - Details

• 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 or restore from a backup if available.
  Transaction Code: Use transaction codes like SE11 (Data Dictionary) or SE16 (Data Browser) to investigate the underlying database tables for inconsistencies.
  Check Custom Code: Review any custom code or enhancements that may affect address data to ensure they are functioning correctly.
  SAP Notes: Search for relevant SAP Notes in the SAP Support Portal that may address this specific error or provide patches.
  Consult Documentation: Review SAP documentation for address management to ensure that all configurations are correct.
  Contact SAP Support: If the issue persists, consider reaching out to SAP Support for assistance, providing them with detailed information about the error and the context in which it occurs.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as SE11, SE16, and SE78 for data inspection and management.
  SAP Notes: Regularly check for SAP Notes related to address management and database inconsistencies.
  Data Consistency Checks: Implement regular data consistency checks as part of your data management strategy to catch issues early.
  Backup Procedures: Ensure that you have a robust backup and recovery procedure in place to mitigate data loss.
  
  By following these steps, you should be able to identify and resolve the underlying cause of the ER070 error in SAP.