How To Fix CNV_IUUC_DB_CONN137 - Other configurations use triggers with different settings

CNV_IUUC_DB_CONN137 - Overview

• Message type: E = Error

• Message class: CNV_IUUC_DB_CONN - db connection

• Message number: 137

• Message text: Other configurations use triggers with different settings

What causes this issue?

You want to replicate data from a source system, but there are other
configurations that use this source system. These configurations use
triggers that exclude different fields from the replication process. The
settings for the triggers should be the same in all configurations that
use the same source system, but this is currently not the case.

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?

If you want to create the new trigger, you must delete the triggers for
the relevant tables and recreate them. This means that if you already
have a replication running, the replication must be stopped, and a new
replication (including an initial load of the relevant tables) must be
started. To avoid repeating the initial load, you can use the report
IUUC_REDEFINE_DB_TRIGGERS. In this report, you can specify the mass
transfer ID (MT_ID), leave field Lock Timeout Value unchanged, and then
specify the relevant tables in the Table Name field. This means that you
do not need to stop and restart the replication (including dropping and
recreating triggers, and reloading the relevant tables).

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

CNV_IUUC_DB_CONN137 - Details

• The SAP error message CNV_IUUC_DB_CONN137 typically occurs during the execution of the SAP Landscape Transformation (SLT) replication process. This error indicates that there are conflicting trigger settings in the database configurations. Specifically, it suggests that other configurations are using triggers with different settings than those expected by the current configuration.
  
  Cause:
  
  Conflicting Trigger Settings: The error arises when there are multiple SLT configurations that are trying to use database triggers, but they have different settings (e.g., different trigger types, different tables, or different configurations).
  Database 
  Configuration Issues: The database may have been configured in a way that does not align with the SLT settings, leading to inconsistencies.
  Multiple SLT Configurations: If there are multiple SLT configurations pointing to the same source table, they may have been set up with different trigger settings.
  
  
  Solution:
  
  Review SLT Configurations: Check all existing SLT configurations that are related to the source table. Ensure that they are using the same trigger