How To Fix ER069 - Database inconsistency in city &1


ER069 - Overview

  • Message type: E = Error

  • Message class: ER - IS-U regional structure

  • Message number: 069

  • Message text: Database inconsistency in city &1

  • Show details Hide details
  • 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

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
The AI Support Assistant is great. It provides comprehensive assistance even on the most difficult issues. I highly recommend this service.
Rate 1
John Jordan
SAP Consultant & Author