How To Fix E0036 - EDI: Error with database insert/update in table EDID4

E0036 - Overview

• Message type: E = Error

• Message class: E0 - SAP EDI messages

• Message number: 036

• Message text: EDI: Error with database insert/update in table EDID4

What causes this issue?

When creating an IDoc an error was reported by the database when
inserting or updating data records in table EDID4 for IDoc number &v1&.

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?

Contact your systema dministration.

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 E0036 - EDI: Error with database insert/update in table EDID4 ?

  The SAP error message E0036, which indicates an "EDI: Error with database insert/update in table EDID4," typically arises during the processing of Electronic Data Interchange (EDI) messages. This error suggests that there was a problem when the system attempted to insert or update data in the EDID4 table, which is used to store EDI data.
  Causes:
  
  Database Locking Issues: The table EDID4 might be locked by another process, preventing the current transaction from completing.
  Data Integrity Violations: The data being inserted or updated may violate constraints (e.g., primary key, foreign key, or unique constraints) defined on the EDID4 table.
  Insufficient Authorizations: The user or process attempting the operation may not have the necessary authorizations to perform the insert/update.
  Database Issues: There could be underlying database issues, such as corruption or connectivity problems.
  Configuration Errors: Incorrect configuration settings in the EDI subsystem or related modules may lead to this error.
  
  Solutions:
  
  Check Database Locks: Use transaction codes like SM12