Failed to create logging table

[devendra_am]

Hi Experts,

We have configured SLT to replicate data from ERP system to HANA instance. SLT and ERP are on a separate ABAP instances.

Replication of some tables went through successfully. Now, when a new table is added for replication, it fails with error message as:

"Failed to create logging table /1CADMC/00000242 for table AFVV".

I've tried the following options to solve the issue but none of them works:

1) From cockpit, I've   executed - 'Reset all Objects and Settings for a table' from Processing Steps tab. Later, when I start replication, it runs into same issue.

2) From cockpit, went to Expert Functions and executed 'Reset Status for Triggers and Logging Tables'. Later, executed 'Create Logging Tables ' from Processing Steps. when I start replication now, it runs into same issue.

3) So, I debugged the program related to 'Create Logging Tables'  - IUUC_REPL_PS_CREATE_LOGTAB. Here, in the method CL_IUCC_CND_RFC=>CREATE_LOGGING_TABLE, function module  IUUC_CREATE_TABLE is triggered to create log table. Upon debugging this function module  DDIF_TABL_PUT is called which returns sy-subrc  = 4.

4) I've checked the posts in SCN and couldn't find answer to this issue.

I've checked logs and ST22, there are no dumps related to this activity.

Is there a way to solve this issue?. If you need more details, please let me know.

Regards,

Dev

[sukhpreet_kaur1]

Hi, I am facing the same issue, how did you resolve it?

[devendra_am]

Hi All,

This is the complete trace while debugging. I replicated a new table, and this is where it ends up.

It's failing while trying to insert in table DD02T. There is no entry in DD02T with the logging table name. I've also checked authorization trace SU53, there is no error there.

Regards,

Dev

[Former Member]

Hello,

for my case i had to perform cleanup from iuuc_remote tcode for triggers and the logging table and then configure the sLT replication.

due to told logging tables it had some issues..

Can you check one last thing for me --> in source system check if the logging table is already existing or not ?

1. se16n or se16 --> provide table --> check description of the logging table --> it should say AFVV

Let us know

Amar