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 · Accepted solution]

Hi,

I found out what the issue here is. Basic table creation is failing in the ERP system via SE11 transaction, It's not because of authorization, It's because of DB inconsistency. We are looking at the DB trace.

I think this is nothing to do with SLT replication. Once we are able to create the DB table via SE11, I'll try replicating the tables. Hopefully this will solve the issue.

Regards,

Dev