How To Fix ER069 - Database inconsistency in city &1

SAP Error Message - Details

• Message type: E = Error

• Message class: ER - IS-U regional structure

• Message number: 069

• Message text: Database inconsistency in city &1

What causes this issue?

You have attempted to create a city with city number &v1&.
However, grids (EADRCITYGRID records) already exist for this city
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 ER069 - Database inconsistency in city &1 ?

  The SAP error message ER069, 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 entries, or issues during data migration or updates.
  Cause:
  
  Data Corruption: The database may have corrupted entries for the specified city.
  Incomplete Data: There may be missing or incomplete records for the city in question.
  Data Migration Issues: If data was migrated from another system, inconsistencies may have been introduced.
  Custom Development: Custom programs or enhancements may have inadvertently caused inconsistencies in the city data.
  
  Solution:
  
  Check Database Entries: Use transaction codes like SE16 or SE11 to check the relevant database tables (e.g., T005 for countries and cities) for inconsistencies or missing entries.
  Data Correction: If you identify any inconsistencies, correct the data directly in the database or through the appropriate SAP transaction.
  Consistency Check: Run consistency checks using transaction codes like SARA or other relevant tools to identify and fix inconsistencies in the database.
  Transport Requests: If the issue arose after a transport request, check the transport logs for errors and ensure that all necessary objects were transported correctly.
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error or provide guidance on resolving it.
  Consult with Basis Team: If the issue persists, consult with your SAP Basis team to check for any underlying database issues or to perform a database repair if necessary.
  
  Related Information:
  
  Transaction Codes: SE16 (Data Browser), SE11 (Data Dictionary), SARA (Archive Administration).
  Tables to Check: T005 (Countries and Cities), T005U (City Codes).
  SAP Notes: Search for specific SAP Notes related to ER069 or database inconsistencies in the SAP Support Portal.
  Documentation: Review SAP documentation for data management and consistency checks.
  
  If the problem continues after following these steps, it may be necessary to escalate the issue to SAP support for further assistance.