How To Fix ER080 - Database inconsistency in city &1

ER080 - Overview

• Message type: E = Error

• Message class: ER - IS-U regional structure

• Message number: 080

• Message text: Database inconsistency in city &1

What causes this issue?

You tried to create the city with the city number.
Grids already exist for this city number (EADRCITYGRID_NEW-SStze),
although the city does not exist.

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 ER080 - Database inconsistency in city &1 ?

  The SAP error message ER080, which indicates a "Database inconsistency in city &1," typically arises when there is a mismatch or inconsistency in the database records related to city data. This can occur due to various reasons, such as data corruption, incomplete data migration, or issues during data entry.
  
  Cause:
  
  Data Corruption: The database may have corrupted entries for the city data.
  Incomplete Data Migration: If data was migrated from another system, some records may not have been transferred correctly.
  Manual Data Entry Errors: Incorrect or incomplete entries made by users can lead to inconsistencies.
  Custom Developments: Custom programs or enhancements that manipulate city data may introduce inconsistencies.
  
  
  Solution:
  
  Check Database Entries: Use transaction codes like SE16 or SE11 to check the relevant database tables (e.g., T005 for country and city data) for inconsistencies.
  Data Correction: If you identify any incorrect or missing entries, correct them directly in the database or through the appropriate SAP transaction.
  Consistency Check: Run