In LTRC, Loaded table turned out to be "tablename_1"

[Former Member]

I used LTRC to load some tables, some of them failed. I can't clean up the failed table from the table overview. Maybe because I reload the tables again, there  were some load table named previous tablename plus "_1".

Two questions:

1. How these "_1" tables appeared and how to solve them?

2. How to clean up the failed tables to restart the whole load process?

Thanks a lot!

[candy_zhan]

Hi Levi,

When SLT replicates a table, an internal ABAP name will be generated in capitals, which maps to the native name in source system.
This information will be stored in table DMC_DB_TAB_MAP. When you replicate a table which name in capitals has already in table DMC_DB_TAB_MAP,
the new one will be add a suffix _1.

To solve this, check table DMC_DB_TAB_MAP, delete the duplicate entry if you are sure you do not need it,
and replicate the table again.

If you would like to know more SLT mapping procedure, maybe my blog can help a little bit.
http://scn.sap.com/community/replication-server/blog/2015/03/02/how-to-replicate-tables-from-non-aba...

Regards,
Candy

[Former Member]

Hi Candy,

Thanks a lot for reply! I have already know how the "_1" problem appear. But do you know how to clean up the failed tables in the tabel overview tab  to restart the whole load process?

Best Regards,

Levi

[Saritha_K]

Hi Levi,

Can you please try to stop your replication by giving the same table name eg TCLM_WF_POLICY_1 (TCODE-LTRC->Table Overview->Data provisioning)?

Let us know if it worked for you or not.

Regards,

Saritha

[Former Member]

Hi Saritha,

It does not work although I tried several times. So this is exactly my urgent question: how to clean up the failed tables.

Best Regrads,

Levi

[Saritha_K]

Hi Levi,

Can you please try with below step-

LTRC-> tab Processing steps->delete objects section->

try with below two options --

ie

delete load/replication objects

delete runtime generated objects?

Regards,

Saritha

[Former Member]

Hi Sartitha,

Thanks for your attention but sorry to tell you, it doesn't work.

Best Regards,

Levi

[candy_zhan]

Hi Levi,

Loading of those tables were failed, can you send me the error message in application logs?

Also you can try to manually delete the relevant entries from

IUUC_RS_ORDER,

IUUC_RS_STATUS,

IUUC_TABLES,

DMC_MT_TABLES,

tables and reset the table loading.

Let me know the result.

Best regards,

Candy

[Former Member]

Hi Candy,

Your solution really works.  Thanks a lot for your attention and help!

Best regards,

Levi