How To Fix ER080 - Database inconsistency in city &1

SAP Error Message - Details

• 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 consistency checks using transaction codes like SARA or SDBA to identify and resolve inconsistencies in the database.
  Transport Requests: If the inconsistency arose after a transport, check the transport requests to ensure that all necessary objects were included and correctly transported.
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error or provide guidance on resolving it.
  Engage SAP Support: If the issue persists and you cannot resolve it, consider reaching out to SAP Support for assistance.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with transaction codes like SE16 (Data Browser), SE11 (Data Dictionary), and SARA (Archive Administration) for data management.
  Database Tables: Understand the relevant database tables, such as T005 (Countries) and T005U (City data), to effectively troubleshoot the issue.
  Documentation: Review SAP documentation and guides related to data management and integrity checks to better understand how to maintain consistency in your SAP environment.
  
  By following these steps, you should be able to identify and resolve the inconsistency causing the ER080 error message.