How To Fix CNV_IUUC_DB_CONN133 - Trigger exists in other configurations with different settings

CNV_IUUC_DB_CONN133 - Overview

• Message type: E = Error

• Message class: CNV_IUUC_DB_CONN - db connection

• Message number: 133

• Message text: Trigger exists in other configurations with different settings

What causes this issue?

You want to replicate the table, but the trigger that records the DELETE
statements for the table also exists in one or more configurations. 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?

Identify all the configurations that contain this table, and check the
settings for the triggers in transaction LTRS (Advanced Replication
Settings) under <ZK>Trigger Settings -> Options for Archiving</>.
Ensure that the setting <ZK>Do Not Delete Corresponding Target Table
Record</> is the same for the configuration from which you want to
replicate data.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

CNV_IUUC_DB_CONN133 - Details

• The SAP error message CNV_IUUC_DB_CONN133 typically occurs during the execution of the SAP Landscape Transformation (SLT) replication process. This error indicates that a trigger already exists in the database for the specified table, but it has different settings or configurations than what is expected by the SLT system.
  
  Cause:
  
  Existing Trigger: The error arises when there is an existing database trigger on the target table that conflicts with the settings required by the SLT configuration.
  Different Settings: The existing trigger may have different parameters, such as the event it responds to (INSERT, UPDATE, DELETE), or it may be configured to work with a different replication setup.
  Multiple Configurations: If there are multiple SLT configurations or other applications that create triggers on the same table, this can lead to conflicts.
  
  
  Solution:
  To resolve the CNV_IUUC_DB_CONN133 error, you can follow these steps:
  
  
  Identify Existing Triggers:
  
  Use SQL queries to check for existing triggers on the target table. For example, in