Question Re: SLT - Replication issue in Technology Q&A

SLT - Replication issue

shishupalreddy — Tue, 02 Jul 2013 12:49:54 GMT

Hello Experts ,

I have configured SLT replication .Here we have separate SLT server and the source system being R/3 and Target system HANA .

After the completion of SLT configuration I see that there are Log tables , Data base triggers activated in IUUC_SYNC_MONITOR Trasaction for that mass transfer id .

Please advise if I am mising some thing or do i need to run the replication/initial load from the same trasaction .

Thanks

Shishupal.

Re: SLT - Replication issue

shishupalreddy — Tue, 02 Jul 2013 13:04:20 GMT

Hello Experts ,

Please advise if we need to create logging tables and Activate DB triggers using the below from IUUC_SYNC_MON transaction for the first time .

Thanks

Re: SLT - Replication issue

mylesfenlon — Tue, 02 Jul 2013 13:39:46 GMT

I would suggest asking this question in the SAP HANA and In-Memory Business Data Management space, rather than here in the Developer Center. There are a lot of existing SLT discussions and blog posts available there for you to search and see if you can find someone else with these issues, and hopefully the solution too. http://scn.sap.com/community/hana-in-memory/content

Re: SLT - Replication issue

karthikeyan_natarajan4 — Tue, 02 Jul 2013 14:03:24 GMT

HI ram,

You can simple start replicating data, because once the mass transfer ID generated, logging table is created, triggers are activated, then you can go ahead with replication.

regards

kartik.

Re: SLT - Replication issue

rindia — Tue, 02 Jul 2013 14:11:41 GMT

Hi,

After creating the configuration, go to HANA studio "Data Provisioning" and you will see that for your mass transfer ID, there will be 3 tables DD02L, DD02T, DD08L.

The status for these tables must be "In Process". If not then you need to wait. Once the status has been changed to "In Process", you can click on Replicate / Load and select the tables you want to replicate.

You can see the data in replicated tables in the schema same as your SLT configuration name under Tables when the status for selected tables is "In Process"/ Completed.

Regards

Raj

Re: SLT - Replication issue

shishupalreddy — Tue, 02 Jul 2013 14:41:07 GMT

Hello Karthikeyan,

Mass transfer ID was generated , but when i see in IUUC_REPL_CONTENT the status is RED .

Also no triggers are not activated and Logging tables also not created .

Moreover I was asked to do the replication from SLT system but not from HANA studio .Please let me know if you have any idea on this .

Thanks

Shishupal.

Re: SLT - Replication issue

vivekbhoj — Tue, 02 Jul 2013 15:23:25 GMT

Hi,

As Raj explained above to check tables DD02L, DD02T, DD08L.

While creating SLT Configuration, you would have given it a name,

For that name a schema would be created in HANA System and along with that RS* tables, 3 Data Provisioning roles and the above mentioned DD* tables are also created.

So you can check all these tables under that schema

Once all these tables have been replicated successfully.

Go to Data Provisioning tab in HANA Studio Modeler and select Load/Replicate and then select the tables you want to replicate

If you select Load - only initial load will happen and no database trigger and logging tables will be generated - its a one time data load

But If you select Replcate- initial load will happen and as well as database trigger and logging tables will be generated at your ECC source - and then delta loadwill also happen

There is no need to create logging tables and Activate DB triggers using IUUC_SYNC_MON transaction for the first time .

Re: SLT - Replication issue

shishupalreddy — Wed, 03 Jul 2013 15:23:50 GMT

All , Thanks for the replies . Issue is with Source system .Applied OSS Note 1742491 and the issue is resolved .