Cannot create logging table &1; table exists with different structure
Message type: E = Error
Message class: CNV_IUUC_DB_CONN - db connection
Message number: 084
Message text: Cannot create logging table &1; table exists with different structure
What causes this issue?
SAP LT Replication Server tries to create a logging table in the source
system, but a table with the same name already exists in the source
system. The structure of the existing table is different to the
structure of the table that the SAP LT Replication Server is trying to
create.
You can display the structures of the tables and check the difference as
follows:
+,,In LTRC -> Expert Function -> Display Table Information, you can
display the structure of the existing logging table.
+,,In LTRC -> Expert Function -> View Trigger Source Code, choose
Generated Code for the source table to display the triggers that should
be generated for the source table. The fields that are shown in the
generated triggers are the logging table fields that the SAP LT
Replication Server is trying to create.
The system issues an error message and will not allow you to continue with this transaction until the error is resolved.
System Response
The system does not create the logging table.
How to fix this error?
If you have connected a source system to two SAP LT Replication Server
systems, it is possible that both SAP LT Replication Server systems use
the same logging table name for two logging tables that are different.
We recommend only connecting a source system to only one SAP LT
Replication Server system. If you cannot avoid connecting a single
source system to multiple SAP LT Replication Server systems, follow the
solution provided in SAP Note 1892481. You must then identify the entry
in table IUUC_LOGTAB_ID in the SAP LT Replication Server system which
corresponds to the failed logging table (providing the mass transfer ID
and the name of the table), and delete this entry.
If you are only using one SAP LT Replication Server system, and the
source table is used by other configurations, all configurations will
share the same logging table. This means that the logging table
structure must be the same for all configurations. This is not the case,
for example, if some configurations have specific settings to improve
performance, but other configurations do not have these settings. Either
all configurations must use the same settings to improve performance, or
none of the configurations can use these settings.
This error can also occur when the source system is a copy of some other
system and still contains the obsolete SAP LT Replication Server data of
the original system. After a system copy, you have to clean up obsolete
SAP LT Replication Server data before you can use it as a source system
for SAP LT Replication Server.
Procedure for System Administrators
Error message extract from SAP system. Copyright SAP SE.
Related Error Messages
CNV_IUUC_DB_CONN083 Table &1 already exists in schema &2 with different structure
CNV_IUUC_DB_CONN082 Table &1 already exists in DDIC with different structure
CNV_IUUC_DB_CONN085 Logging table &1 already exists in schema &2
CNV_IUUC_DB_CONN086 Error creating logging table &1 for table &2: Failed to create index