DD02L is not in "Replicate" status and can not replicate other tables

[Former Member]

Hi all,

After I complete SLT installation and configure data replication from ECC to HANA, I found that DD02T and DD08L can replicate succssfully and data is correct.

DD02L also have the data in hana but the status is not "Replicate".

I tried to replicate data such as BSEG and other tables to HANA, I can create the replicate jobs, but no table is replicated to HANA and status is always "Scheduled", I tried many times to delete triggers and configurtions, the result is always the same.

Does anyone meet the problem and give me some suggestions? Thanks!

My version:

ECC 6.06 SAP_BASIS 731 DMIS_2011 SP7

SLT  7.4   SAP_BASIS 740 DMIS_2011 SP7

SAP HANA SPS9 Rev90

Many thanks!

Mike

[Former Member]

Hi Mike,

Remove the table-DD02L from LTRC by using Stop Replication.Then try to add this table manually using Start Replication through SLT.

Regards,

Joydeep.

[Former Member]

Hi Joydeep,

Many thanks!

After 2 hours the DD02L table is changed in "replicate" status.

But with high latency, I tried to replicate other tables, still the same without creating trigger in source system or with high latency.

From the data records to see that SLT load all clients' data.

From the time to see that SLT replicate data with high latency even only several records.

Any suggestions?

Thanks

Mike

[tobias_koebler]

Did you make a proper sizing and your network connection is fast enough?

Best, Tobias

[Former Member]

Hi Mike,

How many Background jobs are you having in SLT as well as in Source Systems?

Regards,

Joydeep.

[Former Member]

Hi Tobias,

Actually I use the training system of ERP to load data with less than 100 records of the selected table. The network is about 1000M.

I also found that it is used less than 10 secords to load all the data of DD02L, but the status is "load", after 2 hours later, the status changed to "replicate".

I am very confused about the status.

Thanks

Mike

[Former Member]

Hi Joydeep,

Thanks for your response.

Actually I use the training system of ERP to load data with less than 100 records of the selected table. The network is about 1000M.

Almost no other user use the system.

Thanks

Mike

[Former Member]

Hi Mike,

I am not asking about the Dialog users in your system..

Can you please check the SM* tcodes in SLT & ERP how many Background jobs you are having?

Also what is the number of jobs you have set for Initial Load,Data Transfer?

Regards,

Joydeep.

[Former Member]

Hi Joydeep,

I just checked the information of the jobs, sorry for late response because of travel.

Before the job is about 8 data transfer.

After changed the jobs to 2, it works successfully, thanks for your help.

Thank you

Mike